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
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
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