Mock Data Generator for Testing and Development
The Mock Data Generator creates realistic fake data on demand — names, emails, phone numbers, addresses, and 30+ other field types — so you can fill databases, prototypes, and APIs without using real records. Define a schema once, set how many rows you need, and generate a fresh dataset instantly in your browser.
It is built for developers, QA engineers, and designers who need believable test data fast. Start from a ready-made preset or build a custom schema, pick a country locale for culturally matched names and addresses, then export the result as JSON, CSV, SQL INSERT, or TSV.
How to Use the Mock Data Generator
Define your schema
Pick a Preset — User Profile, Product, Blog Post, Order, or Employee — to load a ready-made structure, or click Add Field to build your own. For each field, set a name (the column header) and choose one of 30+ data types. Drag the grip handle to reorder fields.
Configure options
Set the number of Rows (1 to 500) and choose a Locale to match a country's names, phone formats, and cities. For Number and Float fields, open the options popover to set min and max; for Custom List, enter your own comma-separated values.
Generate the data
Click Generate to build the dataset. Review every row in the live Preview table, where numeric values are color-coded and booleans show green for true and red for false.
Copy or export
Click Copy to copy the data as JSON, or open Export to download it as JSON, CSV, SQL INSERT, or TSV — ready to drop straight into your project.
Features
Visual Schema Builder
Add, rename, and remove fields, then drag the grip handle to reorder columns. Each field takes one of 30+ data types.
30+ Data Types
Generate names, emails, phones, addresses, UUIDs, dates, prices, lorem text, IPv4, hex colors, and more from a single picker.
Five Built-in Presets
Start instantly with User Profile, Product, Blog Post, Order, or Employee schemas tuned for common use cases.
Multi-Locale Data
Switch between English, Vietnamese, Japanese, Korean, French, German, Spanish, and Chinese for region-appropriate names and cities.
Configurable Field Options
Set min and max ranges on Number and Float fields, or supply your own comma-separated values with the Custom List type.
Up to 500 Rows
Generate anywhere from 1 to 500 records per batch, then re-run for a fresh set of random values any time.
Live Preview Table
See results immediately in a scrollable table with sticky headers, color-coded numbers, and green/red boolean cells.
Four Export Formats
Download as JSON, CSV, SQL INSERT, or TSV — ready for API mocking, spreadsheets, database seeding, or pasting into tables.
One-Click Copy
Copy the entire dataset as formatted JSON to your clipboard with a single button.
Fully Client-Side
All generation runs in your browser with no uploads or server calls, so your schema and data never leave your device.
Frequently Asked Questions
Is the generated data real or fake?
It is entirely fake. Names, emails, addresses, and other values are randomly assembled from curated sample pools, so they look authentic but match no real person. Each generation produces a fresh, random dataset.
Can I export to JSON, CSV, and SQL?
Yes. Use the Export menu to download your data as JSON (array of objects), CSV, SQL INSERT statements, or TSV. You can also click Copy to put the data on your clipboard as JSON.
How many rows can I generate at once?
You can generate between 1 and 500 rows per batch. For larger datasets, run the generator several times and combine the batches in your target format.
What data types are supported?
More than 30 types, grouped into identity (ID, UUID, full/first/last name, username, email, password, avatar URL), contact (phone, street address, city, country, zip code), business (company, job title, department, product name, price, category, status), data (number, float, boolean, date, date time, URL, IPv4, hex color), and text (word, lorem sentence, lorem paragraph, and Custom List).
How do I define a custom schema?
Click Add Field to insert a new field, then set its name and choose a data type. Repeat for each column you need, drag fields to reorder them, and delete any you do not want. You can also start from a preset and adjust it — editing any field switches the preset to Custom automatically.
Does changing the locale affect every field?
No — only locale-sensitive fields change, such as names, email, username, phone, street address, and city. Locale-independent types like UUID, number, boolean, and date stay the same across all locales.
Can I use the SQL output directly in my database?
The SQL export produces standard INSERT statements with backtick-quoted column names and escaped string values. The default table name is mock_data — replace it with your own table name before running the statements.
Is my data sent to a server?
No. All data generation happens entirely in your browser using JavaScript. Nothing is uploaded, stored, or transmitted to any server, and the tool works in any modern browser without plugins.
No comments yet. Be the first to comment!