mockhero
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
reffieldsAuto-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 TABLEstatements 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.
MockHero
Synthetic test data API. Generate realistic, relational data for any database schema.
What it does
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
countryenum 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: misata-mcp
Quick start
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" }'Templates
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
MCP server
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.
Pricing
Free | Pro | Scale | |
Daily records | 1,000 | 50,000 | 500,000 |
Requests/min | 10 | 60 | 200 |
Price | $0 | $29/mo | $79/mo |
Tech stack
Next.js 15 (App Router)
Supabase (Postgres)
Clerk (Auth)
Polar (Billing)
Tailwind v4
License
MIT
Maintenance
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/dinosaur24/mockhero'
If you have feedback or need assistance with the MCP directory API, please join our Discord server