SuperAPI AI Directory

schema-bridge-mcp

Compile SQL and Prisma schemas to Zod, TypeScript and Pydantic, and generate realistic synthetic mock API data.

Open website

About this tool

Schema Bridge MCP Server & CLI is used to automate database schema conversion and mock API data generation, reducing repetitive, tedious, and error-prone manual work. Its core features include:

  1. Purpose Compiles database schemas (SQL DDL, Prisma schema, JSON) into the type definitions and validation rules required by common development technology stacks, and generates synthetic mock data that can be used for testing. It is suitable for scenarios such as API development, database migration, frontend type definitions, and backend validation.

  2. Main Capabilities

  • Schema compilation: Supports SQL DDL, Prisma schema, and JSON as input, and outputs Zod validation schemas, TypeScript interfaces, and Python Pydantic v2 models.
  • Mock data generation: Can quickly generate realistic synthetic mock API datasets.
  • MCP integration: Provided as a Model Context Protocol server, exposing MCP tools that can be natively called by clients such as Claude Desktop, Cursor, Command Code, and Cline.
  • Standalone CLI: Also provides a terminal command-line tool that can be used independently without an MCP client.
  1. Usage
  • MCP Stdio quick setup: Configure .cursor/mcp.json in Cursor; configure claude_desktop_config.json in Claude Desktop.
  • Standalone terminal CLI: Can be run directly from the command line; the specific commands are not provided in the materials.
  • List of provided MCP tools: The materials label it as "MCP Tools Exposed," but do not list the specific tool names.
  1. Applicable Scenarios Suitable for developers who need to quickly convert database schemas into TypeScript, Python type definitions, and Zod validation rules, as well as teams that need to generate mock API data for testing, and especially suitable for use with AI programming assistants to automate schema translation and data generation.

  2. Limitations and Supplements

  • The project uses the MIT license, and the author is rafim_dev.
  • Provides a Pro release and Power Bundle, downloadable with zero-configuration compilation via Gumroad ($5.00+ pay-what-you-want) or itch.io ($5.00+ pay-what-you-want)package.
  • It also provides a 2-in-1 AI Developer Power Bundle (including schema-bridge-mcp + mcp-smart-git, with a 20% discount).
  • Regarding platform support, specific installation commands, CLI usage details, the specific names and parameters of MCP tools, and the complete pricing structure for paid offerings, the materials do not currently provide them.