How does it handle relational data and foreign keys?

Foreign keys are automatically managed so related records reference each other correctly.

What output formats are supported?

Generated data can be output as JSON, CSV, or SQL in Postgres, MySQL, or SQLite dialects.

Is the data generation deterministic?

Yes, using the same seed and schema will produce identical data sets.

How can I use this server with AI agents?

It exposes a hosted MCP endpoint compatible with clients like Claude Desktop, Cursor, and Windsurf, and also provides a local stdio MCP server via an npm package.

MCP Server

synthetic-datatest-datamcprelational-dataapi

Synthetic test data MCP server generating relational JSON, CSV, or SQL data from schemas, prompts, or templates.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Remote HTTP

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "mockherodev-mcp-server": {
      "url": "https://mockhero.dev/mcp/agent"
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Overview

This MCP server generates realistic synthetic test data for relational databases supporting 156 field types across 15+ categories. It accepts structured schemas, plain English prompts, or pre-built templates to produce JSON, CSV, or SQL data with support for multiple SQL dialects. It handles foreign key relationships automatically and supports locale-specific data generation for 22 locales. Use it to seed databases, test applications, or prototype with consistent, relational mock data.

Use cases

Generate relational test data from database schemas

Create synthetic datasets using plain English prompts

Seed databases with locale-aware realistic data

Produce JSON, CSV, or SQL export formats for testing

Use pre-built templates for common data patterns

Key features

156+ field types including identity, location, financial, temporal

Automatic foreign key relationship handling

Supports JSON, CSV, and SQL outputs with Postgres, MySQL, SQLite dialects

Deterministic data generation via seeds

Locale-aware data generation for 22 locales

Accessible via hosted MCP endpoint or local stdio MCP server

Capabilities & Tool Schemas

Inspect callable tools, capabilities, and parameters exposed to AI agents by MCP Server.

Extracted Tool Capabilities

156+ field types including identity, location, financial, temporal

Automatic foreign key relationship handling

Supports JSON, CSV, and SQL outputs with Postgres, MySQL, SQLite dialects

Deterministic data generation via seeds

Locale-aware data generation for 22 locales

Accessible via hosted MCP endpoint or local stdio MCP server

Documentation Overview

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 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

Quick start

Terminal

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:

Terminal

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:

Terminal

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:

text

https://mockhero.dev/mcp/agent

This 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:

Terminal

npm install -g @mockherodev/mcp-server

See @mockherodev/mcp-server for setup instructions.

Pricing

	Free	Pro	Scale
Daily records	500	100,000	1,000,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

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

Stargazers on the source repository.

Last commit

2mo ago

Most recent push to the default branch.

Directory activity

2 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Server

It accepts structured schema definitions, plain English prompts, or pre-built templates.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/mockherodev-mcp-server?style=directory)](https://allmcps.com/mcp/mockherodev-mcp-server)

HTML Embed

<a href="https://allmcps.com/mcp/mockherodev-mcp-server"><img src="https://allmcps.com/api/badge/mockherodev-mcp-server?style=directory" alt="MCP Server on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

PricingFreemium

9/12 checks healthy over the last 32d

49Quality signal: Fair · 49/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools24/30

Adoption & activity3/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Server →Install in Claude Desktop Install in Cursor Install in VS Code

MCP Server

synthetic-datatest-datamcprelational-dataapi

Synthetic test data MCP server generating relational JSON, CSV, or SQL data from schemas, prompts, or templates.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Remote HTTP

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "mockherodev-mcp-server": {
      "url": "https://mockhero.dev/mcp/agent"
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Overview

Use cases

Generate relational test data from database schemas

Create synthetic datasets using plain English prompts

Seed databases with locale-aware realistic data

Produce JSON, CSV, or SQL export formats for testing

Use pre-built templates for common data patterns

Key features

156+ field types including identity, location, financial, temporal

Automatic foreign key relationship handling

Supports JSON, CSV, and SQL outputs with Postgres, MySQL, SQLite dialects

Deterministic data generation via seeds

Locale-aware data generation for 22 locales

Accessible via hosted MCP endpoint or local stdio MCP server

Capabilities & Tool Schemas

Inspect callable tools, capabilities, and parameters exposed to AI agents by MCP Server.

Extracted Tool Capabilities

156+ field types including identity, location, financial, temporal

Automatic foreign key relationship handling

Supports JSON, CSV, and SQL outputs with Postgres, MySQL, SQLite dialects

Deterministic data generation via seeds

Locale-aware data generation for 22 locales

Accessible via hosted MCP endpoint or local stdio MCP server

Documentation Overview

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 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

Quick start

Terminal

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:

Terminal

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:

Terminal

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:

text

https://mockhero.dev/mcp/agent

This 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:

Terminal

npm install -g @mockherodev/mcp-server

See @mockherodev/mcp-server for setup instructions.

Pricing

	Free	Pro	Scale
Daily records	500	100,000	1,000,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

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

Stargazers on the source repository.

Last commit

2mo ago

Most recent push to the default branch.

Directory activity

2 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Server

It accepts structured schema definitions, plain English prompts, or pre-built templates.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/mockherodev-mcp-server?style=directory)](https://allmcps.com/mcp/mockherodev-mcp-server)

HTML Embed

<a href="https://allmcps.com/mcp/mockherodev-mcp-server"><img src="https://allmcps.com/api/badge/mockherodev-mcp-server?style=directory" alt="MCP Server on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

PricingFreemium

9/12 checks healthy over the last 32d

49Quality signal: Fair · 49/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools24/30

Adoption & activity3/15

Community engagement0/10

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Server →Install in Claude Desktop Install in Cursor Install in VS Code