Identity-scoped schema selection for text-to-SQL. Returns only the tables the caller may read.
Connect Runs on your machine
claude mcp add schemagate -e SCHEMAGATE_DATABASE_URL=<SCHEMAGATE_DATABASE_URL> -e SCHEMAGATE_CATALOG_CONFIG=<SCHEMAGATE_CATALOG_CONFIG> -- uvx schemagate==1.18.1
{
"mcpServers": {
"schemagate": {
"command": "uvx",
"args": [
"schemagate==1.18.1"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "<SCHEMAGATE_DATABASE_URL>",
"SCHEMAGATE_CATALOG_CONFIG": "<SCHEMAGATE_CATALOG_CONFIG>"
}
}
}
}
{
"mcpServers": {
"schemagate": {
"command": "uvx",
"args": [
"schemagate==1.18.1"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "<SCHEMAGATE_DATABASE_URL>",
"SCHEMAGATE_CATALOG_CONFIG": "<SCHEMAGATE_CATALOG_CONFIG>"
}
}
}
}
{
"servers": {
"schemagate": {
"type": "stdio",
"command": "uvx",
"args": [
"schemagate==1.18.1"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "<SCHEMAGATE_DATABASE_URL>",
"SCHEMAGATE_CATALOG_CONFIG": "<SCHEMAGATE_CATALOG_CONFIG>"
}
}
}
}
Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
SCHEMAGATE_DATABASE_URLRequired, secret | SQLAlchemy URL of the database to reflect, or 'demo' for the bundled schema |
SCHEMAGATE_CATALOG_CONFIGOptional | Optional path to a JSON file with roles, hints and shadow-name overrides |
Details
| Package | [email protected] (PYPI, stdio) |
| First published | 11 Nov 2026 |
| Last updated | 11 Nov 2026 |
| Registry name | io.github.ashishsinha1602/schemagate |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.
