At a glance
| Supported databases | JDBC sources: warehouses, data lakes, Hadoop, flat files; 200+ connectors cited |
| Data generation | Not a data generator; it validates existing data |
| Masking | Not a masking tool |
| Referential integrity | Not documented as a feature; tests are written as source and target queries |
| CI/CD integration | 80+ API calls (Swagger), webhooks, Azure DevOps extension |
| Test automation | Scheduled and API-triggered QueryPair suites with result reporting |
| Data volume or subsetting | Parallel agents for large comparisons; no subsetting |
| Deployment | Self-hosted on Windows or Linux; pay-as-you-go in AWS and Azure; Docker agents |
| Licensing | Published USD prices: $6,006 per Full User per year (min 2) or $12,642 perpetual |
QuerySurge is built for QA teams that test data warehouses and migrations by writing paired source and target queries and running them at scale. Unusually for this market, RTTS publishes list prices, and a two-user subscription starts at about $12,000 a year, so it is a serious team purchase rather than a developer utility.
Overview
QuerySurge automates data testing by running a QueryPair: a query against the source and a query against the target, whose results are compared row by row and column by column. It is used for ETL and data warehouse testing, big data and data lake testing, data migration testing and BI report testing, and RTTS cites more than 200 data connectors through JDBC. Tests can be grouped, scheduled and run from the web interface or through more than 80 API calls documented in Swagger.
The architecture has an application server (Tomcat), a bundled MySQL repository for tests and results, and agents that run queries against source and target systems. It installs on Windows 10 and 11, Windows Server 2016 to 2025, Red Hat Enterprise Linux 8 to 10 and Fedora, and agents can also run as Docker containers. Version 15.0 adds Mapping Studio, which turns mapping documents into tests with QuerySurge AI, and Validation Lineage, which shows requirements and test coverage as a graph.
Key features
- QueryPairs that compare source and target query results at row and column level
- QuerySurge AI that generates SQL for QueryPairs, staging queries and snippets (included with paid licences)
- Mapping Studio for linking mapping documentation to tests, and Validation Lineage for coverage gaps
- BI Tester module for validating report data in BI tools (extra cost)
- DevOps for Data: 80+ REST API calls with Swagger docs and webhooks for CI/CD pipelines
- Agents that run tests in parallel, installable on Windows or Linux or as Docker containers
- Scheduling, dashboards and result reporting in a web interface
Integrations and ecosystem
Pros and cons
Pros
- Published list prices for users, modules and packages
- Purpose-built for source-to-target data comparison across many platforms
- API and webhooks make it usable as a CI/CD gate for data pipelines
- Choice of perpetual or subscription licences and cloud pay-as-you-go
Cons
- High entry cost compared with open source data testing libraries
- Some package totals on the pricing page do not reconcile, so the final price needs confirming
- Tests are SQL query pairs, so testers need solid SQL skills or must rely on the AI query generation
- Does not generate, mask or subset test data
Pricing
QuerySurge publishes list prices in USD. A named Full User is $6,006 per year on subscription (minimum 2 users) or $12,642 perpetual, and a named Participant User is $514 per year or $1,082 perpetual; floating users cost more ($18,963 perpetual per Full User). Perpetual licences carry 18% annual maintenance. Named subscription packages are Group (5 full and 10 participant users) at $23,401, Team (10 and 20) at $42,439 and Division (25 and 50) at $83,947 per year. BI Tester is an extra $4,591 per year ($9,665 perpetual); QuerySurge AI, Mapping Studio and Validation Lineage are included. Pay-as-you-go packs in AWS and Azure start at $1.83 per hour for 2 users; the pricing page counts the cloud infrastructure (from $0.25 per hour) inside that hourly figure. Some specialty package totals on the same page do not add up, so confirm the final quote with RTTS.
Pricing checked on the vendor's official page on 7 November 2026. Prices change; confirm before buying.
Who it is best for
QA and data engineering teams that need repeatable source-to-target validation for ETL, warehouse, migration and BI projects.
Typical use cases
- Validating that an ETL job loaded every row and value correctly into the warehouse
- Proving a database migration copied data without loss before cut-over
- Checking that BI report figures match the underlying warehouse data
- Running data regression tests as a gate in a CI/CD pipeline
Who should look elsewhere
- Teams that need test data created or masked, not validated: see Tonic.ai or GenRocket.
- dbt-centred teams that want free, code-based data tests: see dbt tests or Great Expectations.
Verdict
QuerySurge is a mature, specialised choice for teams whose testing job is proving that data moved correctly between systems, and its published prices make budgeting easier than with most rivals. The cost is high for small teams, and engineering-led teams that already use dbt or Python may get similar assurance from open source tests or from Datafold.
Frequently asked questions
How much does QuerySurge cost?
RTTS lists a named Full User at $6,006 per year on subscription (minimum two users) or $12,642 perpetual plus 18% annual maintenance, and a Participant User at $514 per year. Packages start with Group (5 full and 10 participant users) at $23,401 per year. Pay-as-you-go in AWS or Azure starts at $1.83 per hour, which the pricing page says includes the cloud infrastructure.
Is there a free trial?
Yes. QuerySurge offers a 1-day cloud trial, a 15-day downloadable trial and a 45-day proof of concept.
How does QuerySurge compare with Datafold?
QuerySurge tests data with paired source and target SQL queries, runs self-hosted or in AWS and Azure, and publishes per-user prices. Datafold is a data diffing and data quality tool aimed at data engineering teams; see its own profile, and compare the two on the systems you need to test, how tests are written and total cost.
Which operating systems does QuerySurge run on?
Windows 10 and 11, Windows Server 2016, 2019, 2022 and 2025, Red Hat Enterprise Linux 8, 9 and 10, and Fedora, per its system requirements article. Agents can also run in Docker containers.
Sources
- QuerySurge home page
- QuerySurge licensing and pricing
- QuerySurge product architecture
- QuerySurge system requirements
- Adding agents using Docker
- What's new in QuerySurge 14.2
Checked November 2026.
Listed in: Database Testing & Test Data.
How we research reviews and what star ratings mean: our editorial method.