Output Formats

Available Formats

SQL INSERT (Default)

dbsprout generate --output-format sql

Produces standard INSERT INTO statements compatible with any SQL database.

CSV

dbsprout generate --output-format csv

One CSV file per table, with headers.

JSON

dbsprout generate --output-format json

One JSON file per table, array of objects.

Parquet

dbsprout generate --output-format parquet

Columnar format, ideal for analytics pipelines and data warehouses.

Direct Database Insertion

# PostgreSQL (uses COPY for 100K+ rows/sec)
dbsprout generate --output-format direct --db postgresql://localhost/myapp

# MySQL (uses LOAD DATA for bulk speed)
dbsprout generate --output-format direct --db mysql://localhost/myapp

Direct insertion uses database-native bulk loading protocols for maximum throughput.

UPSERT

dbsprout generate --output-format upsert --db postgresql://localhost/myapp

Uses INSERT ... ON CONFLICT (PostgreSQL) or INSERT ... ON DUPLICATE KEY UPDATE (MySQL) for idempotent seeding.

Output Directory

By default, files are written to ./dbsprout_output/. Customize with:

dbsprout generate --output-dir ./seeds/