SQL Schema In.
Realistic Test Data Out.
Stop writing mock data by hand. Paste your CREATE TABLE statement and get realistic, type-aware test data in seconds. Perfect for testing, demos, and development.
No credit card required. 100 API calls + 5,000 rows free.
See It In Action
Watch how column names become realistic data
CREATE TABLE users (
id SERIAL PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
email VARCHAR(100) UNIQUE,
phone VARCHAR(20),
created_at TIMESTAMP
);[
{
"id": 1,
"first_name": "Sarah",
"last_name": "Johnson",
"email": "sarah.johnson@gmail.com",
"phone": "+1-555-234-5678",
"created_at": "2024-03-15T09:23:41"
},
{
"id": 2,
"first_name": "Michael",
"last_name": "Chen",
"email": "m.chen@outlook.com",
"phone": "+1-555-876-5432",
"created_at": "2024-03-14T14:56:12"
}
]Smart Type Detection
Why Developers Choose DDL to Data
Built for modern development workflows
Instant Generation
Get realistic test data in milliseconds. No configuration needed - just paste your DDL.
Smart Type Detection
Automatically generates appropriate data based on column names: emails, phones, addresses, dates.
REST API
Simple API that integrates with any language or framework. Perfect for CI/CD pipelines.
Foreign Key Support
Define relationships between tables and generate consistent, referentially-intact data.
Save Schemas
Store your schemas and regenerate data anytime. Build a library of test datasets.
Try Without Signup
10 free API calls without creating an account. Test the service instantly.
How It Works
Three steps to realistic test data
Paste Your DDL
Copy your CREATE TABLE statement from any SQL database. We support PostgreSQL, MySQL, and SQLite syntax.
POST /schemas
{ "name": "users", "ddl": "CREATE TABLE..." }Call the API
Make a simple GET request with your desired row count. Authentication via API key header.
GET /generate/users?rows=100 X-API-Key: your_api_key
Get JSON Data
Receive an array of realistic, type-appropriate records ready to insert into your database.
[{ "id": 1, "email": "...", ... }]Simple, Transparent Pricing
Start free, scale as you grow
Pro
- Unlimited API calls
- 250,000 rows/month
- Priority support
- Advanced data types
Need more? View Enterprise pricing
Ready to stop writing mock data?
Join developers who save hours every week with automated test data generation.
Common Use Cases
Database Testing & QA
Populate test databases with realistic data for integration tests, load tests, and QA environments.
Development Environments
Seed local databases with meaningful data so developers can build and test features effectively.
Demos & Presentations
Create compelling product demos with professional-looking data instead of obvious fakes.
CI/CD Pipelines
Automate test data generation in your build pipeline. Fresh, consistent data for every run.