Mock Data Generator
Generate realistic fake records for testing — names, emails, dates, IDs, lorem — exported as JSON, CSV, or SQL INSERTs.
Schema
How to use
- Define your schema — name each field and pick a data type.
- Set how many rows you need.
- Pick the export format (JSON / CSV / SQL).
- Click Generate, then copy the result.
About this tool
ShowHide
Build a table of realistic-looking fake records — names, emails, usernames, addresses, dates, numbers, booleans and IDs — pick how many rows you want, and export as JSON, CSV or SQL INSERT statements. It is for filling a table so you can see how a UI behaves with a hundred rows instead of three, for a database seed, for a fixture in a test. Generated addresses use the example.com domain, which is reserved by the standards body precisely so it can never belong to anyone, so nothing you paste into a form or a seed script can accidentally reach a real inbox. Nothing here is real data: no rows are fetched from anywhere and nothing you generate is uploaded.
Frequently asked questions
How realistic is the data?
Realistic enough for development and seeding: names blend common first / last name pools, emails follow firstname.lastname@example.com, phones use a placeholder country code. It's not statistically representative — don't use for analytics tests.
Where does the data come from?
Built-in static lists baked into the page bundle. No API, no rate limits, fully offline once the page loads.
Can I get repeatable output?
Not in this version — every Generate call produces fresh random data. For deterministic test fixtures, generate once and save the output.
Why no PII like real social security or credit card numbers?
Generating realistic-looking PII risks accidental use against real systems. The tool sticks to obviously-fake data so accidents are caught.
Related tools
Random User Profile Generator
Generate a fully fake person — name, email, phone, address, date of birth, company — for placeholder content, mockups, or test data.
Random
JSON → SQL INSERT
Turn a JSON array of objects into INSERT statements — PostgreSQL, MySQL, SQLite, or ANSI quoting, with an optional ON CONFLICT upsert tail.
Convert
Random IP & MAC Generator
Generate batches of random IPv4, IPv6, or MAC addresses for tests and mocks — public / private / ULA / link-local / UAA / LAA scopes supported.
Random
CSV → SQL INSERT Generator
Convert CSV / TSV rows into SQL INSERT statements with table name, dialect quoting, type inference, and multi-row mode.
Convert
JSON → TypeScript Interface
Generate TypeScript interfaces from any JSON sample — types are inferred recursively and named after each key.
Developer
String Escape Converter
Escape a string for 10 contexts at once — JavaScript, JSON, HTML entities, URL, SQL, regex, Bash (single/double quote), C string, Unicode \u escapes.
Developer