Schema-Driven Mock Data Generator
Generate believable fake test data from a simple field:type schema as JSON, CSV or SQL.
About this tool
The Schema-Driven Mock Data Generator builds realistic sample datasets for developers, QA engineers and demos without touching a real database. Describe your table with simple 'fieldName:type' lines, choose rows and an output format (JSON array, RFC4180 CSV, or SQL INSERT statements), and it fills each record from built-in name, city, country and company word lists plus bounded numeric and enum types. Ideal for seeding test databases, populating UI mockups, or producing fixture files.
Frequently asked questions
How do I generate fake test data from a schema?
List one 'fieldName:type' per line in the schema box, set rows and format in the options, then run. Each row is filled with realistic random values.
What field types are supported?
name, firstname, lastname, email, username, int, int(1-100), decimal, decimal(0-1000), bool, date, datetime, uuid, city, country, phone, word, sentence, company, url, and enum(a|b|c).
Can it output SQL INSERT statements?
Yes. Set format=sql and table=yourTable in the options and it emits one INSERT per row with values quoted and escaped safely.
How many rows can I generate?
Up to 1000 rows per run. Set rows=N in the options box; values above 1000 are capped.