Mock Data Generator
Generate realistic fake data as JSON, CSV, or SQL.
100% in your browser — nothing uploadedGenerate fake test data as JSON, CSV or SQL
About this mock data generator
Pick the fields you need — names, emails, phone numbers, companies, job titles, cities, dates, prices — choose how many rows (up to 1,000), and generate test data as JSON, CSV, or ready-to-run SQL INSERT statements. Emails are derived from each row’s name, phone numbers follow the (555) 123-4567 pattern, and IDs come as sequential integers or real UUIDs, so the output drops straight into seed scripts, fixtures, and demos.
Unlike most generators, the name pools mix Anglo and Hispanic names — with plenty of Puerto Rican and Latin American surnames and cities — so your test users look like real users instead of twenty John Does. CSV fields are quoted and escaped correctly, SQL strings are escaped and identifiers sanitized, and everything runs locally in your browser: no account, no API key, no rate limits, nothing sent to any server.
FAQ
Does the generated data contain real personal information?
No. Every value is assembled on the fly from built-in lists of names, companies, and cities — any match with a real person is coincidence. Nothing is stored either: reload the page and the data is gone.
Can I run the SQL output directly in my database?
Yes. Choose SQL INSERT, set the table name, and copy or download the .sql file. Identifiers are sanitized and strings escaped, so the statement runs as-is in PostgreSQL, MySQL, or SQLite once a table with matching columns exists.
Why do the emails match the names?
Realistic test data should be internally consistent, so each row’s email is derived from its own name — lowercased, accents stripped, with a varied mail domain. "José Rodríguez" becomes something like jose.rodriguez@gmail.com.