Integration · PostgreSQL · Neon · Supabase
Generate Postgres test data, with foreign keys intact
Multi-table fixtures that load into local Postgres, Neon, or Supabase with
psql and import_postgresql.sql. Free web sessions.
Short answer
Design a multi-table schema in SynthForge, generate, and download the PostgreSQL export.
You get import_postgresql.sql (CREATE TABLE with FKs plus
\\copy loaders) and per-table CSVs. Every child row references a real
parent row by construction. Point psql at local Postgres, Neon, Supabase, or RDS.
Why generate rather than hand-roll
Staging and QA databases fail when orders point at missing customers or when seed scripts drift from production shapes. Hand-rolled Faker loops become a second product.
SynthForge topological-sorts tables, generates parents first, and samples foreign keys from IDs that exist. The same schema can also feed DuckDB, MySQL, or agent workflows via hosted MCP.
How to do it
1. Define the schema
Describe tables in plain English, build them in the visual editor, or paste CREATE TABLE DDL. AI forge and SQL import both produce multi-table schemas with single-column foreign keys.
2. Set cardinality (optional)
Use relationship ratios such as "1 to 4 orders per customer" instead of inventing every child row count. Parents generate first; child foreign keys are sampled from real parent IDs.
3. Generate and export PostgreSQL
Pick PostgreSQL as the SQL dialect (or include SQL export in formats). The download ZIP contains import_postgresql.sql (CREATE TABLE with FKs plus \copy loaders) and csv/<table>.csv data files.
4. Load with psql (local or Neon / Supabase)
Extract the ZIP, cd into the folder so csv/ paths resolve, then run the import script against any Postgres that accepts your connection string.
# Local
createdb myapp_staging
psql -d myapp_staging -f import_postgresql.sql
# Neon / Supabase / RDS (connection string)
psql "$DATABASE_URL" -f import_postgresql.sql
# The script uses client-side \copy, for example:
# \copy customers FROM 'csv/customers.csv' WITH (FORMAT csv, HEADER true);
# \copy orders FROM 'csv/orders.csv' WITH (FORMAT csv, HEADER true);5. (Optional) Agent path
With an API key and hosted MCP, agents can run description_to_dataset, download the ZIP, and you still load with the same import_postgresql.sql. First API key includes 10 free credits; web sessions stay free.
# MCP endpoint: https://mcp.synthforge.io/mcp
# Auth: Authorization: Bearer sfk_live_…
# Docs: https://synthforge.io/docs/mcpFrequently asked questions
Does Postgres enforce the foreign keys?
Does this work with Neon and Supabase?
How large a dataset can I generate?
Can I use the same schema for DuckDB or MySQL?
Does SynthForge use my real production data?
Related
Ready to seed staging?
Generate multi-table Postgres data with real foreign keys, then load with one psql command. No credit card for the web app.