From a Schema File
No database needed. DBSprout parses a schema file (or Django models) and generates data the same way it would from a live connection.
1. Parse the schema
SQL DDL
dbsprout init --file schema.sql
DBML
dbsprout init --file schema.dbml
Prisma
dbsprout init --file schema.prisma
Mermaid
dbsprout init --file schema.mmd
PlantUML
dbsprout init --file schema.puml
Add --dry-run to preview the parsed schema without writing dbsprout.toml
or a snapshot:
dbsprout init --file schema.sql --dry-run
Django models
Introspect models directly from a Django project:
dbsprout init --django --django-apps myapp,billing
2. Generate as CSV or JSON
No database to insert into, so write files:
# CSV — one file per table, with headers
dbsprout generate --rows 500 --output-format csv
# JSON — one pretty-printed array per table
dbsprout generate --output-format json --seed 123
Output lands in ./seeds/ (override with --output-dir).
3. Validate
dbsprout validate
Next
- Schema Input — every supported format in detail
- Output Formats — JSONL, Parquet, direct insert, UPSERT