🎭

Mock Data Generator

Generate realistic mock and seed data for development, demos, and prototypes — names, emails, addresses, products, and orders. Export as JSON, CSV, or SQL.

fake data generatormock data generatorseed data generatorsample data generatorgenerate mock data

Names, emails, addresses, and contact details for a users table.

Worked example — seed a 50-row users table
  1. Choose the People dataset and the United States locale.
  2. Set Rows to 50 and tick the fields your table needs — name, email, phone, address, and joined date are a good start.
  3. Click Generate Data, then Download SQL. You get one INSERT INTO users … statement with 50 rows.
  4. Run it against your database: psql mydb < people-mock-data.sql for Postgres, or mysql mydb < people-mock-data.sql for MySQL.
  5. Check the table and column names match your schema first — rename the table in the file if yours is called something else.
INSERT INTO users (name, email, phone) VALUES
  ('James Smith', 'james.smith42@example.com', '(212) 555-0148'),
  ('Mary Johnson', 'mary.johnson17@example.com', '(415) 555-0119');
Mock data vs production data

Mock data is randomly generated in your browser. It is not linked to any real person, address, business, or order — any resemblance to real people is coincidence. That makes it safe for demos, screenshots, and shared development databases, where real customer data must never go.

Two rules follow from that: never use generated emails or phone numbers to contact anyone, and never use mock data as a stand-in for production records in reports, billing, or anything a real person relies on. Regenerate fresh data per environment so demo records do not leak between staging and production.

What is Mock Data Generator?

Mock Data Generator creates realistic mock and seed data — names, emails, addresses, phone numbers, products, and orders — for development, demos, and prototypes. Pick a dataset type (people, products, or orders), choose a locale and row count, then export as JSON, CSV, or SQL. Everything is generated in your browser; no real personal data is involved.

Common Use Cases

Seed a Development Database

Generate a 50-row users table as SQL and import it straight into Postgres, MySQL, or SQLite.

Demo & Prototype Content

Fill a new product UI with believable names, products, and orders before real data exists.

API Mock Responses

Produce JSON payloads shaped like your API responses for front-end work and documentation examples.

Form & UI Mockups

Create realistic sample content for interface mockups and design reviews.

How to Use This Tool

  1. Pick a dataset type — People, Products, or Orders
  2. Choose a locale (US, UK, or Germany) and the number of rows
  3. Tick the fields you want in each record
  4. Generate, then copy or download as JSON, CSV, or SQL

Related Tools

Learn More