schemagate
schemagate is a Python package that selects database tables a caller is authorized to read before text-to-SQL generation. It includes a browser demo for cataloguing schemas, ranking relevant tables, and producing prompts, while the package runs with a developer's own SQLAlchemy database.
Overview
8 featuresschemagate sits in PulseGate's Databases (SQL, NoSQL, vector, graph) category. It focuses on preventing text-to-SQL systems from exposing unauthorized database tables and wasting context on inaccessible schema. It is built as an open-source project for developers building identity-aware text-to-SQL applications. schemagate is available on the web and the command line, and it can be self-hosted.
It is developed by Ashish Sinha, and it first shipped in 2026. Development happens publicly on GitHub with 67 commits in the last 90 days. Key capabilities include identity-scoped selection, schema filtering, and text-to-SQL prompts.
Summary written by a language model from the project’s public pages.
- Identity-scoped selection
- Schema filtering
- Text-to-SQL prompts
- Schema cataloguing
- Table ranking
- Access control
- SQLAlchemy support
- Browser demo
Built with & integrations
- Claude Code
- commit a72f075acefa · since Sept 2026
Trust & compliance
Indexing history
1What PulseGate has recorded for this listing
- Indexed10 Sept · 17:35 UTCShow HN: Text-to-SQL picks tables before RLS runs – demo in the browser verified via Hacker News firehose (Algolia)Source: Hacker News firehose (Algolia) · Open
Frequently asked questions about schemagate
- What is schemagate?
- Schemagate focuses on preventing text-to-SQL systems from exposing unauthorized database tables and wasting context on inaccessible schema. It is catalogued under Databases (SQL, NoSQL, vector, graph) on PulseGate.
- Who should use schemagate?
- schemagate is an open-source project built for developers building identity-aware text-to-SQL applications.
- What platforms does schemagate run on?
- schemagate runs on the web and the command line. It can also be self-hosted.
- Is schemagate still maintained?
- The GitHub repository shows 67 commits in the last 90 days.
- What projects are similar to schemagate?
- Similar projects tracked by PulseGate include seraph-db, Chdb, and Universal Directories for Jira.seraph-dbChdbUniversal Directories for Jira
- Who develops schemagate?
- schemagate is developed by Ashish Sinha.
- How long has schemagate been around?
- schemagate first shipped in 2026.
- Is schemagate open source?
- schemagate has a public GitHub repository.
Also in Databases (SQL, NoSQL, vector, graph)
Same category — not a similarity match