DataKitchen TestGen

Overview

DataKitchen TestGen profiles databases, generates SQL-based data quality tests, and monitors data for anomalies. It suits data engineers and teams responsible for data quality across multiple systems. Its strongest case is combining profiling, checks, and monitoring in a customer-hosted deployment; the free edition’s one-connection limit makes it a narrow starting point for teams.

Founded in 2013 and headquartered in Lexington, Massachusetts, DataKitchen deploys TestGen in the customer’s infrastructure. 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, a useful fit for organizations that want to keep the application and data in their environment.

For other tools in this category, see Database Testing Tools.

Key features

TestGen combines database profiling with generated checks: it covers 55 profiling characteristics, 32 hygiene detector tests, and 49 test types. Those types include automatically generated checks, business rules, and custom SQL, giving teams both a way to surface likely quality issues and room to encode requirements specific to their data. SQL-based tests and schema migration testing make it relevant to database quality work, though the emphasis is on data checks rather than a general-purpose testing suite.

Monitoring spans freshness, volume, schema, and custom metrics. Predictive models flag changes such as late arrivals and schema drift, helping teams watch for departures from expected patterns without limiting monitoring to fixed checks. These signals still need investigation by the team responsible for the data.

Supported database systems include Snowflake, Databricks SQL, Azure Synapse Analytics, Azure SQL Database, SQL Server, OneLake, BigQuery, Redshift, Aurora PostgreSQL, Oracle Database, PostgreSQL, SAP HANA, 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 breadth is useful for teams working across warehouses and supported file-based data, but coverage depends on using those supported systems and access paths.

The TestGen MCP server connects with Claude, Claude Code, Cursor, GitHub Copilot, and Databricks Genie. That provides a route to connect the product with these AI tools, but does not replace the underlying database tests or monitoring.

Security documentation describes HTTPS support and AES-256-CBC encryption for database credentials at rest. Enterprise adds single sign-on through OpenID Connect and project-level role-based access control; the open-source edition instead uses built-in username and password authentication. That distinction matters for teams with centralized identity and granular access requirements.

Pricing

Open Source: free, billed Free forever. It allows one user, one database connection, and one project, with unlimited tables and data volume and community support. It is a no-cost way for an individual data engineer to work within those boundaries, but the single connection and project are restrictive for teams or multi-system coverage.

Enterprise: $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 DataKitchen support. The per-user and per-connection billing means costs scale with both team size and connected databases; it is the more practical tier for data teams that need broader access and direct support.

The free tier retains unlimited tables and data volume, but not unlimited users, connections, or projects. Enterprise has custom pricing for a plan without a published price.

Platforms

TestGen is available through API, Linux, macOS, Windows, web, and self-hosted deployment. Its self-hosted model keeps the application within the customer’s infrastructure, while read-only database queries limit its access to target systems.

Who it's for

TestGen is best suited to individual data engineers who can work with one connection on Open Source, and data teams that need profiling, generated SQL checks, anomaly monitoring, or schema migration tests across more systems. Teams that need enterprise access controls, SSO, direct support, or multiple connections will have a stronger fit with Enterprise. It is less suited to users seeking a hosted service or work outside its supported database and external-table options.

For a wider set of DataOps products, browse DataOps Platforms.

Pros and cons

• Pros: Profiling, multiple kinds of tests, and anomaly monitoring are brought together, so teams can investigate data quality from discovery through ongoing checks.
• Pros: Customer-hosted deployment, read-only target access, and encrypted credentials support an infrastructure-controlled approach.
• Pros: Unlimited tables and data volume on Open Source make its one-connection allowance less restrictive for a single-system evaluation.
• Cons: Open Source is capped at one user, one connection, and one project, limiting its usefulness for teams or estates spanning several databases.
• Cons: Enterprise charges per user and per database connection, so broad deployment and larger teams both affect the bill.
• Cons: Enterprise security and access features, direct support, and priority releases are not part of the free edition.

Alternatives

Choose Atlas if database migration tooling is the priority: its core engine is open-core under Apache 2.0, with advanced features available in proprietary form.

Great Expectations is another freemium option; its Developer plan is free for up to five data assets under test per month and up to three users, with unlimited rows per asset. That may suit users whose asset and user limits fit better than TestGen’s single-connection model.

Choose Soda if its free plan’s pipeline testing, metrics observability, and alerting and ticketing integrations better match your needs.

SQLancer is a free option for readers comparing database-testing tools.

utPLSQL is a free, open-source unit-testing framework and toolset for Oracle Database PL/SQL code, making it the more focused choice for that work.

Bytebase Enterprise offers a free Community plan for up to 20 users and 10 database instances, with community support; consider it if those caps better fit your needs.

DbFit is another free option.

Liquibase is a freemium alternative with a Starter plan for up to five applications and one database type, requiring a professional services package for onboarding and implementation.

Verdict

Choose TestGen if you want a self-hosted system that combines database profiling, SQL quality checks, and anomaly monitoring, and Enterprise’s per-user and per-connection model suits your team. Look elsewhere if you need several connections without a paid plan, or prefer a hosted application rather than deployment in your own infrastructure.