MockHero generates realistic, relational synthetic test data for any database schema. Key capabilities include:
Generate test data — Create mock data for one or multiple tables using:
Structured schema definitions (tables, fields, and types)
Plain English prompts (e.g. "50 users with German names and 200 orders linked to them")
Pre-built templates for common patterns (e-commerce, blog, SaaS, social)
Relational/foreign key support via ref fields
Auto-locale detection (22 locales) based on country fields
Output in JSON, CSV, or SQL (Postgres, MySQL, SQLite)
Deterministic results via a numeric seed
Detect and convert schemas — Convert existing SQL CREATE TABLE statements or sample JSON into MockHero's schema format automatically.
List field types — Browse all 157 supported field types (identity, location, financial, temporal, and more) with descriptions and examples.
List and use templates — View and generate from pre-built schemas for e-commerce, blog, SaaS, or social apps, with control over scale, locale, format, and seed.
This server has a remotely hosted endpoint. Open its connector listing for connection details, authentication requirements, and setup instructions:
Synthetic test data API. Generate realistic, relational data for any database schema.
156 field types across 15+ categories (identity, location, financial, temporal, and more)
Relational data — foreign keys just work. Orders reference real user IDs, reviews link to real products. One API call seeds your entire database.
3 input modes — structured schema, plain English prompt, or pre-built templates
Auto-locale — add a country enum field and names, emails, phones match each row's nationality. 22 locales supported.
JSON, CSV, SQL output — Postgres, MySQL, SQLite dialects
Deterministic seeds — same seed + same schema = identical data every time
MCP server — use from Claude Desktop, Cursor, Windsurf, or any AI agent
Related MCP server: mock-mcp
curl -X POST https://mockhero.dev/api/v1/generate \
-H "Authorization: Bearer mh_live_YOUR_KEY" \
-H "Content-Type: application/json" \
-d '{
"tables": [
{
"name": "users",
"count": 50,
"fields": [
{ "name": "id", "type": "uuid" },
{ "name": "name", "type": "full_name" },
{ "name": "email", "type": "email" },
{ "name": "country", "type": "enum", "params": { "values": ["US", "DE", "FR", "JP"] } },
{ "name": "created_at", "type": "datetime" }
]
},
{
"name": "orders",
"count": 200,
"fields": [
{ "name": "id", "type": "uuid" },
{ "name": "user_id", "type": "ref", "params": { "table": "users", "field": "id" } },
{ "name": "total", "type": "price" },
{ "name": "status", "type": "enum", "params": { "values": ["pending", "shipped", "delivered"] } }
]
}
]
}'Or use plain English:
curl -X POST https://mockhero.dev/api/v1/generate \
-H "Authorization: Bearer mh_live_YOUR_KEY" \
-H "Content-Type: application/json" \
-d '{ "prompt": "50 users with German names and 200 orders linked to them" }'Pre-built schemas for common patterns — no schema definition needed:
curl -X POST https://mockhero.dev/api/v1/generate \
-H "Authorization: Bearer mh_live_YOUR_KEY" \
-H "Content-Type: application/json" \
-d '{ "template": "ecommerce", "scale": 2, "locale": "de" }'Available: ecommerce, blog, saas, social
Use MockHero from AI agents via the Model Context Protocol.
Hosted remote MCP endpoint for agent-first clients:
https://mockhero.dev/mcp/agentThis endpoint exposes estimate, loginless Polar checkout, checkout status, API key claim, schema detection, templates, and generation tools.
Local stdio MCP server for agents that run npm packages:
npm install -g @mockherodev/mcp-serverSee @mockherodev/mcp-server for setup instructions.
Free | Pro | Scale | |
Daily records | 500 | 100,000 | 1,000,000 |
Requests/min | 10 | 60 | 200 |
Price | $0 | $29/mo | $79/mo |
Next.js 15 (App Router)
Supabase (Postgres)
Clerk (Auth)
Polar (Billing)
Tailwind v4
MIT
Convert an existing database schema or JSON sample into MockHero's schema format.
Send a SQL CREATE TABLE statement and get back the structured schema ready to use with generate_test_data. Or send a sample JSON record and MockHero will infer the field types.
This is useful when you have migration files or an existing database and want to generate test data that matches your schema without manually writing the definition.
Inputs: sql, sample_json.
Generate test data using a pre-built schema template.
Pick a template (ecommerce, blog, saas, social) and optionally adjust the scale, locale, format, and seed. The template handles all the table definitions, field types, and foreign key relationships for you.
Scale multiplier: 1.0 = default counts, 2.0 = double, 0.5 = half. Example: ecommerce template at scale 2.0 generates 100 users, 200 products, etc.
Inputs: template (required), scale, locale, format, +2 more.
Generate realistic test data for database tables.
Send either a structured schema (tables with fields) or a plain English description. Supports relational data with foreign keys, locale-aware names and addresses, 22 locales, 157 field types, and multiple output formats (JSON, CSV, SQL).
The killer feature: define multiple tables with "ref" fields, and all foreign key relationships are correct — orders reference real user IDs, reviews link to real products. One call seeds your entire database.
Auto-locale: add a "country" field as an enum with country codes (DE, FR, US, etc.) and names, emails, phones automatically match each row's nationality.
Inputs: tables, prompt, format, sql_dialect, +2 more.
List all 157 available field types for test data generation.
Returns every supported type organized by category (Identity, Location, Financial, Temporal, Technical, Content, Logic, Social, HR, Ecommerce, Security, AI/ML, Healthcare, Edge Cases, Special) with descriptions, parameters, and examples.
Use this to discover what types are available before building a schema.
Inputs: no named parameters.
List pre-built schema templates for common application patterns.
Available templates:
ecommerce: Customers, products, orders, order items, reviews (5 tables)
blog: Authors, posts, comments, tags, post_tags (5 tables)
saas: Organizations, members, subscriptions, invoices (4 tables)
social: Users, posts, likes, follows, messages (5 tables)
Each template includes realistic field types, proper foreign key relationships, weighted enum distributions, and auto-locale detection via country fields.
Inputs: no named parameters.
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Scored across 5 tools
Each tool has a clearly distinct purpose: schema detection, template-based generation, custom generation, field type listing, and template listing. No overlap.
All tool names follow a consistent verb_noun pattern in snake_case, with 'generate' and 'list' verbs used unambiguously.
5 tools is ideal for this server's scope—covering schema conversion, two generation methods, and two discovery tools without being too few or too many.
The tool set covers the full workflow: schema detection, template-based generation, custom generation, and resource discovery, with no obvious gaps for the stated purpose.
Generate realistic, FK-consistent synthetic test data for your databases from your AI assistant.
Format-true synthetic test data for 90 countries — IBANs, SWIFT/BIC, IDs, cards, all certified.
Hosted mock APIs from OpenAPI, TypeScript or Postman: realistic data, errors and latency on demand.
Privacy-safe synthetic financial data for LatAm fintech, AI agents, testing and ML.
