⚡ 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`)

config.json

{
  "mcpServers": {
    "schema-bridge": {
      "command": "node",
      "args": ["/ABSOLUTE/PATH/TO/schema-bridge-mcp/dist/index.js"]
    }
  }
}

2. Claude Desktop (`claude_desktop_config.json`)

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

bash

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