MCP SERVERGenerate realistic relational test data — schemas or plain English, 156 field types, 22 locales, JSON, CSV or SQL.
LABSCO SUMMARY
Asking for fifty users and two hundred orders linked to them is one call, and the seed makes the result repeatable, so a failing test can be reproduced rather than regenerated. detect_schema is the shortcut worth knowing: point it at a CREATE TABLE from an existing migration and you skip defining the schema twice.
A client for MockHero's test-data service. It generates related tables with working foreign keys from a schema you give it, a template, or a plain-English description, and can read an existing schema to start from.
It runs with or without a key. Without one, generation from explicit schemas and small templates is free up to 100 records per request, and schema detection, field-type listing, templates and estimates are always free. MOCKHERO_API_KEY unlocks plain-English prompt generation and larger requests; the agent plan gives 500 free records a day, then $0.001 per 100 records, billed through Polar as merchant of record. Run npx @mockherodev/mcp-server over stdio, or connect a Streamable HTTP client straight to https://mockhero.dev/mcp/agent with the key as a bearer token. The claimed key is shown exactly once — store it, then restart the server with it set.
One command — npx @mockherodev/mcp-server
USE CASES
Generate the tables together so the foreign keys actually resolve, in the SQL dialect you are loading into.
Take the closest template and scale it, rather than defining five tables to see one screen render.
Feed it the CREATE TABLE statement or a sample record and generate from what it detects.
Regenerate the same tables under a different locale so names, addresses and formats change with it.
Reuse the seed so the same rows come back rather than a fresh random set.
Estimate the request first — it works without a key, and uses real usage once one is set.
Counted once with only startup setup. Other versions, modes or optional credentials may expose a different list.
check_agent_checkout_statusPoll a Polar checkout created by create_agent_checkout using the returned claim_token.
Returns the checkout status (pending, paid, claimed, expired) and the next action to take (complete_checkout, claim_api_key, already_claimed, expired). Once status is paid, call claim_agent_api_key with the same token.
claim_agent_api_keyClaim the MockHero API key after Polar marks the loginless agent checkout as paid. The key is returned once.
Store the returned key securely and restart this MCP server with MOCKHERO_API_KEY set (or export it in the environment) to unlock plain-English prompt generation, requests above 100 records, and production usage.
create_agent_checkoutCreate a loginless Polar Checkout URL for MockHero's metered agent plan. Polar is the Merchant of Record for checkout, tax collection, and remittance.
No MockHero account or login is required — supply a billing email and receive a Polar checkout URL plus a one-time claim_token. After the checkout is paid, poll check_agent_checkout_status, then call claim_agent_api_key to receive the API key.
Agent plan: 500 free records per day, then $0.001 per 100 records, billed monthly.
detect_schemaConvert 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. No API key required.
estimate_agent_usageEstimate MockHero agent-plan cost before generating data. No login or API key is required; when MOCKHERO_API_KEY is configured the estimate uses actual daily usage.
Agent plan pricing: 500 free records per day, then $0.001 per 100 records (rounded up per request), billed monthly through Polar as Merchant of Record.
Send the same tables/template/prompt you plan to generate. For prompt-based estimates you must also pass estimated_records because this tool does not run prompt-to-schema conversion.
generate_from_templateGenerate 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.
Small template previews up to 100 records can run free without an API key (use a small scale such as 0.05); larger or production usage requires a MockHero API key (see create_agent_checkout for the loginless purchase flow).
generate_test_dataGenerate 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, 156 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.
Explicit table schemas up to 100 records can run free as a proof-of-work preview without an API key; plain-English prompt generation, larger requests, and production usage require a MockHero API key (see create_agent_checkout and claim_agent_api_key for the loginless purchase flow).
list_field_typesList all 156 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. No API key required.
list_templatesList pre-built schema templates for common application patterns.
Available templates:
Each template includes realistic field types, proper foreign key relationships, weighted enum distributions, and auto-locale detection via country fields. No API key required.
BEFORE YOU INSTALL
9 tools when we connected. Without MOCKHERO_API_KEY, generation is a free preview capped at 100 records per request. Four tools, estimate_agent_usage, create_agent_checkout, check_agent_checkout_status and claim_agent_api_key, buy a key through a Polar checkout, and the key is shown only once.
npx on PATH
All 4 documented setups run the server on your machine.
CONTEXT COST
Rated by the size of the 9 tool definitions that ride along on every turn, not by how many there are
INSTALLATION
npx @mockherodev/mcp-serverhttps://mockhero.dev/mcp/agentAdd this hosted endpoint to your MCP client.
{
"mcpServers": {
"mockhero": {
"command": "npx",
"args": [
"@mockherodev/mcp-server"
],
"env": {
"MOCKHERO_API_KEY": "<YOUR_MOCKHERO_API_KEY>"
}
}
}
}claude mcp add mockhero -- npx @mockherodev/mcp-serverclaude mcp add mockhero -- env MOCKHERO_API_KEY=<YOUR_MOCKHERO_API_KEY> npx @mockherodev/mcp-serverMCP servers
FixtureForgeFixtureForge
softprobe
devstacks-se