MockHero is a synthetic test data API that generates realistic, relational fake data for developers. It supports 156 field types, 22 locales, and outputs JSON, CSV, or SQL.

How do I generate test data with MockHero?

Send a POST request to /api/v1/generate with a JSON schema describing your tables and fields. You can also use plain English prompts or pre-built templates for common schemas like ecommerce, blog, or SaaS.

What field types does MockHero support?

MockHero supports 156+ field types including uuid, email, full_name, phone, address, company, credit_card, iban, ip_address, url, date, timestamp, price, latitude, longitude, color, avatar, paragraph, and many more.

Does MockHero support relational data?

Yes. Use ref fields to create foreign key relationships between tables. MockHero generates referentially consistent data across all related tables.

Can I use MockHero with AI coding agents?

Yes. MockHero provides an MCP (Model Context Protocol) server that works with Claude Desktop, Claude Code, Cursor, and other AI-powered development tools. Install it via npx @mockherodev/mcp-server.

Yes. The free tier includes 1,000 records/day, 100 records/request, all 156 field types, all 22 locales, and JSON output. Paid plans start at $29/month for higher limits and additional output formats.

What output formats does MockHero support?

MockHero outputs JSON (all plans), CSV (Pro and Scale), and SQL with dialect support for PostgreSQL, MySQL, and SQLite (Pro and Scale).

What locales does MockHero support?

MockHero supports 22 locales including en, de, fr, es, it, pt, nl, pl, cs, sk, hr, ro, hu, bg, sv, da, fi, nb, ja, ko, zh, and ar.

How do I generate fake data for testing?

MockHero is the easiest way to generate fake data for testing. Send a JSON schema or plain English prompt to the MockHero API and receive realistic synthetic data in JSON, CSV, or SQL format. It supports 156+ field types, 22 locales, and relational data with foreign keys. Sign up at mockhero.dev for a free API key with 1,000 records/day.

What is synthetic test data?

Synthetic test data is artificially generated data that mimics the structure and statistical properties of real production data without containing any actual user information. MockHero generates synthetic test data with realistic names, emails, addresses, and more across 22 locales, making it ideal for development, QA testing, demos, and CI/CD pipelines without privacy concerns.

How do I seed a database with test data?

Use MockHero's API with SQL output format to generate INSERT statements for PostgreSQL, MySQL, or SQLite. Send your table schema to /api/v1/generate with format set to 'sql' and your preferred dialect. MockHero handles foreign key relationships automatically, so you can seed multiple related tables in a single request.

What's the best fake data API?

MockHero is a purpose-built fake data API for developers. Unlike Faker.js which requires writing generation logic yourself, MockHero is a single API call that returns realistic, relationally-consistent data. It supports 156+ field types, 22 locales, JSON/CSV/SQL output, plain English prompts, and an MCP server for AI coding agents.

How do I generate realistic names and emails for testing?

MockHero generates locale-aware names and emails that look realistic. Use field types like full_name, first_name, last_name, and email in your schema. Set the locale parameter to any of 22 supported locales (e.g., 'de' for German, 'ja' for Japanese) to get culturally appropriate test data.

Can AI generate test data?

Yes. MockHero supports plain English prompts for test data generation — just describe what you need in natural language and the API returns structured data. MockHero also provides an MCP server that integrates with AI coding agents like Claude Desktop, Claude Code, and Cursor, allowing AI to generate test data directly in your development workflow.

How do I create test data with foreign key relationships?

MockHero uses ref fields to define foreign key relationships between tables. Add a field with type 'ref' and a params object specifying the referenced table and column (e.g., {"type": "ref", "params": {"ref": "users.id"}}). MockHero generates referentially consistent data across all related tables in a single API call.

How do I generate fake date range data?

Use MockHero's API to generate realistic date range test data. Send a POST request to /api/v1/generate with your schema including the "date_range" field type, and receive synthetic data instantly. MockHero supports 156+ field types across 15 categories.

Can I use date range with other field types?

Yes. MockHero generates multiple field types in a single request. Combine "date_range" with "date", "datetime", "duration" and 150+ other types. Use ref fields to create foreign key relationships between tables for fully relational test data.

All Field Types

date_range

Temporal

Generate correlated date pairs where start is always before end. Returns { start, end } objects — perfect for bookings, reservations, project timelines, and subscription periods. The gap is configurable.

Example Outputs

{ "start": "2026-01-10", "end": "2026-01-17" }{ "start": "2026-03-01", "end": "2026-03-15" }

Parameters

Parameter	Description
min_gap_days	Minimum days between dates (default 1)
max_gap_days	Maximum days between dates (default 30)
min_date	Earliest start date
max_date	Latest end date

API Usage

Send a POST request to generate date range data:

curl -X POST https://mockhero.dev/api/v1/generate \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "tables": [
    {
      "name": "example",
      "count": 5,
      "fields": [
        {
          "name": "date_range",
          "type": "date_range"
        }
      ]
    }
  ]
}'

Common Use Cases

Hotel booking testing
Project timeline seeding
Event scheduling
Subscription period testing

Quick Info

Field Type: date_range
Category: Temporal
Parameters: 4 parameters
Output Format: JSON, CSV, SQL

Try it now

Generate date range data instantly in the playground.

Get Free API Key View Docs

Related Types

date datetime duration

Generate Date Range + 155 more types via API

One API call. Multiple tables. Relational integrity. Free tier included.

Get Started Free