Skip to main content
Glama
rafim-dev

Schema Bridge MCP Server

⚡ Schema Bridge MCP Server & CLI

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


📄 License

MIT License. Authored by rafim_dev.

Latest Blog Posts

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