Schema Designer MCP server

Read from the package source without running it. The installed server may list more.

• design_schema

  Design a database schema from a natural language description. Generates CREATE TABLE SQL (PostgreSQL), index recommendations, and a text-based ERD. Optionally accepts explicit table definitions to validate and enhance.

• generate_types

  Generate typed code from SQL CREATE TABLE statements. Supports three output formats: TypeScript interfaces, Zod validation schemas, or JSON Schema definitions.

• migrate_schema

  Generate migration SQL by diffing a "from" schema against a "to" schema. Produces ALTER TABLE statements in safe dependency order, rollback SQL, and warnings for destructive changes (column drops, type changes).

• optimize_queries

  Analyze a SQL query against a schema and suggest performance improvements. Identifies missing indexes, recommends query rewrites, and provides EXPLAIN plan interpretation hints.

• validate_schema

  Validate SQL CREATE TABLE statements for best practices. Checks for missing primary keys, unnamed constraints, missing FK indexes, data type issues (e.g. TIMESTAMP vs TIMESTAMPTZ), naming conventions (snake_case, plural tables), and N+1 query risks.

• Code scan19 source files scanned25/25
• –Live reliabilityno gateway calls yet and no remote to proben/a
• –Tool poisoningtools not inspected (local package is not executed); not countedn/a
• Auth qualitystatic API keys via environment variables6/15
• Maintenancerepository not readable: repo not found3/15
• Maintainer identityno repository or website to verify2/10

Schema Designer: common questions

Is Schema Designer MCP server safe?

With care: it is graded C, so read the findings first (55/100). Read the Schema Designer safety report

How do I install Schema Designer?

It runs on your machine. Copy the Claude Code, Claude Desktop or Cursor config from the install section.

Does Schema Designer need an API key?

Yes. The registry entry asks for LICENSE_KEY.

Is Schema Designer maintained?

The latest release is v1.1.4.

What can I use instead of Schema Designer?

Servers from other publishers that do the same job: LINQ to DB MCP server, Magic Cloud MCP server and Mako MCP server. Compare all Schema Designer alternatives.