Schema Bridge MCP Server
⚡ 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 |
|
| Ingests SQL DDL ( |
|
| Generates realistic, contextual synthetic mock datasets (UUIDs, names, emails, dates, prices, statuses) strictly respecting your field types. |
|
| 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.
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/rafim-dev/schema-bridge-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server