# MCP Schema Designer

> MCP Schema Designer is an MCP server for databases. Design database schemas from natural language, validate SQL, generate migrations and types. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Website:** https://aivp-mcp.vercel.app
- **MCP Registry name:** io.github.vpatser1/mcp-schema-designer
- **Categories:** databases
- **Listing updated:** 2026-11-13

## About

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

## Install

### Claude Code (Terminal)

```sh
claude mcp add mcp-schema-designer --env LICENSE_KEY='<LICENSE_KEY>' -- npx -y mcp-schema-designer
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp-schema-designer": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-schema-designer"
      ],
      "env": {
        "LICENSE_KEY": "<LICENSE_KEY>"
      }
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp-schema-designer": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-schema-designer"
      ],
      "env": {
        "LICENSE_KEY": "<LICENSE_KEY>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp-schema-designer": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-schema-designer"
      ],
      "env": {
        "LICENSE_KEY": "<LICENSE_KEY>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp-schema-designer": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-schema-designer"
      ],
      "env": {
        "LICENSE_KEY": "<LICENSE_KEY>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp-schema-designer": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-schema-designer"
      ],
      "env": {
        "LICENSE_KEY": "<LICENSE_KEY>"
      }
    }
  }
}
```

## FAQ

### How do I add MCP Schema Designer to Claude Code?

Run this command in your terminal: claude mcp add mcp-schema-designer --env LICENSE_KEY='<LICENSE_KEY>' -- npx -y mcp-schema-designer

### What are the best alternatives to MCP Schema Designer?

The closest alternatives to MCP Schema Designer are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.

## Alternatives

- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [PlatypusDB](https://ai-powered.com/mcp/platypusdb): PlatypusDB is an open-source MCP server for databases.
- [Lorebase](https://ai-powered.com/mcp/lorebase): Lorebase is an open-source MCP server for knowledge and memory.
- [Sovaria](https://ai-powered.com/mcp/sovaria): Sovaria is a freemium MCP server for databases.
- [model2data studio](https://ai-powered.com/mcp/model2data-studio): model2data studio is a freemium MCP server for databases.
- [semlayer](https://ai-powered.com/mcp/semlayer): semlayer is a free MCP server for databases.
- [bricksentry](https://ai-powered.com/mcp/bricksentry): bricksentry is an open-source MCP server for databases.
- [MCP Toolbox for Databases](https://ai-powered.com/mcp/mcp-toolbox-for-databases-2): MCP Toolbox for Databases is an open-source MCP server for databases.

---
Source: https://ai-powered.com/mcp/mcp-schema-designer
