Mock Data Generator
Generate realistic fake data — names, emails, addresses, and more — as JSON, CSV, or SQL.
How it works
Design a schema of typed columns — names, emails, addresses, dates, numbers, and more — and generate realistic-looking fake data as JSON, CSV, or SQL INSERT statements, with a live preview before you export.
- Add, remove, and rename fields, choosing a data type for each from the dropdown (grouped by category).
- Set the number of rows to generate (up to 5,000) and pick an output format.
- Click Generate to produce a preview table and full output.
- Copy the output or download it as a file.
Common use cases
- Seeding a development database with realistic-looking sample data.
- Generating fixtures for automated tests without hand-writing dozens of rows.
- Populating a UI mockup or demo with plausible names, emails, and dates instead of placeholder text.
- Producing a sample CSV/JSON dataset to test an import pipeline before using real data.
FAQ
- Is the generated data real?
- No — every value (names, emails, addresses, etc.) is synthetically generated and doesn't correspond to real people, businesses, or accounts. It's meant to look plausible for testing, not to be accurate.
- What's the maximum number of rows?
- Up to 5,000 rows per generation, which keeps generation and preview rendering fast.
- Can I set a custom fixed value for a column?
- Yes — the 'constant' field type fills an entire column with the same fixed value, useful for foreign keys or status flags in test data.