DDL to Data
Mockaroo
Generate Data
Snaplet
Random Data
TestDataHub
assertpy
grappa
DDL to Data is a developer tool that automatically generates realistic test data from SQL schemas. Simply paste your CREATE TABLE statement and get back JSON data with smart type detectionโcolumn names like "email" produce real email formats, "phone" produces phone numbers, etc. It supports PostgreSQL, MySQL, and SQLite, handles foreign key relationships for referentially-intact data, and integrates easily into CI/CD pipelines via REST API. Ideal for database testing, seeding dev environments, creating demo data, and automated test pipelines.
DDL to Data assertpyDDL to Data's answer
No LLM, no prompts, no AI costs. DDL to Data uses deterministic pattern-matching โ not machine learning โ to generate realistic test data from your SQL schema in milliseconds. It's fast, predictable, and won't hallucinate. Column named "email" produces an email, "phone" produces a phone number. Same schema, same structure, every time. Plus it handles foreign key relationships to generate referentially-intact data across multiple tables.
DDL to Data's answer
Unlike AI-powered tools, DDL to Data has zero token costs, sub-second response times, and deterministic output, critical for CI/CD pipelines. Unlike Faker libraries, it requires zero configuration: paste your CREATE TABLE and get intelligent, type-aware data without writing any setup code. It also supports multiple output formats (JSON, CSV, SQL, Parquet, Excel) and can seed data directly into your PostgreSQL database.
DDL to Data's answer
Backend developers, QA engineers, and DevOps teams who need realistic test data for database testing, seeding dev environments, CI/CD pipelines, and product demos. Particularly useful for teams who want a reliable, no-config utility that just works, without adding AI dependencies to their infrastructure.
DDL to Data's answer
Every new project meant the same tedious ritual: write the schema, then manually create arrays of fake emails, phone numbers, and timestamps. Over and over. It struck me that the schema already contains everything needed to generate realistic data, column names are semantic. "email" means email, "created_at" means timestamp. So I built an API that does the obvious thing automatically, without any AI complexity
DDL to Data's answer
FastAPI (Python) backend with PostgreSQL and SQLAlchemy. Next.js 14 frontend with TypeScript and Tailwind CSS. Hosted on AWS with Docker containers, and CircleCI for CI/CD.
DDL to Data's answer
Currently in public beta and growing organically. Early adopters include indie developers and small engineering teams using it for local development and automated testing pipelines.
Mockaroo - A realistic data generator to test your app
grappa - grappa is an declarative, verbose, and expressive assertion library for Python.
Generate Data - GenerateData.com: free, GNU-licensed, random custom data generator for testing software
Snaplet - Snaplet gives developers production-accurate data and preview databases they can code against, so they can focus on shipping. Ditch the seed script forever!
Random Data - Generate random data for testing
TestDataHub - Ultimate Tool for Test Data Generation
