# ⚡ Schema Bridge MCP Server & CLI

[![schema-bridge-mcp MCP server](https://glama.ai/mcp/servers/rafim-dev/schema-bridge-mcp/badges/score.svg)](https://glama.ai/mcp/servers/rafim-dev/schema-bridge-mcp)
[![Awesome-MCP](https://img.shields.io/badge/Awesome--MCP-Merged%20%E2%AD%90-blue)](https://github.com/punkpeye/awesome-mcp-servers/pull/13848)

[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)
[![MCP Protocol](https://img.shields.io/badge/MCP-Standard%20Stdio-blue.svg)](https://modelcontextprotocol.io)
[![Node.js](https://img.shields.io/badge/Node.js-%3E%3D18.0.0-green.svg)](https://nodejs.org)
[![Platform](https://img.shields.io/badge/Platform-macOS%20%7C%20Linux%20%7C%20Windows-lightgrey.svg)](https://nodejs.org)

> **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`)
```json
{
  "mcpServers": {
    "schema-bridge": {
      "command": "node",
      "args": ["/ABSOLUTE/PATH/TO/schema-bridge-mcp/dist/index.js"]
    }
  }
}
```

### 2. Claude Desktop (`claude_desktop_config.json`)
```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**](https://rafi860.gumroad.com/l/schema-bridge-mcp) ($5.00+ Pay-What-You-Want)
* 🎮 [**Download on itch.io**](https://rafi-m.itch.io/schema-bridge-mcp) ($5.00+ Pay-What-You-Want)
* 🎁 [**Get the 2-in-1 AI Developer Power Bundle**](https://rafi860.gumroad.com/l/ai-developer-bundle) (Includes `schema-bridge-mcp` + `mcp-smart-git` at 20% off)

---

## 📄 License

MIT License. Authored by [rafim_dev](https://x.com/rafim_dev).