GenerateRealData logoGenerateRealData
Home › Mock data generator
Mock data generator

Mock data that doesn't look mocked.

Stop hand-writing fixtures. Generate realistic mock data, from a single table of users to a full set of related tables, and download it as SQL, CSV, Excel or JSON.

Free trial for every new account. No credit card.

A few of the 232 data types
typeexample
Full namePriya Nair
Emailpriya.nair@example.com
Phone+1 415-555-0132
VIN1HGCM82633A004352
EAN-13 barcode4006381333931
UPC barcode036000291452
IPv4 address192.0.2.147
UUID3f2b8c1e-9d4a-4b7e-a1c2-7e5f0d9b6a31

VIN, EAN-13 and UPC values carry valid check digits, so validation code passes.

Why teams use it

Built for data that behaves like production

01

232 data types

One of the largest built-in type libraries of any test data generator, 222 with their own generator: names, emails, real cities with matching postcodes, airport and ICD-10 codes, VINs, IBANs, tracking numbers and more. Over 200 automatic links keep related fields in a row consistent.

02

Valid check digits

Identifiers like VINs, UPC and EAN-13 barcodes are generated with correct check digits, so validation code passes.

03

Related, not random

Mock data for several tables at once, with IDs that match across them.

04

Describe it in plain English

"An online shop with customers, products and orders" is enough to get started; refine the columns afterwards.

05

Any format

Download a ready-to-run SQL script, CSV, Excel (one sheet per table) or JSON.

06

Free to try

Every new account gets a free trial, no credit card required.

How it works

From schema to dataset in three steps

1

Describe or upload

Describe your data in plain English, or upload your SQL schema for PostgreSQL, MySQL / MariaDB, SQL Server and SQLite.

2

Review the plan

Check the tables, columns and rules the AI proposes, and adjust anything you like.

3

Generate and download

Choose how many rows you need and download a ready-to-run SQL script, CSV, Excel (one sheet per table) or JSON.

Questions

What is mock data?

Mock (or fake, or dummy) data is realistic-looking sample data used to test software, build demos and develop features without using real customer records.

Can I generate data for several related tables?

Yes. That is what GenerateRealData is built for: every foreign key points at a real parent row.

Can I control the values?

Yes. You can set types, ranges, formats and rules per column, or let the AI suggest them from your description.

Which formats can I download?

SQL scripts for PostgreSQL, MySQL, SQL Server and SQLite, plus CSV, Excel and JSON.

Get realistic data in minutes

Start with a free trial. No real data, no credit card.

Start free
Explore more
PostgreSQL Data Generator MySQL & MariaDB Data Generator SQL Server Data Generator SQLite Data Generator AI Synthetic Data Time Series Generator Buyer's Guide All capabilities