Open source data quality for Azure SQL

Stop writing Azure SQL data quality tests by hand.

Point TestGen at Azure SQL Database. It profiles every table, generates thousands of tests, and flags hygiene issues on the first run. Read-only access. Free and open source.

TestGen monitors: freshness, volume, schema, and metric anomalies by table Take the product tour
Start here

Install TestGen

Pick your platform. Free and open source.

$ Select a platform above to get started.
TestGen monitors: freshness, volume, schema, and metric anomalies by table Take the product tour
  • 55data profiling column characteristics
  • 32data hygiene detectors
  • 34test types auto-generated from the profile
  • 19business rule and custom SQL test types

Connect TestGen to Azure SQL Database

TestGen runs read-only queries inside your database. It never creates, changes, or deletes anything. Sign in the way your Azure team already does.

Sign-in
SQL login, Azure Managed Identity, or an Entra ID service principal.
Permissions
SELECT on the tables you want tested. information_schema and sys.partitions are readable by default, and sys.objects shows the tables you can already select.
Every test type
Azure SQL supports UTF-8 collations, so the text-hash comparison tests run too.
Where TestGen runs
An Azure VM, a container, or any machine that can reach the database. Your data stays in your environment.
Read more

Azure SQL data problems TestGen catches

What goes wrong after a database moves to Azure and starts taking loads from new pipelines. Each card lists the TestGen checks that find it.

What TestGen does on Azure SQL

Everything below is in the open source release, and all of it works on Azure SQL Database. Enterprise adds team access, security, Commercial Pharma tests, and support.

From DataKitchen on Azure SQL

Why teams choose TestGen

  • You Don't Have Time to Write Tests. TestGen Does It Automatically.

    You're buried in customer requests. You have no time to write tests, let alone innovate. TestGen scans your data and generates the tests and anomaly detectors for you. No coding, no massive YAML configuration.

  • Moving to Azure SQL doesn’t move your data quality checks.

    TestGen profiles every column and writes the tests for you, so the database you migrated gets tested from day one.

    See how TestGen works →

  • Runs inside Azure SQL

    Tests run as read-only SQL where the data sits. Nothing is copied out, and nothing is written back.

  • Apache 2.0, core engine free

    Every detector, every characteristic, and every test type but the 12 Commercial Pharma types. In the open source.

  • Self-hosted

    Your data never leaves your environment.

  • Bootstrapped since 2013

    Profitable, independent, and not pivoting next quarter.

Open Source with Reasonable Enterprise Pricing

Open source TestGen is free for one user, one project, and one database connection. Enterprise is a flat $100 per month per user and database connection, with unlimited tables and data volume. No per-table tax. A year of enterprise data quality costs roughly one data engineer's monthly salary.

See pricing
Enterprise, per user and database connection$100/mo
Open source: one user, one project, one connectionFree

TestGen versus the competition

Head-to-head comparisons with every major data quality and observability tool. Search for the one you are evaluating.

58
See all comparisons →
Trusted by data teams at
  • Bristol Myers Squibb
  • Eisai
  • Catholic Relief Services
  • Progeny Health
  • X4
  • KOA
  • CNH

Questions

How does TestGen sign in to Azure SQL Database?

With a SQL login, an Azure Managed Identity, or an Entra ID service principal. The account needs SELECT on the tables you want tested.

Do all of TestGen’s test types work on Azure SQL?

Yes. Azure SQL Database supports UTF-8 collations, so the text-hash comparison tests run too.

Where does TestGen run for Azure SQL?

On any machine that can reach the database: an Azure VM, a container, or your own laptop. TestGen pushes its queries into the database and keeps only the results.

Does TestGen change anything in my database?

No. TestGen runs read-only SELECT queries to profile data, run tests and collect monitor metrics. It never runs INSERT, UPDATE, DELETE, CREATE, ALTER or DROP, and it stores only computed results (statistics, scores and test outcomes) in its own application database.

How do I check that an on-prem SQL Server database moved to Azure SQL correctly?

Connect TestGen to both, then compare: row counts, aggregates and per-column profiles on each side. TestGen’s table comparison tests check a target table against its source. See Prove your data migration worked.

Can I run TestGen from Azure Data Factory?

Yes. Call TestGen from a pipeline step so tests run after each load. See How to run TestGen from Azure Data Factory.

Is TestGen free?

The open source edition is free under Apache 2.0, for one user, one project and one connection, with every detector and test type except the Commercial Pharma tests. Enterprise is $100 per user per month plus $100 per database connection per month, with no per-table fees. See pricing.

The DataOps Way to Data Quality and Data Observability cover

Free book

Not ready to try it out now? Read the free book.

The DataOps Way to Data Quality and Data Observability covers why data quality keeps failing and what to do about it: culture, testing strategy, monitoring, and the seven deadly sins of AI-generated pipelines.

  • 620 pages
  • 63 chapters
  • Updated September 2026
  • By Chris Bergh, Chip Bloche, and Gil Benghiat
Get the free PDF → Ready to install? Back to the installer ↑