What this tool does
Test Data Generator builds synthetic users, products, orders, and addresses as JSON, CSV, or SQL INSERT statements with seedable randomness.
← All Tools
🧪 Test Data Generator
Generate mock users, products, orders, and addresses as JSON, CSV, or SQL INSERT — with seed and field control.
Why it is useful
It helps developers and QA teams populate fixtures, demos, and local databases without hand-writing fake rows.
How it works
The browser combines name banks, domain patterns, prices, dates, and other field generators into structured records for the selected preset.
Presets
Users include name/email/phone fields. Products include SKUs and prices. Orders link customer and totals. Addresses cover street/city/region/postal.
Formats
JSON is ideal for APIs and fixtures. CSV works in spreadsheets. SQL INSERT emits basic statements for quick database seeding.
Reproducibility
Use a seed so the same settings always produce the same dataset for shared fixtures and regression tests.
Privacy note
Mock data generation happens locally in your browser.
Important limitation
Output is synthetic and not verified against real people, products, or addresses. Do not use as real personal data.
Quick answers
How many records can I generate?
Between 1 and 200 per run, which is enough for demos, UI previews, and most local fixtures.
Are emails unique?
The generator tries to avoid duplicates within a run, but uniqueness is not guaranteed across separate generations without a seed strategy.
Can I customize fields?
Yes. Choose Custom fields and toggle name, email, phone, uuid, date, boolean, price, and lorem columns.
Is SQL production-ready?
SQL mode emits simple INSERT statements for local seeding. Review table names, types, and escaping before running against a real database.
Common Use Cases
Seed a local users table
Generate 25 users as SQL INSERT statements with a fixed seed so every teammate’s local database gets the same demo accounts.
Build product catalog fixtures
Export products as JSON for Storybook, Cypress, or API mocks without inventing SKUs and prices by hand.
Populate an order history UI
Create orders with totals and statuses, then paste CSV into a spreadsheet or load JSON in a prototype.
Mock checkout addresses
Generate addresses with mixed name variety to exercise form validation, shipping rates, and layout edge cases.