# schemagate

> schemagate — ashishsinha1602-schemagate. Use this tool when you need to control access to sensitive data in SQL databases, as it provides text-to-SQL access control and row-level security-aware table pruning. It solves problems related to data security and compliance by limiting the tables and data that large language models (LLMs) can access. It integrates with various SQL agents and databases, including Postgres, Oracle, MySQL, and SQL Server, and reduces prompt tokens by 75%.

Canonical page: https://skillsregistry.net/skills/ashishsinha1602-schemagate  
JSON: https://api.skillsregistry.net/v1/skills/ashishsinha1602-schemagate

## Description

Text-to-SQL access control: schema selection that gives the LLM only the tables the caller is allowed to read. Row-level-security-aware table pruning for LangChain, MCP and any SQL agent. Postgres, Oracle, MySQL, SQL Server. 75% fewer prompt tokens.

## Trust

- **Trust score (0–1):** 0.78
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **Updated:** 2026-09-28

## Source

- **Source listing:** [GitHub](https://github.com/ashishsinha1602/schemagate)

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "ashishsinha1602-schemagate"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/ashishsinha1602-schemagate` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/ashishsinha1602-schemagate/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt