Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

DataKitchen TestGen

datakitchen.io

  • Free plan
  • Open source
  • Windows
  • macOS
  • Linux
  • Web
  • API
  • Self-hosted
8.7 Club score Visit datakitchen.io

What DataKitchen TestGen is

DataKitchen TestGen profiles databases, generates data quality tests, and displays results and quality scores in dashboards. Its listed coverage includes 55 profiling characteristics, 32 hygiene detector tests, and 49 test types, spanning auto-generated tests, business rules, and custom SQL. Monitors track freshness, volume, schema, and custom metrics, using predictive models to flag changes such as late arrivals and schema drift. Supported databases include Snowflake, Databricks SQL, BigQuery, PostgreSQL, SQL Server, and Oracle, among others. It can also profile and test structured data in Iceberg, Parquet, Avro, ORC, CSV, and JSON through supported external-table options. TestGen runs in the customer’s infrastructure; DataKitchen says it does not host the application or receive customer data. It queries target databases with read-only access and stores results and metadata in its application database. Open Source is free forever, with one user, one database connection, and one project. Enterprise costs $100 a month, billed per user and per database connection.

Who it suits

The free Open Source edition is described for individual data engineers; Enterprise is aimed at data teams. It suits organizations that want database profiling and SQL-based quality checks in their own infrastructure.

Good to know, and what to watch

  • Generates tests across 49 listed test types.
  • Monitors freshness, volume, schema, and custom metrics.
  • Runs in the customer’s infrastructure with read-only target access.
  • Free edition includes unlimited tables and data volume.
  • Open Source is limited to one user, connection, and project.
  • Enterprise is billed per user and database connection.
  • Open Source support is community support.

Open Source

Free

Enterprise

$100/mo

Free plan

Getting started

  1. Open the DataKitchen website
  2. Choose the Open Source or Enterprise plan
  3. Deploy TestGen in your own infrastructure
  4. Connect supported databases with read-only access
  5. Create profiling and data quality tests
  6. View results and quality scores in dashboards

Limits to check

Open Source is free forever but limited to one user, one database connection, and one project; tables and data volume are unlimited. Enterprise lists unlimited users, connections, projects, tables, and data volume, billed per user and database connection.

The Club's review

Overview

DataKitchen TestGen is a database profiling and data quality platform that generates checks and tracks results. It is best suited to data engineers and teams that want SQL-based quality controls while keeping the application in their own infrastructure. Its broad profiling and monitoring are compelling, but the free edition’s strict project, connection, and user caps make it a limited starting point for a team.

Founded in 2013 and headquartered in Lexington, Massachusetts, DataKitchen offers TestGen as open source and as a paid Enterprise plan. It queries target databases with read-only access and stores results and metadata in its own application database; DataKitchen says it does not host the application or receive customer data. That deployment model suits organizations that need to retain control of their environment, though it also means they run the application themselves.

For a wider view of this category, see our Database Testing Tools list.

Key features

TestGen’s profiling and generated checks give teams a way to establish quality rules from database characteristics, then add business-specific tests. It lists 55 profiling characteristics, 32 hygiene detector tests, and 49 test types, including auto-generated, business-rule, and custom SQL tests. That breadth can reduce the amount of test definition needed to get started, while SQL and business rules allow teams to encode their own expectations.

Monitoring covers freshness, volume, schema, and custom metrics. Predictive models flag changes such as late-arriving data and schema drift, which helps teams direct attention to departures from expected patterns rather than relying only on scheduled checks. Schema migration tests are also supported.

Database support spans Snowflake, Databricks SQL, Azure Synapse Analytics, Azure SQL Database, SQL Server, OneLake, BigQuery, Redshift, Aurora PostgreSQL, Oracle 12c and later, SAP HANA, PostgreSQL, and Salesforce Data 360. TestGen can also profile and test structured data in Apache Iceberg tables and Parquet, Avro, ORC, CSV, and JSON formats exposed through supported external-table options. This makes it relevant to varied database estates, though the file-format support depends on exposing the data through those external-table options.

The TestGen MCP server connects with Claude, Claude Code, Cursor, GitHub Copilot, and Databricks Genie. Security documentation describes HTTPS, AES-256-CBC encryption for database credentials at rest, and enterprise single sign-on through OpenID Connect. Enterprise adds project-level, role-based access control; the open-source edition uses built-in username and password authentication. These controls make the paid tier the more suitable choice when teams need managed access across projects.

Pricing

TestGen is freemium. Open Source costs nothing and is free forever. It includes one user, one database connection, one project, unlimited tables and data volume, and community support. That is a meaningful individual option for a data engineer evaluating the workflow or managing a single connection, but the one-user and one-project ceilings quickly rule it out for shared team use.

Enterprise costs $100 a month, billed per user and per database connection. It includes unlimited users, connections, projects, tables, and data volume, plus proprietary database support, enterprise security and access, priority releases, and direct DataKitchen support. The price scales with both users and connections, so teams should account for each when estimating cost. The higher tier is the practical choice for teams needing shared projects, multiple connections, or enterprise access controls.

Platforms

TestGen supports API, Linux, macOS, web, and Windows, and is self-hosted in the customer’s infrastructure. Its deployment and test execution are self-hosted, with SQL as the test language. Organizations gain control over where the application runs, but must provide and operate that environment themselves.

Who it's for

TestGen is a strong fit for individual data engineers who want profiling and generated quality tests without a subscription, provided one connection and one project are enough. Data teams are better served by Enterprise: its unlimited collaboration and connection allowances, project-level roles, direct support, and priority releases address needs the free edition cannot. It is less compelling for a team seeking a hosted application, since TestGen runs in the customer’s infrastructure.

Pros and cons

  • Broad profiling and test coverage: 55 profiling characteristics, 32 hygiene detector tests, and 49 test types give teams multiple ways to establish checks and monitor data quality.
  • Wide database and format support: Support for numerous database systems and structured file formats makes it suitable for mixed estates, with file formats available through supported external-table options.
  • Customer-controlled deployment: Self-hosting and read-only target-database access help organizations keep the application and data within their own infrastructure.
  • Free edition is tightly scoped: One user, one connection, and one project make it useful for an individual, not a collaborative data team.
  • Enterprise cost grows on two dimensions: The $100 a month rate is billed per user and per database connection, which teams need to include in their budget.
  • Self-hosting requires customer operation: Organizations that want DataKitchen to host and operate the application should look elsewhere.

Alternatives

For data quality checks and database profiling, TestGen is the focused choice in this group; the other options are platforms with different stated capabilities and pricing structures.

  • Kestra is an alternative for readers considering a platform released under the Apache 2.0 license; it offers a free plan and free trial.
  • Apache Airflow is a free option for readers who want software available at no cost under the Apache License.
  • Apache NiFi is a free-download option under the Apache License, Version 2.0.
  • Apache Hop is a free open-source option under Apache License 2.0; release 2.19.0 requires Java 21.
  • Metaflow is a free Apache-licensed option for readers prepared to provide production infrastructure in their own cloud account or Kubernetes cluster.
  • Prefect may suit readers seeking a freemium platform with a free Hobby tier that allows two users, one workspace, five deployments, 500 minutes per month on Prefect Serverless, and seven-day run retention.
  • Dagster is an alternative for readers considering an open-source orchestration framework with a free trial for its platform.
  • Keboola may fit readers looking for a freemium platform with a limited monthly compute allowance and paid additional compute.

For a broader category view, see DataOps Platforms.

Verdict

Choose TestGen if your priority is automated database profiling and quality monitoring while keeping deployment in your own infrastructure. The open-source edition is a credible individual starting point, but teams should expect to pay Enterprise’s per-user and per-connection rate for collaboration, broader access controls, and support. Look elsewhere if you need a hosted service or cannot accommodate those limits and operating responsibilities.

The verdict

TestGen offers broad database profiling and monitoring, with deployment kept in the customer’s infrastructure. The free edition’s user, connection, and project limits are important to consider before adopting it for a team.

Questions people ask

Is there a free plan?

Yes. Open Source costs nothing and is billed free forever.

What does Enterprise cost?

Enterprise costs $100 a month, billed per user and per database connection.

Where does TestGen run?

It is self-hosted in the customer’s infrastructure. DataKitchen says it does not host the application or receive customer data.

Which databases are supported?

Listed options include Snowflake, Databricks SQL, BigQuery, PostgreSQL, SQL Server, Oracle, Redshift, Aurora PostgreSQL, SAP HANA, OneLake, Azure SQL Database, Azure Synapse Analytics, Salesforce Data 360 and Microsoft SQL Server.

Does it support single sign-on?

Enterprise security lists SSO through OpenID Connect, along with role-based, project-level access.

What the maker publishes

Access control
Enterprise includes role-based access control with project-level roles, while the open-source edition uses built-in username and password authentication. source
AI integrations
The TestGen MCP server can connect with Claude, Claude Code, Cursor, GitHub Copilot, and Databricks Genie. source
Anomaly monitoring
Its monitors cover freshness, volume, schema, and custom metrics, using predictive models to flag changes such as late arrivals and schema drift. source
API documentation
A running installation serves an endpoint reference at /api/docs that reflects the installed version. source
Automated checks
The product page lists 55 profiling characteristics, 32 hygiene detector tests, and 49 test types, including auto-generated, business-rule, and custom SQL tests. source
Automated profiling
Profiling collects column data types, contents, patterns and historical results for selected table groups. source
Capterra integrations
Capterra lists Slack, Tableau, Docker, Google Cloud IoT, Pentaho, StreamSets, Informatica Big Data and Amazon Redshift integrations. source
Capterra listed price
Capterra lists a starting price of $150,000 per feature per year. source
Company founders
Crunchbase names Christopher Bergh, Eric Estabrooks and Gil Benghiat as founders. source
Crunchbase legal name
Crunchbase identifies the company as DataKitchen, Inc., a private, bootstrapped DataOps software business headquartered in Cambridge, Massachusetts. source
Data access and storage
TestGen queries target databases with read-only access and stores results and metadata in its own application database. source
Database integrations
Supported databases include Snowflake, Databricks SQL, Azure Synapse Analytics, Azure SQL Database, SQL Server, OneLake, BigQuery, Redshift, Aurora PostgreSQL, Oracle 12c and later, SAP HANA, PostgreSQL, and Salesforce Data 360. source
Data catalog
The catalog combines metadata, hygiene findings, PII risks, test results and Critical Data Element tags. source
Data residency
Database queries use read-only access and raw source data stays in the customer environment; the application database stores configuration and results. source
Deployment
TestGen is self-hosted in the customer’s infrastructure; DataKitchen says it does not host the application or receive the customer’s data. source
Deployment
TestGen is self-hosted inside the customer network using Docker Compose by default or Helm on Kubernetes for production. source
File formats
TestGen can profile and test structured data in Apache Iceberg tables and Parquet, Avro, ORC, CSV, and JSON formats exposed through supported external-table options. source
Founded
2013 source
Gartner product description
Gartner describes DataKitchen DataOps as orchestrating, automating and monitoring analytics pipelines with testing, error tracking and version control. source
Headquarters
Lexington, Massachusetts, United States source
Hygiene detection
TestGen identifies 32 categories of data-hygiene issues from profiling information. source
Installation
The installer supports Docker or pip, seeds demo data and opens the browser UI; Docker setup is estimated at 5–10 minutes. source
Intended users
The pricing page describes Open Source as being for individual data engineers and Enterprise as being for data teams. source
Licence
The core engine and open-source edition are licensed under Apache 2.0; Enterprise uses a DataKitchen subscription licence. source

Checked against the maker's pages on 15 Oct 2026.