Enterprise DNAEnterprise DNA

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

Not reviewed yet

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.

How we review records

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
Checked GitHub
GitHub forks
4
Checked GitHub
GitHub stars
127
Checked GitHub
Days to a first reply on issues
71.7
Checked GitHub
Open issues
1
Checked GitHub
Releases in the last 90 days
90
Checked GitHub

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 schemagate

Tools exposed

  • SCHEMAGATE_CONNECT_ARGS
  • SCHEMAGATE_HOME
  • SCHEMAGATE_CATALOG_MAX_AGE

Clients the listing names (not checked here)

ChatGPT

Install

Add ashishsinha1602/schemagate to your client

Not verified yet

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 checked

Run 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_server

Needs SCHEMAGATE_DATABASE_URL: replace each YOUR_ value with your own.

Version 1.11.1 · From the Official MCP registry, read · Format checked against Claude Code's config docs

Claude Desktop

Config checked

Add 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.

Version 1.11.1 · From the Official MCP registry, read · Format checked against Claude Desktop's config docs

Cursor

Config checked

Add 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.

Version 1.11.1 · From the Official MCP registry, read · Format checked against Cursor's config docs

VS Code

Config checked

Add 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.

Version 1.11.1 · From the Official MCP registry, read · Format checked against VS Code's config docs

Codex

Config checked

Add 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.

Version 1.11.1 · From the Official MCP registry, read · Format checked against Codex's config docs

  • 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 withTypeHow we knowChecked
Claude CodeClientInstall recipe matches the client's documented formatRuns locally, version 1.11.1Config checkedClaude Code docs
Claude DesktopClientInstall recipe matches the client's documented formatRuns locally, version 1.11.1Config checkedClaude Desktop docs
CursorClientInstall recipe matches the client's documented formatRuns locally, version 1.11.1Config checkedCursor docs
VS CodeClientInstall recipe matches the client's documented formatRuns locally, version 1.11.1Config checkedVS Code docs
CodexClientInstall recipe matches the client's documented formatRuns locally, version 1.11.1Config checkedCodex docs

Stars and usage

How ashishsinha1602/schemagate is growing

GitHub stars

174 to 127

stars. 26 Oct 2026 to 21 Nov 2026, 5 readings.

Source: GitHub. Checked .

Health and security

Is ashishsinha1602/schemagate looked after, and what do its setup files show

Health score

45 out of 100

Does someone look after this repository? It does not say the code is good or safe. Worked out from GitHub signals checked . How it is worked out

PartPointsWhat we saw
Recent activity30 of 30Last push 3 days ago
Releases15 of 1590 releases in 90 days
Issue replies0 of 20First reply in 71.7 days (median)
Maintainer0 of 15Owned by a single user
Official source0 of 20Community server

Security check static checks

100 out of 100

Reads what is published about the server: package advisories, licence, secrets in the documented setup and tool permissions. Nothing is installed or run, so this is not a security assessment. Checked by edna-static-v1 PyPI:schemagate@1.12.0. What it checks

Licence: Apache-2.0

  • Note The lab has not recorded this server's tool list yet, so tool permissions were not checked.

Sources

Where this comes from

  • GitHubRegistry

    Checked · Days since the last commit, GitHub forks, GitHub stars, Days to a first reply on issues, Open issues, Releases in the last 90 days

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.

Free 27-page guide

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.

No spam. Unsubscribe any time.