Deterministic Relational Seed Data & SQL Mock Fixture Generator
synthesize_seed_fixturesGenerates deterministic relational test seed fixtures that respect foreign key constraints, unique indexes, and data bounds for automated testing, staging environments, and sandbox demos.
Instructions
Generates deterministic relational test seed fixtures respecting foreign key constraints, unique indexes, and data bounds. Use when provisioning mock database datasets for automated testing, staging environments, or sandbox demos; for compiling ORM models from schemas, use generate_orm_models instead. Stateless read-only edge call (max 32 KB, 60 RPM): accepts 'schema_ddl' ('fixture_volume' defaults to 'minimal_smoke_test_5'), supports '?demo=true' or L402 (15 sats), and returns HTTP 400 if invalid.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"schema_ddl": "<schema_ddl>"
},
"name": "synthesize_seed_fixtures"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema_ddl | Yes | Target database schema DDL defining tables, column types, and foreign key relations. | |
| fixture_volume | No | Mock dataset volume profile: minimal smoke test (5), standard dataset (50), or stress dataset (500). | |
| deterministic_seed | No | Integer seed for reproducible pseudo-random data generation. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql_inserts | Yes | Executable SQL INSERT statements populated with realistic mock records. | |
| foreign_keys_satisfied | Yes | True if all foreign key dependencies and unique constraints were verified valid. | |
| records_generated_per_table | Yes | Count of generated records partitioned by target table name. |