MCP Servers
ashishsinha1602/schemagate
Text-to-SQL access control: schema selection that gives the LLM only the tables the caller is allowed to read.
Our verdict
We have not reviewed ashishsinha1602/schemagate yet
No one at Enterprise DNA has checked this listing against its sources. The description comes from public listings gathered automatically. Any fact below shows where it came from and when it was last checked.
From the listing
About ashishsinha1602/schemagate
Schemagate is a Python library that enforces access control for text-to-SQL agents by selecting only the database tables a caller is permitted to read. It prunes the schema before sending it to the LLM, reducing prompt tokens by 75%, and supports row-level security. It works with LangChain, MCP, and any SQL agent, and connects to Postgres, Oracle, MySQL, and SQL Server.
Best for
Developers building secure, multi-tenant SQL agents that need fine-grained data access control.
Use cases
- Restrict LLM-generated SQL to authorized tables in multi-tenant applications
- Integrate row-level security into LangChain or MCP SQL agents
- Reduce token usage and cost in text-to-SQL pipelines
Notes
137 stars on GitHub. Last updated 2026-11-14. Licensed Apache-2.0.
Pros
- Enforces access control at the schema level, preventing unauthorized data exposure
- Supports multiple major databases and integrates with common agent frameworks
- Significant token reduction improves performance and cost efficiency
Cons
- Requires setup and configuration for each database and access policy
- May not cover all edge cases of complex row-level security policies
- Limited community adoption given its early stage (137 stars)
Key facts
What we have checked
- Days since the last commit
- 3
- GitHub forks
- 4
- GitHub stars
- 127
- Days to a first reply on issues
- 71.7
- Open issues
- 1
- Releases in the last 90 days
- 90
Each value shows when we last confirmed it and where it came from. Values we have not confirmed are left out, never guessed.
How to use
How to set it up
As the listing publishes it. We have not run this install.
Install
pip install schemagateTools exposed
SCHEMAGATE_CONNECT_ARGSSCHEMAGATE_HOMESCHEMAGATE_CATALOG_MAX_AGE
Clients the listing names (not checked here)
ChatGPT
Install
Add ashishsinha1602/schemagate to your client
Our lab has not run this server yet. "Config checked" on a client means the recipe matches that client's documented config format; it does not mean we ran it.
Claude Code
Config checkedRun in your terminal (runs on your computer)
claude mcp add --env SCHEMAGATE_DATABASE_URL=YOUR_SCHEMAGATE_DATABASE_URL --transport stdio ashishsinha1602-schemagate -- uvx schemagate@1.11.1 -m schemagate.mcp_serverNeeds SCHEMAGATE_DATABASE_URL: replace each YOUR_ value with your own.
Claude Desktop
Config checkedAdd to claude_desktop_config.json (runs on your computer)
{
"mcpServers": {
"ashishsinha1602-schemagate": {
"command": "uvx",
"args": [
"schemagate@1.11.1",
"-m",
"schemagate.mcp_server"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "YOUR_SCHEMAGATE_DATABASE_URL"
}
}
}
}Needs SCHEMAGATE_DATABASE_URL: replace each YOUR_ value with your own.
Cursor
Config checkedAdd to .cursor/mcp.json (runs on your computer)
{
"mcpServers": {
"ashishsinha1602-schemagate": {
"command": "uvx",
"args": [
"schemagate@1.11.1",
"-m",
"schemagate.mcp_server"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "YOUR_SCHEMAGATE_DATABASE_URL"
}
}
}
}Needs SCHEMAGATE_DATABASE_URL: replace each YOUR_ value with your own.
VS Code
Config checkedAdd to .vscode/mcp.json (runs on your computer)
{
"inputs": [
{
"type": "promptString",
"id": "schemagate-database-url",
"description": "SQLAlchemy URL of the database to reflect, or 'demo' for the bundled schema",
"password": true
}
],
"servers": {
"ashishsinha1602-schemagate": {
"type": "stdio",
"command": "uvx",
"args": [
"schemagate@1.11.1",
"-m",
"schemagate.mcp_server"
],
"env": {
"SCHEMAGATE_DATABASE_URL": "${input:schemagate-database-url}"
}
}
}
}Needs SCHEMAGATE_DATABASE_URL: replace each YOUR_ value with your own.
Codex
Config checkedAdd to ~/.codex/config.toml (runs on your computer)
[mcp_servers.ashishsinha1602-schemagate]
command = "uvx"
args = ["schemagate@1.11.1", "-m", "schemagate.mcp_server"]
env_vars = ["SCHEMAGATE_DATABASE_URL"]Needs SCHEMAGATE_DATABASE_URL: replace each YOUR_ value with your own.
- ChatGPT: ChatGPT connects only to remote servers that need no API key.
Recipes come from the server's entry in the official MCP registry. Check the package name before you run it, and keep keys out of shared files.
Works with
What ashishsinha1602/schemagate connects to
5 clients, each with how we know and when we checked.
| Works with | Type | How we know | Checked |
|---|---|---|---|
| Claude Code | Client | Install recipe matches the client's documented formatRuns locally, version 1.11.1Config checked | Claude Code docs |
| Claude Desktop | Client | Install recipe matches the client's documented formatRuns locally, version 1.11.1Config checked | Claude Desktop docs |
| Cursor | Client | Install recipe matches the client's documented formatRuns locally, version 1.11.1Config checked | Cursor docs |
| VS Code | Client | Install recipe matches the client's documented formatRuns locally, version 1.11.1Config checked | VS Code docs |
| Codex | Client | Install recipe matches the client's documented formatRuns locally, version 1.11.1Config checked | Codex docs |
Stars and usage
How ashishsinha1602/schemagate is growing
174 to 127
Health and security
Is ashishsinha1602/schemagate looked after, and what do its setup files show
Health score
45 out of 100
| Part | Points | What we saw |
|---|---|---|
| Recent activity | 30 of 30 | Last push 3 days ago |
| Releases | 15 of 15 | 90 releases in 90 days |
| Issue replies | 0 of 20 | First reply in 71.7 days (median) |
| Maintainer | 0 of 15 | Owned by a single user |
| Official source | 0 of 20 | Community server |
Security check static checks
100 out of 100
- Note The lab has not recorded this server's tool list yet, so tool permissions were not checked.
Sources
Where this comes from
- GitHubRegistry
A source shows what was published when we checked it. It does not certify security, performance or a working installation. Read our method.
Changelog
What changed
No changes recorded yet. Releases, price changes and deprecations appear here, with their dates, once we track them for this record.
Pairs with
Other entries in the index that connect to this one. Click through to see the chain.
Get the free Developer’s Field Guide
A 27-page field guide to the AI coding workflow with Claude. Claude Code, MCP servers, the prompt patterns that work, and what to delegate. Free.
Enter your work email. We send it straight over, plus a few short notes worth knowing. Unsubscribe any time.