generate_seed_data
Generate realistic test data from a database schema, with foreign keys resolving to valid primary keys and unique constraints respected. Output as SQL INSERTs, JSON, or CSV.
Instructions
Generate realistic, referentially-coherent test data from a database schema. Foreign keys resolve to real generated primary keys, unique constraints are respected, and values are realistic (names, emails, dates). Accepts SQL DDL or a JSON schema. Returns INSERT statements, JSON, or CSV.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | Default rows per table (individual tables can override via 'rows' in JSON schema). Defaults to 10. | |
| seed | No | Deterministic seed for reproducible output. Pro feature. | |
| format | No | Output format. 'sql' (INSERT statements, default), 'json', or 'csv'. CSV is a Pro feature. | |
| schema | Yes | SQL DDL (CREATE TABLE ...) or a JSON schema with a 'tables' array. |