Open source data quality for Microsoft

Data quality for your whole Microsoft data stack.

SQL Server, Azure SQL, Synapse, Fabric, and OneLake. TestGen 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

Every Microsoft source TestGen tests

On-prem, in Azure, or in Fabric. TestGen runs read-only queries where the data sits and stores only results. One tool for the database you run today and the one you’re moving to.

Microsoft SQL Server
On-prem, in a VM, or in a container. SQL login. Details →
Azure SQL Database
SQL login, Managed Identity, or Entra ID service principal. Details →
Azure Synapse Analytics
SQL login, Managed Identity, or Entra ID service principal. Details →
Microsoft Fabric
Lakehouse and Warehouse data, through the SQL analytics endpoint. Details →
OneLake
Every layer of your lakehouse: bronze, silver, and gold. Details →
Azure Blob Storage
CSV, Parquet, and JSON files, read in place. Details ↗
Read more

What breaks as data moves across the Microsoft stack

From SQL Server to Azure to Fabric, the same few problems follow the data. Each card lists the TestGen checks that find them.

What TestGen does across the Microsoft stack

Everything below is in the open source release, on every Microsoft source listed above. Enterprise adds team access, security, Commercial Pharma tests, and support.

From DataKitchen on the Microsoft data stack

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.

  • Microsoft gives you the platform. The tests are still on you.

    TestGen profiles every column on every Microsoft source and writes the tests, so a SQL Server-to-Fabric migration starts and ends with the same checks.

    See how TestGen works →

  • Runs inside your Microsoft databases

    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

Which Microsoft data sources does TestGen support?

Microsoft SQL Server (2019 and later), Azure SQL Database, Azure Synapse Analytics, Microsoft Fabric and OneLake (Lakehouse and Warehouse tables), and CSV, Parquet and JSON files in Azure Blob Storage.

Does my data leave my environment?

No. TestGen is self-hosted and runs its queries inside your database. It keeps only computed results such as statistics, scores and test outcomes.

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.

Which Microsoft page should I start with?

The one for the database you run today: SQL Server, Azure SQL, Synapse, Fabric or OneLake. The same install covers all of them.

Can one TestGen install test SQL Server and Fabric together?

Yes. Each is its own connection. The open source edition allows one connection; Enterprise allows as many as you pay for, at $100 per connection per month.

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 ↑