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.
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: misata-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
Generate realistic, FK-consistent synthetic test data for your databases from your AI assistant.
Hosted MCP endpoint with realistic fake data for prototyping agents. 12 tools, no setup.
Run 100+ AI models — image, video, audio, 3D — through one API with pay-per-use billing.
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