About Mock & Fake Data Generator – JSON, CSV, SQL
This mock data generator builds realistic fake datasets from a field schema you define — names, emails, phone numbers, addresses, companies, dates, UUIDs, numbers, and more. Pick your columns, choose how many rows you need, and export the result as JSON, CSV, or ready-to-run SQL INSERT statements.
It is built for seeding databases, populating staging environments, and writing test fixtures without hand-typing sample records or leaking real customer data. Set a seed and the output becomes fully reproducible: the same schema and seed always produce the same rows, so your fixtures stay stable across runs and commits.
Everything happens in your browser. No schema, seed, or generated record is ever uploaded — the tool works entirely offline.
Features
- Build a schema of named fields from 20+ curated types
- Export as JSON, CSV, or SQL INSERT statements
- Reproducible output with an optional numeric seed
- Up to 10,000 rows, generated locally and offline
How to use
- Add fields to your schema — give each a name and pick a data type.
- Set the row count, an optional seed, and the output format (JSON, CSV, or SQL).
- Press Generate, then copy the dataset or download it as a file.
Frequently asked questions
Is the generated data reproducible?
Yes. Enter a seed and the same schema plus the same seed will always produce identical rows. Leave the seed blank for fresh random data on every Generate.
Is my data sent to a server?
No. The generator runs entirely in your browser using the faker library, loaded on demand. Your schema and the generated records never leave your device.
What output formats are supported?
JSON (an array of objects), CSV (a header row plus escaped cells), and SQL (one INSERT statement per row). CSV cells containing commas, quotes, or newlines are automatically quoted and escaped.
How many rows can I generate?
Between 1 and 10,000 rows per run. Larger counts take a moment because every value is generated locally on your machine.
Related tools
Everything runs locally in your browser — your input is never uploaded.