Mock Data Generator

Create realistic-looking test records for demos, tests and databases without using real people's data.

Schemas and formats

Choose User Profile, Product / E-commerce, Order, Address, Company or a Custom set of fields. Output as JSON, a JSON array, CSV or SQL INSERT statements.

For testing only

The data is randomly generated and fictional. Use it to fill development and demo environments instead of copying production data.

How to use it

  1. Pick a Schema / fields option.
  2. Set the Count and Format.
  3. Press Generate and Copy.

Common use cases

What each schema contains

The Custom option offers 17 tickable fields: id, firstName, lastName, email, phone, username, birthDate, address, city, country, company, jobTitle, price, currency, status, rating and createdAt. Count is limited to 1 to 100 records per run.

Choosing a format

JSON outputs a single object, only the first record, which is handy for an example payload. JSON Array outputs all the records, which is what you want for fixtures. CSV writes a header row plus one line per record and wraps values containing a comma in double quotes. SQL INSERT writes one multi-row statement; the table name is the schema name plus an s (users, products, orders), or my_table for Custom. Numbers are left unquoted and text is single-quoted with apostrophes escaped using a backslash, which suits MySQL; for PostgreSQL or SQLite you may need to adjust the quoting.

Realistic, not random in every sense

Values come from small built-in lists (twelve first names, ten surnames, ten cities, and so on), so large batches will contain repeats, and ids are short random strings that are not guaranteed unique. Prices and totals are strings with two decimals, such as "12.99", so quoted in JSON and SQL. If your test needs unique keys or numeric columns, post-process the output. The generated passwords and emails are fictional and must not be used for real accounts.

Using generated data in tests

Generate a JSON Array of 100 users to exercise pagination and sorting, then a short one of five for readable snapshot tests. For import testing, use the CSV format and add a deliberately broken row by hand, such as a missing column, to confirm your parser reports it. Remember that all the generated names use English-style lists, so test internationalised names, long names and apostrophes separately.

Frequently asked questions

Is the data real?

No. It is randomly generated and fictional.

Can I choose my own fields?

Yes, pick Custom and tick the fields you need.

Can I get SQL?

Yes, choose the SQL INSERT format.

Is my data uploaded?

No. This tool runs entirely in your browser, so what you type or paste is not sent to our servers.

Why did I only get one record in JSON format?

The plain JSON format shows a single object. Choose JSON Array to get all of the records.

Are the ids unique?

Not guaranteed. They are short random strings, so duplicates are unlikely in small batches but possible.

Related tools

Explore all developer tools →