schemagate
schemagate is a Python library that limits which database tables a text-to-SQL agent can see, based on the caller's permissions, for teams running SQL agents.
What it is good for
- Keeping text-to-SQL agents from showing tables the user cannot read
- Cutting the size of database schemas sent to an AI model
- Answering database questions in plain English while respecting access rules
At a glance
- Who it is for
- Setup
- Requires programming
Level 5 of 5. You need to write code to use it.
- Cost
- Free and open source
- Type
- Framework or SDK
- Tasks
- Works with
- LangChain, LlamaIndex, MCP, Postgres, Oracle, MySQL
Momentum
- Rank this week
- Not ranked yet
- Best rank
- None yet
- GitHub stars
- 179
GitHub numbers as of Nov 2, 2026. Updated weekly.
Official links
Setup steps are on the official pages. We do not repeat them here, since they change.
Questions
- Is schemagate free?
- Yes. It is free and open source (Apache-2.0 license).
- Do I need to know how to code to use schemagate?
- Yes. You need to write code to use it.
- What does schemagate work with?
- According to its own documentation, it works with LangChain, LlamaIndex, MCP, Postgres, Oracle, and MySQL.
- What is schemagate good for?
- Keeping text-to-SQL agents from showing tables the user cannot read, cutting the size of database schemas sent to an AI model, and answering database questions in plain English while respecting access rules.
Similar agents
- TradingAgents
TradingAgents is a multi-agent framework that simulates a trading firm of LLM analysts, researchers, and managers to evaluate stock trades for researchers and developers.
- WrenAI
WrenAI is an open-source semantic layer and agent toolkit that lets AI agents answer business questions with governed SQL and dashboards.
- tabularis
Tabularis is a desktop SQL workspace that lets you query databases and connect AI agents like Claude and Cursor to your schema for people who work with databases.
- OpenMetadata
OpenMetadata is an open-source data catalog and metadata platform that gives people and AI assistants trusted context about company data.
- ChatLab
ChatLab is a desktop app that analyzes your exported chat history from WhatsApp, Telegram, Discord and others, with AI agents that search and summarize it, all stored on your own machine.
- tick-stock-panel
TSP is a self-hosted A-share quant workbench that lets investors build strategies, run backtests, and monitor stocks for individuals who write their own rules.