Schemagate

Databases Python v1.18.0

Identity-scoped schema selection for text-to-SQL. Returns only the tables the caller may read.

View source ↗ Generate config for multiple servers More servers

Install

Pin version unavailable — runtime listed as `python`; console command name not stated

Python
uvx schemagate

Setup by client

Pick your client — the config below is generated for this server (local stdio). Copy respects the “Pin version” switch above.

claude_desktop_config.json

{
  "mcpServers": {
    "schemagate": {
      "command": "uvx",
      "args": [
        "schemagate"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "<YOUR_SCHEMAGATE_DATABASE_URL>"
      }
    }
  }
}

Format verified against the official Claude Desktop docs ↗.

terminal

claude mcp add --env SCHEMAGATE_DATABASE_URL=<YOUR_SCHEMAGATE_DATABASE_URL> schemagate -- uvx schemagate

Format verified against the official Claude Code docs ↗.

.cursor/mcp.json

{
  "mcpServers": {
    "schemagate": {
      "command": "uvx",
      "args": [
        "schemagate"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "<YOUR_SCHEMAGATE_DATABASE_URL>"
      }
    }
  }
}

Format verified against the official Cursor docs ↗.

.vscode/mcp.json

{
  "servers": {
    "schemagate": {
      "command": "uvx",
      "args": [
        "schemagate"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "<YOUR_SCHEMAGATE_DATABASE_URL>"
      }
    }
  }
}

Format verified against the official VS Code docs ↗.

mcp_config.json

{
  "mcpServers": {
    "schemagate": {
      "command": "uvx",
      "args": [
        "schemagate"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "<YOUR_SCHEMAGATE_DATABASE_URL>"
      }
    }
  }
}

Format verified against the official Windsurf docs ↗.

Environment variables

Defined in the server's official registry manifest. Required secrets are shown as <YOUR_…> placeholders in the configs above.

SCHEMAGATE_DATABASE_URL required secret — SQLAlchemy URL of the database to reflect, or 'demo' for the bundled schema
SCHEMAGATE_CATALOG_CONFIG — Optional path to a JSON file with roles, hints and shadow-name overrides

GitHub

⭐ 103 stars · 最近更新于 29 天前 · Apache-2.0 license

About this server

schemagate — text to SQL access control at schema selection Your text to SQL agent picks which tables to show the model before anyone checks what the caller is allowed to read. schemagate does the check first: it filters the schema by the caller's grants, so restricted tables are absent from the pro…

Summary from the project README — github.com/ashishsinha1602/schemagate

Distributed as Python, listed under Databases. Review our MCP security guide before granting access to real data.

Frequently asked questions

What does the Schemagate MCP server do?

How do I install Schemagate?

Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.

Is Schemagate free to use?

The MCP server itself is free to install. The source is public on https://github.com/ashishsinha1602/schemagate. Any third-party service it calls may require its own API key and account.

Which clients support Schemagate?

Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.

Add this badge

Publish this server? Link back with a badge on your README or site — copy either snippet.

Markdown

[![Listed on MCPNav](https://mcpnav.net/badge/schemagate.svg)](https://mcpnav.net/server/schemagate/)

HTML

<a href="https://mcpnav.net/server/schemagate/"><img src="https://mcpnav.net/badge/schemagate.svg" alt="Listed on MCPNav" height="20"></a>