MCP Schema Designer

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/vpatser1-mcp-schema-designer

About

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools

2 read · 2 write · 0 delete · 1 not yet classified

Secrets

1 (API keys, tokens or passwords)

Install scripts

Not scanned yet

Runs as

Node.js package

Tools (5)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

• 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.

Signals

Last release

Aug 4, 2026 (2 months ago)

Details

Registry name

io.github.vpatser1/mcp-schema-designer

Version

1.1.4

Auth

API key

Packages

npm mcp-schema-designer

License

License unknown

Website

aivp-mcp.vercel.app

First seen

Oct 24, 2026

Last checked

Oct 24, 2026

Source

Official MCP Registry