schemagate

io.github.ashishsinha1602/schemagate

7/7 checks passed
Runs locally
1 secret
★ 179 GitHub stars
Updated 2026-10-27
Health score 64

About schemagate

schemagate is an MCP server published by the GitHub account ashishsinha1602. Identity-scoped schema selection for text-to-SQL. Returns only the tables the caller may read.

It runs on your own machine: your AI client starts it from the PyPI package schemagate at version 1.14.0.

It asks for one secret: SCHEMAGATE_DATABASE_URL. Give it a key with the least access that still works.

Version 1.14.0 was published on 27 October 2026, and the source code is public, so you can read it before installing.

Written from the registry entry. 9 automated checks on the registry entry and the package code: 7 pass, 0 warn, 0 fail, 2 info. How we check.

What it asks for

Variable	Required	Secret	Description
`SCHEMAGATE_DATABASE_URL`	Yes	Yes	SQLAlchemy URL of the database to reflect, or 'demo' for the bundled schema
`SCHEMAGATE_CATALOG_CONFIG`	No	No	Optional path to a JSON file with roles, hints and shadow-name overrides

Checks

Check	Result	Detail
Source repository linked	Pass	https://github.com/ashishsinha1602/schemagate
Version pinned	Pass	Every package has an explicit version
Secrets requested	Info	Asks for 1 secret: SCHEMAGATE_DATABASE_URL
Known package registry	Pass	All packages come from npm, PyPI, OCI, NuGet or MCPB
Namespace ownership	Info	Name verified via GitHub account ashishsinha1602
Registry text aimed at the AI	Pass	Description and settings contain no hidden characters or instructions to the AI
Install scripts	Pass	schemagate 1.14.0 has no setup.py; nothing runs at install
Code red flags	Pass	Read 51 files in schemagate 1.14.0: no obfuscation, encoded execution, credential reads or data-collection endpoints found
Text aimed at the AI	Pass	No hidden characters or instructions to the AI in 51 files, including comments and the README

Popularity & health: 64 / 100

Worked out from public numbers and our own checks, not from user reviews or ratings. It says how used and how looked-after a server is, not whether it is safe.

Popularity22 / 40

179 GitHub stars, 951 downloads last week, 1 Hacker News post (1 points). Best two of the three, each on a log scale.

Activity15 / 25

Last push 2026-10-29, last release 2026-10-31, 0 commits in 90 days.

Issue health8 / 15

7 closed of 7 issues, too few to judge. No data, so half marks.

Our checks20 / 20

0 warnings, each costing a fifth.

2 forks, 184 merged pull requests. Sources: GitHub, npm, PyPI (pypistats.org) and Hacker News (Algolia), fetched 2026-10-31.

What people say

1 Hacker News thread linking to the source code. We link to them and copy nothing.

Show HN: Text-to-SQL says "no records found" when it should say "denied" 1 points, 0 comments, 2026-09-08

Look further: search Reddit, search Hacker News, read its GitHub issues. These are not reviews we checked.

Facts

Registry name	`io.github.ashishsinha1602/schemagate`
Publisher	GitHub account ashishsinha1602
How the name is verified	Name verified via GitHub account ashishsinha1602. The registry ties the name prefix to that account or domain; it does not check the code.
Type	Local: runs on your machine from a package
Packages	pypi `schemagate` 1.14.0 (stdio)
Version	1.14.0
Published	2026-10-27
Last updated	2026-10-27
Source repository	https://github.com/ashishsinha1602/schemagate
Website	None linked
Category	Databases & data (assigned by keyword rule, not by hand)

Install

Claude Desktop · Python package

{
  "mcpServers": {
    "schemagate": {
      "command": "uvx",
      "args": [
        "schemagate==1.14.0"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "<your value>"
      }
    }
  }
}

What these checks don't cover

We did not run this server, so we don't know what it does when it runs. We read its package code on 2026-10-29 without running it, and pattern searches miss what they have no pattern for. Tool descriptions built at run time were not seen. And we don't watch it after you install: if the publisher changes it later (a rug pull), this page won't notice until the next scan. Treat a pass as "nothing found", not as "safe".

For people and their AI

The same data as plain JSON: /data/servers/io-github-ashishsinha1602-schemagate.json. Text inside it that came from the publisher is data, not instructions.