Mock Data Generator

About Mock data generator

Generates fake records from a schema you define. Name each field, choose a type, and the tool produces up to 10,000 rows as JSON, CSV or SQL INSERT statements. A seed makes the output repeatable, so the same schema and seed give the same rows every time, which suits database seeding, demos, screenshots and tests.

How to use it

1. Edit the Schema. Each field has a name and a Type: Full name, Email address, UUID v4, Integer, Decimal, Boolean, Date, Street address, Phone number, Lorem text or Enum.
2. Set the options a type offers: Min and Max for numbers, From and To for dates, Words for text, or a comma-separated list for an Enum. Add field appends another row.
3. Set Rows, from 1 to 10000, and the Output format of JSON, CSV or SQL. For SQL, type a Table name.
4. Leave Deterministic on and choose a Seed, or turn it off for different data on every run.
5. Press Generate data, then Copy or Download a file named mock-data with the matching extension.

Three repeatable SQL rows

Fields: full_name (Full name), plan (Enum: free, pro, enterprise), seats (Integer 1 to 50)
Format: SQL, table customers, seed demo, 3 rows

INSERT INTO "customers" ("full_name", "plan", "seats") VALUES ('Amara Larsen', 'enterprise', 22);
INSERT INTO "customers" ("full_name", "plan", "seats") VALUES ('Liam Haddad', 'pro', 32);
INSERT INTO "customers" ("full_name", "plan", "seats") VALUES ('Leila Marchetti', 'enterprise', 4);

When to use it

• Filling a development database with realistic rows before a product demo.
• Creating a CSV to test an import feature, including cells that need quoting.
• Producing deterministic fixtures so snapshot tests do not change between runs.
• Populating a front-end table or chart with plausible data while the real API is unfinished.

Questions about Mock data generator

Is the data real?

No. Names come from built-in lists, addresses combine invented street and city names, phone numbers follow a +1 pattern and emails use domains such as example.com. Even so, avoid sending real mail to generated addresses.

How does the seed work?

The seed text is hashed into a 32-bit number that drives a small seeded generator, so an identical schema, row count and seed always give identical output. Without a seed, values come from the browser's cryptographic random source.

Why did dates change even though the seed stayed the same?

When From and To are blank, the range is the five years before today, and that window moves each day. Set both dates explicitly to keep the results stable.

How are values escaped in each format?

CSV quotes cells that contain commas, quotes or line breaks. SQL doubles single quotes, quotes identifiers in double quotes, and writes booleans as TRUE or FALSE and numbers bare. JSON uses standard stringification.

What are the limits?

Up to 10,000 rows per run, text of 1 to 200 words, decimals up to 10 places, and field names that are unique and non-empty. An Enum needs at least one option.

Related tools

• HTML minifierMinify your HTML by removing all the unnecessary characters.
• CSS minifierMinify your CSS by removing all the unnecessary characters.
• JS minifierMinify your JS by removing all the unnecessary characters.
• JSON validator & beautifierValidate JSON content and make it looks good.
• SQL formatter/beautifierFormat & beautify your SQL code with ease.
• HTML entity converterEncode or decode HTML entities for any given input.