Schema Bridge MCP
Compile SQL and Prisma schemas to Zod, TypeScript and Pydantic, and generate realistic synthetic mock API data.
Install
The installation steps are in the documentation below. Documentation
Documentation
From the project's README on GitHub, refreshed weekly. Links open on GitHub.
Contents
⚡ Schema Bridge MCP Server & CLI
Model Context Protocol (MCP) Server & CLI for Instant Schema Conversion & Mock API Generation.
Effortlessly compile SQL DDL, Prisma schemas, and JSON into Zod validation schemas, TypeScript interfaces, and Python Pydantic v2 models, plus generate synthetic mock datasets in seconds.
🌟 Why Schema Bridge?
Converting database schemas into API validation rules, TypeScript types, and synthetic testing data is repetitive, tedious, and error-prone.
schema-bridge-mcp gives Claude Desktop, Cursor, Command Code, and Cline native superpowers to automate schema translations and mock generation on demand.
🚀 Quick Setup (MCP Stdio)
1. Cursor (.cursor/mcp.json)
{
"mcpServers": {
"schema-bridge": {
"command": "node",
"args": ["/ABSOLUTE/PATH/TO/schema-bridge-mcp/dist/index.js"]
}
}
}2. Claude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"schema-bridge": {
"command": "node",
"args": ["/ABSOLUTE/PATH/TO/schema-bridge-mcp/dist/index.js"]
}
}
}🛠️ MCP Tools Exposed
| Tool | Parameters | Description | ||
|---|---|---|---|---|
schema_convert | `source_schema: string, target_format: 'zod' \ | 'typescript' \ | 'pydantic'` | Ingests SQL DDL (CREATE TABLE), Prisma schemas, or JSON and converts to production Zod schemas, TypeScript types, or Pydantic v2 models. |
schema_generate_mock | source_schema: string, count?: number | Generates realistic, contextual synthetic mock datasets (UUIDs, names, emails, dates, prices, statuses) strictly respecting your field types. | ||
schema_validate | payload: string, schema: string | Compares runtime JSON payloads against database schemas and flags missing fields or mismatched types instantly. |
💻 Standalone Terminal CLI Usage
# Clone & install dependencies
git clone https://github.com/rafim-dev/schema-bridge-mcp.git
cd schema-bridge-mcp
npm install
npm run build
# Convert SQL DDL to Zod Schema
node dist/index.js convert "CREATE TABLE users (id UUID PRIMARY KEY, email TEXT, is_active BOOLEAN);" zod
# Convert Prisma to TypeScript interfaces
node dist/index.js convert schema.prisma typescript
# Generate 5 realistic mock records
node dist/index.js mock "CREATE TABLE orders (id INT, total FLOAT, customer_email TEXT);" 5📦 Pro Distribution & Power Bundle
- 🔄 **Download Compiled Zero-Config Bundle on Gumroad** ($5.00+ Pay-What-You-Want)
- 🎮 **Download on itch.io** ($5.00+ Pay-What-You-Want)
- 🎁 **Get the 2-in-1 AI Developer Power Bundle** (Includes
schema-bridge-mcp+mcp-smart-gitat 20% off)
📄 License
MIT License. Authored by rafim_dev.
Frequently asked questions
What is Schema Bridge MCP?
Compile SQL and Prisma schemas to Zod, TypeScript and Pydantic, and generate realistic synthetic mock API data.
How do I install Schema Bridge MCP?
Follow the installation steps in its documentation, shown on this page and in its repository.
Is Schema Bridge MCP open source?
Yes. Its code is on GitHub under the MIT license.
Who maintains Schema Bridge MCP?
It is published by rafim-dev. AI.tn lists it but does not maintain or endorse it.
From the community awesome-mcp-servers lists and the project's GitHub repository. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.