DataKitchen TestGen

DataKitchen TestGen profiles databases and automatically generates data quality tests, with dashboards for test results and quality scores. It lists 55 profiling characteristics, 32 hygiene detector tests and 49 test types, including generated tests, business rules and custom SQL. Monitors cover freshness, volume, schema and custom metrics; predictive models can flag changes such as late arrivals and schema drift. 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. TestGen can also profile and test structured data in Apache Iceberg and Parquet, Avro, ORC, CSV and JSON through supported external-table options. It runs in the customer’s infrastructure, queries target databases with read-only access, and stores results and metadata in its application database. Open Source is free forever but limited to one user, one connection and one project. Enterprise costs $100 a month, billed per user and per database connection.

TestGen combines generated checks, custom SQL testing and monitoring across supported databases, while remaining in the customer’s infrastructure. The key distinction is the Open Source plan’s one-user, one-connection and one-project limit versus Enterprise’s per-user and per-connection billing.

The Open Source edition is described for individual data engineers, while Enterprise is for data teams. TestGen may suit teams that need database profiling and quality checks within their own infrastructure.

DataKitchen TestGen is a self-hosted database profiling and data-quality platform that turns observed data patterns into tests, dashboards, and quality scores. It suits data engineers and teams responsible for several SQL databases, especially where customer data must remain in-house. The open-source edition is a capable single-user starting point, while broader collaboration and enterprise controls require the paid plan.

Overview

TestGen profiles databases, generates checks, and reports results through dashboards and quality scores. Alongside generated tests, it supports business rules, custom SQL, and schema-migration tests, making it useful for both routine validation and changes to database structure.

Deployment is self-hosted in the customer’s infrastructure. TestGen connects to target databases with read-only access, stores results and metadata in its own application database, and DataKitchen says it does not host the application or receive customer data. That architecture will appeal to organizations with strict data-residency requirements, although operating the service remains the customer’s responsibility.

Founded in 2013 and headquartered in Lexington, Massachusetts, DataKitchen offers the product through a freemium model. See our Database Testing Tools list for related products.

Key features

The profiling engine lists 55 profiling characteristics and 32 hygiene-detector tests, while the product provides 49 test types. Automatic checks provide a useful starting point; business-rule and custom SQL tests let experienced teams encode requirements that profiling alone cannot infer. SQL is the test language, so teams already working in SQL can keep rules close to their database workflows.

Anomaly monitoring covers freshness, volume, schema, and custom metrics. Predictive models can flag late-arriving data and schema drift, giving teams a way to identify changes that may not violate a simple fixed threshold. Monitoring is more valuable for ongoing operations than for a one-time database audit.

Database integrations include Snowflake, Databricks SQL, Azure Synapse Analytics, Azure SQL Database, SQL Server, Microsoft OneLake, BigQuery, Redshift, Aurora PostgreSQL, Oracle Database 12c and later, SAP HANA, PostgreSQL, and Salesforce Data 360. TestGen can also profile and test Apache Iceberg tables and Parquet, Avro, ORC, CSV, and JSON exposed through supported external-table options.

The TestGen MCP server connects with Claude, Claude Code, Cursor, GitHub Copilot, and Databricks Genie. HTTPS support, AES-256-CBC encryption for database credentials at rest, and enterprise OpenID Connect SSO address core security needs. Enterprise adds role-based, project-level access control; the open-source edition uses built-in username-and-password authentication.

Pricing

Open Source — $$0, free forever: This plan is aimed at an individual data engineer. It includes one user, one database connection, and one project, with unlimited tables and data volume and community support. The unlimited table and volume allowance is generous for a personal environment, but the single-connection and single-project caps make it unsuitable for a multi-database team or shared quality program.

Enterprise — $100 a month: Billing is per user and per database connection. The plan includes unlimited users, connections, projects, tables, and data volume, plus proprietary database support, enterprise security and access, priority releases, and direct DataKitchen support. The apparent starting price can grow with both seats and connections, so organizations should size the recurring cost around their database footprint and team membership.

Choose Open Source when one engineer can work within one connection and one project. Choose Enterprise when several people need shared projects, multiple systems, stronger access controls, or vendor support.

Platforms

TestGen is offered for API, Linux, macOS, self-hosted, web, and Windows environments. Test execution is self-hosted, with the application running in the customer’s infrastructure rather than as a DataKitchen-hosted service.

Who it's for

Individual data engineers get a practical free entry point for profiling and SQL-based checks. Data teams with multiple databases, projects, or contributors are the clear Enterprise audience, particularly when OpenID Connect SSO, project-level roles, proprietary database support, and direct support matter. Teams unwilling to operate self-hosted software, or those needing more than one connection on a free plan, should look elsewhere.

Pros and cons

Pros

• Broad automated coverage: 55 profiling characteristics, 32 hygiene detectors, and 49 test types reduce the work required to establish an initial test suite.
• Flexible SQL testing: Generated, business-rule, custom SQL, and schema-migration tests cover both inferred and explicitly defined requirements.
• Wide data-system reach: Support spans major warehouses, databases, Microsoft OneLake, Salesforce Data 360, and common external-table file formats.
• Customer-controlled deployment: Read-only database access and self-hosting keep application operation and data handling in the customer environment.

Cons

• Severe free-plan limits: One user, one connection, and one project exclude most shared or multi-system deployments.
• Enterprise costs scale twice: The $100 monthly price is billed per user and per connection, which can become material for larger teams and estates.
• Self-hosting is required: Customers must run and maintain the application rather than relying on a hosted service.
• Open-source access controls are basic: Built-in username-and-password authentication lacks Enterprise’s project-level roles and OpenID Connect SSO.

Alternatives

ContextQA Database Testing is the better fit when a paid, self-hosted option with a free trial and testing across Android, iOS, web, and API environments is more important than TestGen’s free single-user edition.

Amazon Deequ is a free Apache 2.0 library for teams already using Apache Spark and willing to match its release to their Spark version.

tSQLt is a free, self-hosted open-source unit-testing framework specifically for SQL Server.

Great Expectations offers a free Developer plan capped at five data assets per month and three users, making it a different choice for teams that prefer those asset and user limits.

Soda is an alternative freemium platform with a free tier covering pipeline testing, metrics observability, and alerting integrations.

Sqitch is a free database change-management application rather than a full profiling and anomaly-monitoring suite.

Atlas is an open-core database migration tool with a free core and paid advanced features.

Bytebase Enterprise offers a free Community plan for up to 20 users and 10 database instances, with paid per-user expansion.

For broader operational coverage, browse our DataOps Platforms list.

Verdict

Choose DataKitchen TestGen if you need self-hosted, SQL-based data-quality testing across a broad set of databases and want generated checks alongside custom rules and anomaly monitoring. Its free edition is genuinely useful for one engineer, but the one-connection and one-project ceiling is the decisive limitation; teams that need collaboration, enterprise security, or multiple systems should budget for Enterprise or choose a tool whose free tier is less restricted.