mcpbeat Sign in

Schemagate MCP Server

by ashishsinha1602 Your server? Claim it
local only

Schemagate runs on your own machine — the client starts it, so there is no endpoint to ping. Last commit 22 Sep 2026.

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

Installs / week
pypi · schemagate
7
Stars
2 open issues
22 Sep 2026
Last commit
no recent releases
Apache-2.0
License
Python

What the code does

We read the source, 9 h ago · rules 3dff92dd89df

Capabilities

What this server is able to do. For an MCP server this is often the job itself — a terminal server runs commands because that is what it is for. Listed so you know what you are plugging in, not as an accusation.

Runs an external command studio/build.py:16
subprocess.run([sys.executable, str(HERE / "export_schemas.py")], check=True)
Executes code built at runtime studio/build_answers.py:55
    mod = __import__(mods[key])
Page executes code built at runtime studio/studio.template.html:580
      c.innerHTML=esc(r); c.onclick=()=>{ state.roles.has(r)? state.roles.delete(r): state.roles.add(r); renderRoles(); run(); };

Is this your server and something here is wrong? Tell us — corrections are free and do not require a plan.

This code can reach further than it looks

We found places where it runs commands, builds paths or queries from values it is given. None of that is a flaw by itself — it becomes one when the code changes, and code changes quietly between releases. We re-read it on every one.

Three servers free · no card

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

run in your terminal
claude mcp add schemagate -- uvx schemagate
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "schemagate": {
      "args": [
        "schemagate"
      ],
      "command": "uvx"
    }
  }
}
~/.codex/config.toml
[mcp_servers.schemagate]
command = "uvx"
args = ["schemagate"]
.cursor/mcp.json
{
  "mcpServers": {
    "schemagate": {
      "args": [
        "schemagate"
      ],
      "command": "uvx"
    }
  }
}
.vscode/mcp.json
{
  "mcpServers": {
    "schemagate": {
      "args": [
        "schemagate"
      ],
      "command": "uvx"
    }
  }
}

This one needs environment variables set before it will start: SCHEMAGATE_DATABASE_URL (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). The author declared them in the registry entry; get the values from the project itself.

Alternatives to Schemagate

same job, measured the same way
DB2TOON MCP
by kamil5b

Read-only SQL database and plain-text SQL dump schema extraction to compact TOON for MCP clients.

local only
SqlServerMcp
by nithish1206

MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis

local only
Microsoft SQL Server
by alyiox

Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.

local only
db-compare
by yadu-tv

Read-only MCP to diff SQL Server/Azure SQL schema, procs, views, and tables between environments.

70 installs/wk local only
MySQL MCP
by gistrec

MCP server for one MySQL database: schema, read-only queries and guarded writes.

26 installs/wk local only
Postgres MCP
by edelciomolina

PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.

84 installs/wk local only
MCP Postgres Nl Query
by infoinlet-marketplace

RLS/tenant-aware Postgres for AI agents — schema, read-only SQL, NL→SQL with safety rails.

26 installs/wk local only
SQL
by abhishekkumar2021

Read-only SQL querying + schema introspection over Postgres & SQLite, with a gated write mode.

26 installs/wk local only

Schemagate — questions

Answers built from our own checks of this server.

Why is there no uptime for Schemagate?
Schemagate runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the pypi package schemagate.
How do I connect Schemagate?
Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It runs locally, so the command pulls schemagate straight from pypi; nothing to host, nothing to sign up for.
Is Schemagate open source?
Yes — it is published under the Apache-2.0 licence, written in Python, 7 stars on GitHub and 2 open issues. The source link is on this page, so you can read exactly what it does with your data before you connect it.