FakeData Pro

Database-native test data generation

PostgreSQL MySQL SQLite ClickHouse
pro demo

Use cases

Deterministic test data with seeds and CSV output. Reproduce the same results every time for reliable test suites.

Testing

Try it yourself:

$ fakedata --seed 42 -n 10 -H email country

Quick mock data for APIs with NDJSON. Choose from 80+ built-in generators including names, emails, URLs, and even dinosaurs.

Development

Try it yourself:

$ fakedata --format ndjson -n 3 name email company

Stream thousands of rows to test database performance and API limits. Pipe to a file, count lines, and stop when ready.

Load testing

Try it yourself:

$ fakedata --stream email country | head -5

Custom Go templates for any output format. Define your own schema and generate JSON, YAML, or any text.

Custom output

Try it yourself:

$ fakedata -T user.tmpl -n 3

See exactly what would be generated before inserting a single row. The dry-run mode introspects your schema, resolves generators for every column, and prints the full plan: tables, row counts, column types, mapped generators, and FK relationships.

Dry run

Try it yourself:

$ fakedata --dsn sqlite:pro.db -t users:5 -t products:5 -t orders:10 --dry-run

Fine-tune column generators with the -c flag. Override auto-detected generators per column, set ranges for int generators, supply enum values, or pin any column to a specific generator. Supports schema.table.column syntax for full control.

Override

Try it yourself:

$ fakedata --dsn sqlite:pro.db -c orders.quantity=int:1,5 --dry-run

Get started

Free

0 for ever

80+ generators, streaming, templates, and deterministic output, all from your terminal.

  • 80+ generators
  • CSV, TSV, NDJSON output
  • Streaming & batch modes
  • Go template support
  • Deterministic seeds
Get started
Pro

Pro

Save 17%

Connect directly to your database and generate realistic data automatically.

Free during early access. Billing starts when licensing lands in November.

  • Schema introspection (Postgres, MySQL, SQLite, ClickHouse)
  • Foreign key resolution
  • Constraint enforcement
  • Direct database insertion
  • Column overrides & dry runs

Coming soon to Pro

  • Connect to Kafka with Avro/Protobuf support
  • More databases like DuckDB

Get a Pro build

Thanks. We'll email you a build, usually within a day.

Pro is in early access. No key or account is needed, and the tool never sends us your data.

What can you generate?

search for generators here
$ fakedata █

No generators match "". Try one of these:

Terms of service