Skip to content
SPECIFICTION
Get listed

DataKitchen TestGen

datakitchen.io

From $100/mo Free plan Open source WebWindowsmacOSLinuxAPISelf-hosted
Visit datakitchen.io
Spec score 9.2 #1 of 16 in DataOps Platforms

What it is

DataKitchen TestGen profiles databases, generates data quality tests, and shows results and quality scores in dashboards. Its listed checks include 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, using predictive models to 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. 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. The free Open Source plan is limited to one user, one connection, and one project. Enterprise costs $100 a month, billed per user and per database connection.

Spec sheet

What it does
TestGen profiles databases, generates data-quality tests, executes them, monitors tables and produces quality scores.Read 15 Oct 2026 · docs.datakitchen.io
Purpose
TestGen profiles databases and automatically generates data quality tests, with dashboards for results and quality scores.Read 28 Sep 2026 · datakitchen.io
Intended users
The pricing page describes Open Source as being for individual data engineers and Enterprise as being for data teams.Read 28 Sep 2026 · datakitchen.io
Deployment
TestGen is self-hosted inside the customer network using Docker Compose by default or Helm on Kubernetes for production.Read 15 Oct 2026 · docs.datakitchen.io
Security
The security documentation describes HTTPS support, AES-256-CBC encryption for database credentials at rest, and enterprise SSO through OpenID Connect.Read 28 Sep 2026 · docs.datakitchen.io
Support
The open-source plan includes community support, and Enterprise includes direct DataKitchen support and priority access to releases.Read 28 Sep 2026 · datakitchen.io
Headquarters
Lexington, Massachusetts, United StatesRead 28 Sep 2026 · datakitchen.io
Founded
2013Read 28 Sep 2026 · datakitchen.io
Access control
Enterprise includes role-based access control with project-level roles, while the open-source edition uses built-in username and password authentication.Read 28 Sep 2026 · docs.datakitchen.io
AI integrations
The TestGen MCP server can connect with Claude, Claude Code, Cursor, GitHub Copilot, and Databricks Genie.Read 28 Sep 2026 · datakitchen.io
Anomaly monitoring
Its monitors cover freshness, volume, schema, and custom metrics, using predictive models to flag changes such as late arrivals and schema drift.Read 28 Sep 2026 · datakitchen.io
API documentation
A running installation serves an endpoint reference at /api/docs that reflects the installed version.Read 15 Oct 2026 · docs.datakitchen.io
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.Read 28 Sep 2026 · datakitchen.io
Automated profiling
Profiling collects column data types, contents, patterns and historical results for selected table groups.Read 15 Oct 2026 · docs.datakitchen.io
Capterra integrations
Capterra lists Slack, Tableau, Docker, Google Cloud IoT, Pentaho, StreamSets, Informatica Big Data and Amazon Redshift integrations.Read 15 Oct 2026 · capterra.com
Capterra listed price
Capterra lists a starting price of $150,000 per feature per year.Read 15 Oct 2026 · capterra.com
Company founders
Crunchbase names Christopher Bergh, Eric Estabrooks and Gil Benghiat as founders.Read 15 Oct 2026 · crunchbase.com
Crunchbase legal name
Crunchbase identifies the company as DataKitchen, Inc., a private, bootstrapped DataOps software business headquartered in Cambridge, Massachusetts.Read 15 Oct 2026 · crunchbase.com
Data access and storage
TestGen queries target databases with read-only access and stores results and metadata in its own application database.Read 28 Sep 2026 · docs.datakitchen.io
Data catalog
The catalog combines metadata, hygiene findings, PII risks, test results and Critical Data Element tags.Read 15 Oct 2026 · docs.datakitchen.io
Data residency
Database queries use read-only access and raw source data stays in the customer environment; the application database stores configuration and results.Read 15 Oct 2026 · docs.datakitchen.io
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.Read 28 Sep 2026 · datakitchen.io
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.Read 28 Sep 2026 · datakitchen.io
Gartner product description
Gartner describes DataKitchen DataOps as orchestrating, automating and monitoring analytics pipelines with testing, error tracking and version control.Read 15 Oct 2026 · gartner.com
Hygiene detection
TestGen identifies 32 categories of data-hygiene issues from profiling information.Read 15 Oct 2026 · docs.datakitchen.io
Installation
The installer supports Docker or pip, seeds demo data and opens the browser UI; Docker setup is estimated at 5–10 minutes.Read 15 Oct 2026 · docs.datakitchen.io
Licence
The core engine and open-source edition are licensed under Apache 2.0; Enterprise uses a DataKitchen subscription licence.Read 15 Oct 2026 · datakitchen.io
Limit: G2 reporting
The same G2 review said analytics reports needed better formatting and readability.Read 15 Oct 2026 · g2.com
Limits
The open-source plan is limited to one user, one database connection, and one project; the pricing page describes tables and data volume as unlimited.Read 28 Sep 2026 · datakitchen.io
LinkedIn company size
LinkedIn lists DataKitchen as privately held with 11–50 employees, founded in 2013 and headquartered in Cambridge, Massachusetts.Read 15 Oct 2026 · linkedin.com
MCP extensibility
The MCP server exposes tools for querying failures, examining rows and trends, running jobs and managing monitors for assistants such as Claude, Cursor, Copilot and Databricks Genie.Read 15 Oct 2026 · docs.datakitchen.io
Monitoring
Monitors cover freshness, volume, schema and custom metrics, using learned normal ranges for anomaly alerts.Read 15 Oct 2026 · docs.datakitchen.io
Notable dated news
DataKitchen announced a Fundamentals of DataOps training and certification program on 10 January 2022.Read 15 Oct 2026 · businesswire.com
Notifications
Issue reports and alerts can be sent by email, Slack or Microsoft Teams.Read 15 Oct 2026 · docs.datakitchen.io
Observability integration
Test results can be exported into DataKitchen DataOps Observability for combined pipeline and data-quality visibility.Read 15 Oct 2026 · docs.datakitchen.io
Praise: G2 reviewer
A G2 reviewer praised creating regulated, encrypted workstations with preconfigured tools and tests in minutes and liked the interface.Read 15 Oct 2026 · g2.com
Public API
A REST API supports profiling and test runs, dataset onboarding, test import/export, suite management and cron scheduling.Read 15 Oct 2026 · docs.datakitchen.io
Quality scoring
Scorecards and dashboards aggregate profiling and test results with drill-down to failing tests and rows.Read 15 Oct 2026 · docs.datakitchen.io
Rating on Capterra
0.0 out of 5 from 0 reviewsRead 15 Oct 2026 · capterra.com
Rating on G2
5.0 out of 5 from 1 reviewRead 15 Oct 2026 · g2.com
Rating on Gartner Peer Insights
0.0 out of 5 from 0 reviewsRead 15 Oct 2026 · gartner.com
Rating on GetApp
0.0 out of 5 from 0 reviewsRead 15 Oct 2026 · getapp.com
Rating on Software Advice
No reviews and no user rating are shown.Read 15 Oct 2026 · softwareadvice.com
Release news
The 14 October 2026 open-source 5.134.0 release added DuckDB and file sources, migration comparison, new tests, resumable profiling and expanded notifications.Read 15 Oct 2026 · docs.datakitchen.io
Security controls
Enterprise supports OpenID Connect SSO and project roles, while credentials are encrypted with AES-256-CBC and passwords are bcrypt-hashed.Read 15 Oct 2026 · docs.datakitchen.io
Supported databases
Documented sources include PostgreSQL, Aurora PostgreSQL, Redshift, Snowflake, BigQuery, Databricks SQL, Azure SQL, Synapse, SQL Server, Oracle, SAP HANA, DuckDB, OneLake and Salesforce Data 360.Read 15 Oct 2026 · docs.datakitchen.io
Supported files
TestGen reads CSV, Parquet and JSON from local paths, Amazon S3 and Azure Blob Storage, plus external-table formats such as Iceberg, Avro and ORC.Read 15 Oct 2026 · docs.datakitchen.io
System requirements
Mac and Linux installation requires Python 3.9 or newer; Docker mode requires Docker 27 or newer and Compose 5.0 or newer.Read 15 Oct 2026 · docs.datakitchen.io
Test coverage
The documentation lists 47 general test types plus 12 Commercial Pharma tests in Enterprise.Read 15 Oct 2026 · docs.datakitchen.io
Test generation
The system algorithmically selects tests and thresholds from profiling results and allows manual refinement or custom tests.Read 15 Oct 2026 · docs.datakitchen.io

Plans and prices

Open Source Free free forever 1 user · 1 connection · 1 project · unlimited tables and data volume · community support Read 15 Oct 2026 · datakitchen.io
Enterprise $100 a month per user and per database connection unlimited users · unlimited connections · unlimited projects · proprietary database support · enterprise security and access · DataKitchen support Read 15 Oct 2026 · datakitchen.io

Every DataKitchen TestGen plan and price →

Strong points and limits

Strong points

  • Profiles 55 characteristics and lists 49 test types.
  • Monitors freshness, volume, schema, and custom metrics.
  • Runs in customer infrastructure with read-only database access.
  • Free plan includes unlimited tables and data volume.
  • Supports many database systems and structured formats.

Limits

  • Open Source is limited to one user.
  • Open Source includes one database connection.
  • Open Source includes one project.
  • Enterprise is billed per user and database connection.

Who it suits

TestGen suits data engineers and data teams that need database profiling, automated quality tests, and monitoring. The free Open Source plan is described for individual data engineers; Enterprise is aimed at data teams.

DataKitchen TestGen in depth

Read the full write-up

Overview

DataKitchen TestGen is a self-hosted tool for profiling databases, generating data-quality tests, and monitoring changes. It suits data engineers and teams that want SQL-based checks inside their own infrastructure; its narrow open-source limits make the Enterprise plan the practical option for collaborative work.

Founded in 2013, DataKitchen is headquartered in Lexington, Massachusetts. TestGen can test schema migrations as well as data quality, giving database-focused teams one place to build checks and review results.

For a wider category view, see Database Testing Tools.

Key features

TestGen combines profiling with generated checks: it covers 55 profiling characteristics, 32 hygiene detector tests, and 49 test types, including generated, business-rule, and custom SQL tests. That breadth can reduce the effort of establishing baseline checks, while SQL and business rules leave room to encode team-specific expectations.

Monitors track freshness, volume, schema, and custom metrics. Predictive models flag changes such as late arrivals and schema drift, which is useful for teams that need ongoing oversight rather than one-time validation.

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. It 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. The breadth is meaningful, though file access depends on those external-table options.

The TestGen MCP server connects with Claude, Claude Code, Cursor, GitHub Copilot, and Databricks Genie. This adds an integration path for those tools without changing TestGen’s database-centered role.

Pricing

Open Source costs nothing, billed Free forever. It allows one user, one database connection, and one project, with unlimited tables and data volume and community support. That is a useful starting point for an individual data engineer, but the connection and project caps constrain even modest multi-system or multi-project use.

Enterprise costs $100 a month, billed per user and per database connection. It removes limits on users, connections, projects, tables, and data volume, and adds proprietary database support, enterprise security and access, priority releases, and DataKitchen support. It is aimed at data teams, but costs scale across both seats and connections, so expanding coverage affects the bill on two dimensions.

Platforms

TestGen supports API, Linux, macOS, web, and Windows environments, and is self-hosted 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 model that keeps deployment and data custody with the customer but makes infrastructure ownership part of the commitment.

Security documentation describes HTTPS, AES-256-CBC encryption for database credentials at rest, and enterprise SSO through OpenID Connect. Enterprise includes project-level role-based access control; Open Source uses built-in username and password authentication.

Who it's for

TestGen is a strong fit for data engineers and data teams responsible for quality across supported databases, especially when they want profiling, generated tests, migration checks, and predictive monitoring in a self-managed deployment. Individual users can explore the Open Source plan, while teams needing multiple users, connections, or projects will need Enterprise. It is less suitable for buyers seeking a hosted service or a free tier for team-wide use.

Pros and cons

Pros

Broad test coverage combines profiling, hygiene detectors, generated checks, business rules, and custom SQL.

Predictive monitoring spans freshness, volume, schema, and custom metrics, including late-arrival and schema-drift signals.

Self-hosting, read-only target access, and customer-side data custody suit organizations that want the application and data to remain in their infrastructure.

Unlimited tables and data volume on Open Source make it possible to explore substantial datasets within the one-connection, one-project, one-user boundary.

Cons

Open Source is capped at one user, one database connection, and one project, sharply limiting shared or multi-system adoption.

Enterprise is billed per user and per database connection, so broader team access and database coverage both increase cost.

Self-hosting means customers must run TestGen in their own infrastructure rather than rely on DataKitchen to host it.

File-format testing depends on supported external-table options, so format support is not independent of database configuration.

Alternatives

For broader options across data operations, browse DataOps Platforms.

Kestra is an alternative if you want a platform released under the Apache 2.0 license.

Apache NiFi is worth considering if you want software that is free to download under the Apache License, Version 2.0.

Apache Airflow is an alternative if you want Apache-licensed source code that can be downloaded and used at no cost.

Apache Hop is another free, Apache License 2.0 option; release 2.19.0 requires Java 21.

Metaflow is an Apache License 2.0 alternative, with production scaling requiring infrastructure in your own cloud account or Kubernetes cluster.

Dagster is another option if you want its open-source core orchestration framework.

Prefect offers a free Hobby plan with two users, one workspace, five deployments, 500 minutes per month of Prefect Serverless, seven-day run retention, and community support.

Keboola may suit buyers who want a free plan with one project and a monthly compute-minute allowance, then pay for additional compute.

Verdict

Choose TestGen if your data team needs database profiling, broad SQL-based quality checks, and predictive monitoring while keeping deployment and data in its own infrastructure. Its main trade-off is clear: the free edition is sharply constrained for teams, while Enterprise charges per user and connection. Look elsewhere if hosted operation or team-scale free use is a priority.

Verdict

TestGen combines profiling, generated tests, and predictive monitoring for supported data sources. Its self-hosted model and the Open Source plan’s user, connection, and project caps are key points to weigh.

Where Specifiction places it

Alternatives to DataKitchen TestGenAll alternatives →