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.

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), or blank (single uuid id). Changing preset replaces custom columns.
Country
Drives name locale, company suffix style, reserved phone ranges, and postal masks 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"}, …]

Related tools

Need single-field columns instead? Try the test phone number generator, test email generator, test name generator, test username generator, test company name generator, or test postal code generator. Also: UUID generator or Lorem Ipsum generator.

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?

No. v1 is flat columns only. Street and city types ship when a future address engine exists.

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.

Test Data

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

Test Phone Number Generator

Test Email Generator

Test Name Generator

Test Username Generator

Test Company Name Generator

Test Postal Code Generator

Test Date Generator

Test Numeric Generator

CSV Test Data Generator

SQL Test Data Generator

Explore other tool categories

Minify

Shrink code and assets for production — minify JavaScript, CSS, HTML, JSON and XML before gzip or CDN deploy.

Beautify

Make code readable with consistent indentation — beautify JavaScript, CSS, TypeScript, SCSS, LESS, Markdown, GraphQL, SQL, YAML and more in your browser.

Unminify

Expand minified or compressed code — unminify JavaScript, CSS, TypeScript, SCSS, LESS, SQL, YAML and other formats when debugging or reviewing.

Conversion

Transform data between JSON, YAML, XML and CSV locally — no server uploads.

CSS preprocessors

Compile SCSS or LESS to standard CSS in the browser — pair with beautify or minify for a full stylesheet workflow.

JSON Tools

Validate, format, diff and explore JSON payloads — complementary to minifiers and converters.

SVG Tools

Preview, optimize with SVGO, export Data URI, resize, beautify, convert to JSX and validate SVG — all in your browser.

DevOps & Infra

Terraform HCL format/validate/minify, Dockerfile format & lint, Docker Compose and .env validation.

CI/CD

GitHub Actions and GitLab CI — format YAML and check workflow/job structure in your browser.

Logs & observability

Line-oriented JSON/NDJSON and Nginx/Apache access logs — format, filter, validate, and CSV/TSV.

Kubernetes

Multi-doc manifests, structural validate, Ingress/Deployment starters, and Helm values formatting.

Networking / IP

CIDR, subnets, and IPv4/IPv6 helpers — in your browser.

Security & tokens

JWKS, X.509 certificates, and secrets scan — browser-local.

API & schemas

OpenAPI tools to format, validate, and lint your specs.

Encoding

Encode or decode Base64, URL components and HTML entities — client-side only.

Developer utilities

Timestamps, UUID, ULID, Nanoid, cron, passwords, regex, slugify, number bases, case, text diff, and chmod — all client-side.

Text & Markdown

Count words, build Markdown TOCs, and clean line lists — all in your browser.

AI & LLM

Token counting, pricing estimates, and context-window fit — 100% browser-local.

Serialization

Serialize and deserialize PHP data structures beside JSON workflows.