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 ref (foreign key) data?

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

Can I use ref (foreign key) with other field types?

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

All Field Types

ref

Logic

Generate foreign key references to another table's output. THE KILLER FEATURE — creates proper relational integrity across tables. Every order references a real user ID, every comment references a real post. No orphan records.

Example Outputs

a1b2c3d4-e5f6-4890-abcd-ef1234567890142

Parameters

Parameter	Description
table	Referenced table name (required)
field	Referenced field name (required)
distribution	uniform or power_law

API Usage

Send a POST request to generate ref (foreign key) 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": "ref",
          "type": "ref",
          "params": {
            "table": "users",
            "field": "id"
          }
        }
      ]
    }
  ]
}'

Common Use Cases

Relational data seeding
Foreign key integrity
Multi-table schemas
Database seed scripts

Quick Info

Field Type: ref
Category: Logic
Parameters: 3 parameters
Output Format: JSON, CSV, SQL

Try it now

Generate ref (foreign key) data instantly in the playground.

Get Free API Key View Docs

Related Types

uuid id integer

Generate Ref (Foreign Key) + 155 more types via API

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

Get Started Free