Generate Realistic Test Data
Build a custom schema and instantly generate mock JSON, CSV, or SQL data for testing — right in your browser.
Schema
About the Mock Data Generator
Whether you're populating a database for a demo, writing unit tests, or prototyping an API response, this tool generates realistic-looking fake data without ever sending anything to a server. Define the fields you need, pick a type for each, and export in the format your project expects.
Features:
- 22 field types including names, emails, addresses, UUIDs, and lorem text
- Export as JSON, CSV, or ready-to-run SQL INSERT statements
- Generate up to 1,000 rows per batch, entirely in your browser
- Reorder, add, or remove schema fields with a click
How to Use the Mock Data Generator
- Add or edit fields in the schema builder and choose a type for each
- Set min/max ranges for numeric fields if needed
- Choose how many rows to generate and pick JSON, CSV, or SQL
- Click Generate, then copy or download your data
Frequently Asked Questions
Is this data real or does it come from an API?
It's entirely fake. Every value is generated locally in your browser using JavaScript's Math.random() and a small built-in word bank — nothing is fetched from a server or API.
How many rows can I generate at once?
Up to 1,000 rows per generation. For larger datasets, generate in multiple batches and combine the output.
Can I generate SQL for any database?
The generated INSERT statements use standard ANSI SQL syntax, which works with MySQL, PostgreSQL, SQLite, and most other relational databases with little or no adjustment.
Is the generated data based on real people?
No. Names, emails, addresses, and every other value are assembled from generic word lists and random numbers — there's no connection to real individuals or organizations.
What happens to the schema I build?
Nothing leaves your device. Your field definitions and generated output live only in your browser's memory and disappear when you close or refresh the page.
Can I use this data in production?
No — it's randomly generated test data intended for development, demos, and QA. Don't use it as a substitute for real user records or production content.
Privacy
All data generation happens locally in your browser. No schema, field names, or generated rows are ever uploaded or stored on our servers.