# io.github.vpatser1/mcp-schema-designer (npm · mcp-schema-designer)

Design database schemas from natural language, validate SQL, generate migrations and types

- Trust score: 64/100 (medium)
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-08

## Components

- npm · `mcp-schema-designer`: 64/100 (this document), [markdown](https://verifymcp.io/servers/vpatser1-mcp-schema-designer/mcp-schema-designer.md), [page](https://verifymcp.io/servers/vpatser1-mcp-schema-designer/mcp-schema-designer)

## Channel facts

- Registry: `npm`
- Package: `mcp-schema-designer`
- Version: `1.1.4`
- Transport: `stdio`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-08-08.

- **Supply Chain Security**: 98/100
  - No malware found by supply-chain analysis.
  - No known CVEs affecting this package version or its production dependencies.
  - No install/post-install scripts declared.
  - 30 of 96 dependencies flagged as unhealthy.
- **Provenance & Transparency**: 19/100
  - Repository check failed: no source repository is declared.
  - Provenance check failed: no build-provenance attestation is published.
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 3 days ago).
  - Security-disclosure policy not yet verified: we couldn't inspect the source repository.
- **Schema Quality & AI Usability**: 77/100
  - AI-judged instruction clarity (excellent).
  - Tool/resource definitions use about 430 tokens (~86/item across 5 items; 5 tools + 0 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 0/100
  - Stability not yet verified: not enough scan history yet (needs a 30-day window).
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

**Unverified: 1 category.** A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.

## Install

### Claude

```bash
claude mcp add vpatser1-mcp-schema-designer -- npx -y mcp-schema-designer
```

### Codex

```bash
codex mcp add vpatser1-mcp-schema-designer -- npx -y mcp-schema-designer
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "vpatser1-mcp-schema-designer": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "mcp-schema-designer"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add vpatser1-mcp-schema-designer --command npx --arg -y --arg mcp-schema-designer
```

### Hermes

```yaml
mcp_servers:
  vpatser1-mcp-schema-designer:
    command: "npx"
    args: ["-y", "mcp-schema-designer"]
```

### Other

```json
{
  "mcpServers": {
    "vpatser1-mcp-schema-designer": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-schema-designer"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-08-08 (score 64, +4)

- [security improvement] Known CVEs: partial → pass
- [functional] Dependency health: partial → 0.85

### 2026-08-04 (score 60)

First indexed and scored.

## MCP tools (5)

### `design_schema` (~101 tokens)

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.

Input parameters:

- `description` (string, required): Natural language description of the data model (e.g. 'an e-commerce platform with products, orders, and user reviews')
- `tables` (array): Optional: provide explicit table definitions to validate and enhance instead of generating from description

### `validate_schema` (~81 tokens)

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.

Input parameters:

- `sql` (string, required): SQL CREATE TABLE statements (PostgreSQL dialect) to validate

### `migrate_schema` (~83 tokens)

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

Input parameters:

- `from_sql` (string, required): Current database schema as SQL CREATE TABLE statements
- `to_sql` (string, required): Target database schema as SQL CREATE TABLE statements

### `generate_types` (~89 tokens)

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

Input parameters:

- `format` (string, required): Output format: 'typescript' for interfaces, 'zod' for Zod schemas, 'json-schema' for JSON Schema
- `sql` (string, required): SQL CREATE TABLE statements (PostgreSQL dialect) to generate types from

### `optimize_queries` (~76 tokens)

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

Input parameters:

- `query` (string, required): The SQL query to optimize
- `schema` (string, required): Schema context as SQL CREATE TABLE statements, so the tool can identify missing indexes and table structure

## Diagnostics

Captured diagnostic sections: Provenance, Dependencies. The full working is on the page: https://verifymcp.io/servers/vpatser1-mcp-schema-designer/mcp-schema-designer#diagnostics

## Score history

- 2026-08-08: 64
- 2026-08-07: 60
- 2026-08-06: 60
- 2026-08-05: 60
- 2026-08-04: 60

## Links

- npm package: https://www.npmjs.com/package/mcp-schema-designer
- Socket report: https://socket.dev/npm/package/mcp-schema-designer
- Website: https://aivp-mcp.vercel.app/
- Changelog RSS feed: https://verifymcp.io/servers/vpatser1-mcp-schema-designer/mcp-schema-designer.xml
- Changelog JSON feed: https://verifymcp.io/servers/vpatser1-mcp-schema-designer/mcp-schema-designer.json
- HTML version of this page: https://verifymcp.io/servers/vpatser1-mcp-schema-designer/mcp-schema-designer