Schemagate runs on your own machine — the client starts it, so there is no endpoint to ping. 3 495 installs a week from pypi. Last commit 7 Nov 2026.
Identity-scoped schema selection for text-to-SQL. Returns only the tables the caller may read.
What the code does
We read the source, 2 h ago · rules 995398eba69f
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.
subprocess.run([sys.executable, str(HERE / "export_schemas.py")], check=True)
mod = __import__(mods[key])
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.
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.
claude mcp add schemagate -e 'SCHEMAGATE_DATABASE_URL=<SCHEMAGATE_DATABASE_URL>' -- uvx schemagate{
"mcpServers": {
"schemagate": {
"command": "uvx",
"args": [
"schemagate"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "<SCHEMAGATE_DATABASE_URL>"
}
}
}
}[mcp_servers.schemagate]
command = "uvx"
args = ["schemagate"]
env = { SCHEMAGATE_DATABASE_URL = "<SCHEMAGATE_DATABASE_URL>" }{
"mcpServers": {
"schemagate": {
"command": "uvx",
"args": [
"schemagate"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "<SCHEMAGATE_DATABASE_URL>"
}
}
}
}{
"servers": {
"schemagate": {
"type": "stdio",
"command": "uvx",
"args": [
"schemagate"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "<SCHEMAGATE_DATABASE_URL>"
}
}
}
}Put your own value in place of
<SCHEMAGATE_DATABASE_URL> (SQLAlchemy URL of the database to reflect, or 'demo' for the bundled schema).
The author’s registry entry marks it as required.
Optional settings from the registry entry, left out of the block above:
SCHEMAGATE_CATALOG_CONFIG (Optional path to a JSON file with roles, hints and shadow-name overrides).
Alternatives to Schemagate
same job, measured the same wayRead-only SQL database and plain-text SQL dump schema extraction to compact TOON for MCP clients.
Read-only MCP server for the Archery SQL audit platform: production schema and release SQL checks
Read-only Postgres: drop-in for the archived server-postgres, with schema context.
MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis
Read-only SQL Server introspection and querying: schema, definitions, dependencies and data.
Read-only SQL queries and schema inspection for IBM Db2 for i over ODBC, JT400 or Mapepire (SSH).
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Read-only SQL for PostgreSQL, MySQL and SQLite: schema, safe SELECTs, EXPLAIN, index advice
Schemagate — questions
Answers built from our own checks of this server.