What is a mock data generator?
A mock data generator creates fake but realistic records for development and testing. Using invented data instead of real customer information keeps privacy rules intact, and having plenty of varied rows exposes layout and performance problems that three hand-typed examples never would.
Add fields, give each a name and type, such as full name, email, city, date, price, status or UUID, and choose how many rows you need. Output appears instantly as pretty JSON, CSV, SQL INSERT statements for a table you name, or NDJSON, ready to copy or download.
How to use the Mock data generator
1.Define fields
Name each column and choose one of 26 data types.
2.Set rows and seed
Up to 5,000 rows; the same seed gives the same data.
3.Pick a format and download
JSON, CSV, SQL INSERT or NDJSON.
Example: three customers, seed 42
Fields id, name, email, city, country, plan, signed_up and spend:
- Row 1
- Lucas Reddy, lucas.reddy@example.org, Tokyo, Japan
- Row 2
- Sofia Patel, sofia.patel@example.org, Kolkata, India
- Same seed again
- identical rows every time
Believable records for a demo, with no real person's data involved.
Realistic and consistent
Each row is one coherent made-up person: the email is built from the name, and the country matches the city. Names mix Indian and international examples, phone numbers use Indian mobile formats, and dates fall within the last two years.
Emails and websites use the reserved example.com, example.org and .example domains, which can never belong to anyone, so test messages can't reach a real inbox. A fixed seed means the same settings always produce identical rows, keeping tests and screenshots repeatable.
Frequently asked questions
Are these real people's details?
No. Every value is randomly combined from built-in lists.
Which SQL dialect is the output?
Standard INSERT syntax that works in PostgreSQL, MySQL, SQLite and SQL Server.
What is NDJSON?
One JSON object per line, used for streaming and bulk imports.
Is anything uploaded?
No. Data is generated locally.
Related tools
JSON Formatter & Validator
Pretty-print, minify, sort and validate JSON with line-numbered errors.
CSV & JSON to SQL INSERT Generator
Turn CSV or JSON rows into SQL INSERT statements.
JSON Schema generator
Generate a JSON Schema from sample JSON, with formats and required fields.
Regex Tester
Test JavaScript regular expressions with live highlighting, groups and replace.
Text Diff Checker
Compare two texts by line, word or character and see what changed.
Cron Expression Explainer
Translate a cron schedule into plain English and see its next run times.
More Developer tools
JSON & data
CSV tools
Network & system
Web & API
Git & releases
Encoding & security
- Base64 encode & decode
- URL encode & decode
- JWT decoder
- Hash generator
- HTML entity encoder
- Text to binary
- Morse code translator
- Caesar cipher & ROT13
- Random string generator
- Secret key generator
- 2FA code generator (TOTP)
- Encrypt & decrypt text
- Encrypt & decrypt files
- SSH key generator
- Base32 encoder and decoder
- Unicode escape converter
- Nano ID generator
- JWT generator