Large-Volume Seeding: Seed Millions of Records

Describe what you need in plain English — Seedfast generates realistic data at any scale, directly into your database.

Seedfast generates data at whatever volume you describe. Fifty records for local development, a million for load testing — the scope is defined in natural language, and Seedfast builds a plan that matches.

Volume and realism aren't in tension. Whether you're seeding 50 rows or 5 million, Seedfast generates values that fit your domain. Names, statuses, timestamps, and relational data are inferred from your schema — not randomized.

seedfast seed --scope "seed 1 million orders with line items"

1. You describe the scope — what tables, how many records, any constraints
2. Seedfast builds a plan — analyzes your schema, resolves dependencies, determines row counts per table
3. You see a preview — table names, record counts, and descriptions
4. You approve or refine — if something's off, describe what to change; Seedfast replans without restarting
5. Data is written directly into your database — no exports, no intermediate files

If there are dependency issues — a table that needs data from another table you didn't include — Seedfast warns you before seeding starts, not halfway through.

Thirty rows won't surface the slow query that only appears at 100K. You need a database that behaves like production under realistic load.

seedfast seed --scope “seed 1 million orders with line items”

Seeding Plan:
  public.orders         — 1,000,000 records
  public.order_items    — 3,500,000 records
  public.customers      — 200,000 records

Total: 4,700,000 records across 3 tables

Approve? (Y/n)

“Orders with line items” — Seedfast resolved that customers are required to place orders and worked backward through the dependency chain automatically.

A populated database for local development: enough data to test pagination, search, and filters without using production data.

seedfast seed --scope “seed 50 users with orders and invoices”

Seeding Plan:
  public.users          — 50 records
  public.orders         — 250 records
  public.invoices       — 250 records
  public.order_items    — 800 records

Total: 1,350 records across 4 tables

Approve? (Y/n): I need more orders, at least 500

Type what you'd change instead of pressing Y. Seedfast replans:

Updated Seeding Plan:
  public.users          — 50 records
  public.orders         — 500 records
  public.invoices       — 250 records
  public.order_items    — 1,600 records

Total: 2,400 records across 4 tables

Approve? (Y/n)

The session stays alive — no restarting, no re-authenticating.

A demo database needs data that looks real — not three rows that reveal it's synthetic. The quality of generated data matters as much as the volume.

seedfast seed --scope “seed 500 customers across 3 regions with support tickets”

Seedfast catches dependency problems before writing anything:

Heads up — 1 issue to resolve before seeding

  public.support_tickets depends on public.agents which has 0 rows.
  Add public.agents to scope, or remove public.support_tickets from scope.

How would you like to proceed

Your answer: add agents too, around 20

Updated Seeding Plan:
  public.regions         — 3 records
  public.agents          — 20 records
  public.customers       — 500 records
  public.support_tickets — 1,200 records
  public.ticket_comments — 3,500 records

Total: 5,223 records across 5 tables

Approve? (Y/n)

Edge cases only appear when there's volume — and when the scope covers the whole domain.

seedfast seed --scope "seed all e-commerce tables, 10K products and 50K orders"

Scope Exceeds Plan Limit

Your scope resolves to 35 tables, but your plan allows 20 per seeding.

You can:
  Refine your scope to reduce the number of tables
  Upgrade your plan at https://seedfa.st/pricing

Describe the updated scope:
  seed only products, orders, order_items, categories, and customers — 10K products, 50K orders

Seedfast replans with the narrower scope:

Seeding Plan:
  public.categories     — 25 records
  public.customers      — 8,000 records
  public.products       — 10,000 records
  public.orders         — 50,000 records
  public.order_items    — 150,000 records

Total: 218,025 records across 5 tables

Approve? (Y/n)

No restart, no guessing which tables to cut. The whole conversation happens in one terminal session.

The scope is plain text. You describe what you want, Seedfast interprets it. The better your description, the closer the plan matches your intent.

Specific table names and counts:

seedfast seed --scope "seed 1000 users and 5000 orders"

Proportions between tables:

seedfast seed --scope "seed 100 customers, each with 10 orders"

Schema-level targets:

seedfast seed --scope "seed all tables in the billing schema, 500 records each"

Volume with relationships:

seedfast seed --scope "seed 1 million transactions with associated accounts and categories"

Tips

• Be explicit about numbers. "500 users" beats "a lot of users".
• Name the tables when you can. "seed users, orders, and products" is clearer than "seed the main tables".
• State proportions when they matter. "100 customers, each with 5 orders" gives Seedfast enough context to plan the right ratios.
• Start small, then scale. Try with 100 records first. Once the plan looks right, bump to 100K.

Before any data is written, you see exactly what Seedfast intends to do:

Seeding Plan:
  public.users          — 1,000 records
  public.orders         — 5,000 records
  public.order_items    — 15,000 records
  public.products       — 200 records
  public.categories     — 12 records

Total: 21,212 records across 5 tables

Approve? (Y/n)

Each line shows the table name and the number of records.

If the plan doesn't match — don't approve. Just type what you'd change:

Approve? (Y/n): double the products and add shipping_addresses

Seedfast replans and shows an updated preview. Repeat until it's right.

# Seedfast asks what to seed — you describe it live
seedfast seed

# Auto-approves if the plan fits your subscription
seedfast seed --scope "seed 1000 users with orders"

When you provide --scope, Seedfast skips the interactive prompt, builds the plan, and starts seeding immediately. This is how you use it in scripts and CI/CD pipelines.

If the scope exceeds limits in --scope mode, Seedfast exits with an error instead of entering interactive replan — because there's nobody at the terminal to refine.

# Default: rich terminal UI with progress bars
seedfast seed --scope "..."

# Timestamped logs for CI/CD
seedfast seed --scope "..." --output plain

# Machine-readable JSON
seedfast seed --scope "..." --output json