JSON Test Data Generator — Dummy Records for Fixtures

Generate dummy JSON records for fixtures and SQL seed. Pick a preset, rename columns to match your table, and copy a pretty-printed JSON array. Reserved example emails and phones — not a live mock API and not an identity pack.

Preset

Country

Quantity

SQL table name

Share this tool:

Columns

6 / 12 columns

JSON preview

2,167chars2.1 KB82lines

10 objects

[
  {
    "id": "abae5a44-d0d2-4450-8f2e-f528b3590a7f",
    "first_name": "David",
    "last_name": "Baker",
    "email": "david.baker@example.com",
    "phone": "+14045550148",
    "username": "david.baker"
  },
  {
    "id": "31ba195f-9870-4f7b-8e8b-c61b0f0c354c",
    "first_name": "Linda",
    "last_name": "St John",
    "email": "linda.stjohn@example.com",
    "phone": "+19175550181",
    "username": "linda.stjohn"
  },
  {
    "id": "805d4212-d438-49ba-832d-8da55e3e9a11",
    "first_name": "Anne-Marie",
    "last_name": "Smith",
    "email": "annemarie.smith@example.com",
    "phone": "+13105550139",
    "username": "annemarie.smith"
  },
  {
    "id": "8544edc9-f713-45b8-908f-85c86d209496",
    "first_name": "Sarah",
    "last_name": "Campbell",
    "email": "sarah.campbell@example.com",
    "phone": "+17025550138",
    "username": "sarah.campbell"
  },
  {
    "id": "fd4bffcf-4a4d-444e-b400-424ea56bf23f",
    "first_name": "Charles",
    "last_name": "Rivera",
    "email": "charles.rivera@example.com",
    "phone": "+13125550151",
    "username": "charles.rivera"
  },
  {
    "id": "07ca3b21-7be2-4c5e-94f6-b9979fb40fdc",
    "first_name": "Tyler",
    "last_name": "De Soto",
    "email": "tyler.desoto@example.com",
    "phone": "+13055550195",
    "username": "tyler.desoto"
  },
  {
    "id": "b8e94f38-31d1-4e9a-945c-536bb2b7dc76",
    "first_name": "Helen",
    "last_name": "Kelly",
    "email": "helen.kelly@example.com",
    "phone": "+12135550112",
    "username": "helen.kelly"
  },
  {
    "id": "a3e9e3df-9868-4f58-9de2-ffcb82aaf222",
    "first_name": "Emily",
    "last_name": "O'Connor",
    "email": "emily.oconnor@example.com",
    "phone": "+12125550175",
    "username": "emily.oconnor"
  },
  {
    "id": "6f7db0fe-f099-4361-b84e-40bc938ba4d3",
    "first_name": "Megan",
    "last_name": "Turner",
    "email": "megan.turner@example.com",
    "phone": "+16025550117",
    "username": "megan.turner"
  },
  {
    "id": "6511876d-2444-4ec2-93c9-3d1cd6730c24",
    "first_name": "Justin",
    "last_name": "Harris",
    "email": "justin.harris@example.com",
    "phone": "+12135550167",
    "username": "justin.harris"
  }
]

Loading…

JSON test data — developer notes

Schema-aware dummy JSON rows for fixtures, Storybook, and SQL seed. Flat columns only — not a live mock API or identity pack.

How generation works

Pick a preset, country, quantity (1–100), and SQL table name. Edit column names and types in the schema table. Changing any option refreshes the JSON array immediately. Copy all (pretty JSON) or download JSON, CSV, SQL INSERT, or TXT.

Options

Preset: Seeds the column list: user (id, names, email, phone, username), company (id, company_name, email), address (street_line, city, postal_code, country), or blank (single uuid id). Changing preset replaces custom columns.
Country: Drives name locale, company suffix style, reserved phone ranges, postal masks, and address line order in the same row.
Quantity (1–100): How many JSON objects to emit. Capped at 100 for fixture jobs.
SQL table name: Target table for SQL download only. Sanitized to a valid identifier on export.
Schema columns: Editable grid: column name (JSON key) and type. Up to 12 columns. Same-row name, email, and username correlation when name columns exist.

Examples

User preset

Settings

preset=user, country=US, count=2

Sample output

[{"id":"…","first_name":"…","email":"…@example.com"}, …]

Custom schema

Settings

blank preset + id uuid + score integer

Sample output

[{"id":"…","score":"42"}, …]

JSON test data FAQ

Fixtures, ethics, and what this tool is not

Is this a fake data API or Mockaroo replacement?

No. This page runs 100% in your browser and outputs a static JSON array you copy or download. It does not expose a REST endpoint, MCP, or signup-gated batch API.

Can I import OpenAPI or JSON Schema?

Not in v1. You edit the schema table manually or start from a preset. Column names become your JSON keys and CSV header.

Do emails use gmail.com or real inboxes?

No. Emails use IANA-reserved domains such as example.com — never consumer mailbox providers.

Are street, city, or nested person objects supported?

Street, city, address_line, and country types are available (and the address preset). Nested person objects are still out of scope — v1 stays flat columns.

Can I get Excel-ready CSV with semicolon and UTF-8 BOM?

Not from this page’s CSV download (comma, no BOM). Use the CSV test data generator for dummy spreadsheet rows with FR/DE Excel defaults.

Can I get typed, dialect-quoted SQL INSERT?

Not from this page’s SQL download (every cell is a quoted string, no dialect). Use the SQL test data generator for dummy INSERT rows with Postgres, MySQL, or SQLite quoting.

Synthetic field values for fixtures and DB seed — reserved-range phone numbers first.

JSON Test Data Generator — Dummy Records for Fixtures

Columns

How generation works

Options

Examples

User preset

Custom schema

Related tools

JSON test data FAQ

Is this a fake data API or Mockaroo replacement?

Can I import OpenAPI or JSON Schema?

Do emails use gmail.com or real inboxes?

Are street, city, or nested person objects supported?

Can I get Excel-ready CSV with semicolon and UTF-8 BOM?

Can I get typed, dialect-quoted SQL INSERT?

Test Data

Explore other tool categories

Columns