rafim-dev/schema-bridge-mcp

License: MIT MCP Protocol Node.js Platform

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-git at 20% off)

---

📄 License

MIT License. Authored by rafim_dev.