generate_test_data
Generate relational test data with correct foreign key references. Use structured schemas or plain English descriptions. Output in JSON, CSV, or SQL.
Instructions
Generate realistic test data for database tables.
Send either a structured schema (tables with fields) or a plain English description. Supports relational data with foreign keys, locale-aware names and addresses, 22 locales, 157 field types, and multiple output formats (JSON, CSV, SQL).
The killer feature: define multiple tables with "ref" fields, and all foreign key relationships are correct — orders reference real user IDs, reviews link to real products. One call seeds your entire database.
Auto-locale: add a "country" field as an enum with country codes (DE, FR, US, etc.) and names, emails, phones automatically match each row's nationality.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | No | Structured schema — array of table definitions | |
| prompt | No | Plain English description (e.g. "50 users with German names and 200 orders linked to them") | |
| format | No | Output format | json |
| sql_dialect | No | SQL dialect (only when format=sql) | |
| locale | No | Default locale (en, de, fr, es, ja, etc.). Auto-detected from country field if present. | |
| seed | No | Seed for reproducible output. Same seed + same schema = identical data. |