Schema Bridge MCP
Compile SQL and Prisma schemas to Zod, TypeScript and Pydantic, and generate realistic synthetic mock API data.
Installation
Les étapes d'installation sont dans la documentation ci-dessous. Documentation
Documentation
Tirée du README du projet sur GitHub, actualisée chaque semaine. Les liens ouvrent GitHub.
Sommaire
⚡ 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 | ||
|---|---|---|---|---|
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-gitat 20% off)
📄 License
MIT License. Authored by rafim_dev.
Questions fréquentes
Qu'est-ce que Schema Bridge MCP ?
Compile SQL and Prisma schemas to Zod, TypeScript and Pydantic, and generate realistic synthetic mock API data.
Comment installer Schema Bridge MCP ?
Suivez les étapes d'installation de sa documentation, affichée sur cette page et dans son dépôt.
Schema Bridge MCP est-il open source ?
Oui. Son code est sur GitHub sous licence MIT.
Qui maintient Schema Bridge MCP ?
Il est publié par rafim-dev. AI.tn le référence sans le maintenir ni le recommander.
Issu des listes communautaires awesome-mcp-servers et du dépôt GitHub du projet. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.