DataKitchen TestGen
datakitchen.io
- Free plan
- Open source
- Windows
- macOS
- Linux
- Web
- API
- Self-hosted
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.
Plans
Every plan and priceOpen Source
Enterprise
Free plan
Getting started
- Open the DataKitchen website
- Choose the Open Source or Enterprise plan
- Deploy TestGen in your own infrastructure
- Connect supported databases with read-only access
- Create profiling and data quality tests
- 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.