Skip to content
appsgit

Schemagate

Schemagate is an MCP server that adds database tools to AI assistants such as Claude Desktop, Claude Code and Cursor. Identity-scoped schema selection for text-to-SQL. It has 173 GitHub stars, is released under the Apache-2.0 license and runs locally with uvx schemagate.

github.com/ashishsinha1602/schemagate (opens in a new tab)

Data as of from the GitHub API and the official MCP registry; description from the project's repository. Report an error

View on GitHub (opens in a new tab)

Install Schemagate

Generated from the server's MCP registry entry. Replace your-value with your own values.

Claude Desktop

claude_desktop_config.json
{
  "mcpServers": {
    "schemagate": {
      "command": "uvx",
      "args": [
        "schemagate"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "your-value"
      }
    }
  }
}

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

Claude Code

claude mcp add --env SCHEMAGATE_DATABASE_URL=your-value --transport stdio schemagate -- uvx schemagate

Cursor

.cursor/mcp.json
{
  "mcpServers": {
    "schemagate": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "schemagate"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "your-value"
      }
    }
  }
}

Project file; use ~/.cursor/mcp.json to enable it in every project.

VS Code

.vscode/mcp.json
{
  "inputs": [
    {
      "type": "promptString",
      "id": "schemagate_database_url",
      "description": "SCHEMAGATE_DATABASE_URL",
      "password": true
    }
  ],
  "servers": {
    "schemagate": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "schemagate"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "${input:schemagate_database_url}"
      }
    }
  }
}

Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).

Environment variables

Variables the server reads at startup.

NameRequiredDescription
SCHEMAGATE_DATABASE_URLsecretYesSQLAlchemy URL of the database to reflect, or 'demo' for the bundled schema
SCHEMAGATE_CATALOG_CONFIGNoOptional path to a JSON file with roles, hints and shadow-name overrides

About Schemagate

Your text-to-SQL agent picks which tables to show the model before anyone checks what the caller is allowed to read. schemagate does the check first: it filters the schema by the caller's grants, so restricted tables are absent from the prompt rather than ranked low. Works with LangChain, MCP, or any SQL agent, on Postgres, Oracle, MySQL, SQL Server and SQLite.

  • llm
  • mcp
  • mcp-server
  • nl2sql
  • oracle
  • postgresql
  • rag
  • text2sql
  • ai-agents
  • data-engineering

Similar MCP servers

More databases MCP servers

All Databases

FAQ

Schemagate FAQ

Still curious? Email info@appsgit.com.

How do I install the Schemagate MCP server?

Add the command uvx schemagate to your MCP client: put it in claude_desktop_config.json for Claude Desktop, run claude mcp add for Claude Code, or add it to .cursor/mcp.json (Cursor) or .vscode/mcp.json (VS Code). The snippets on this page are ready to paste.

Is Schemagate free?

The server is open source under the Apache-2.0 license, so running it is free. It needs credentials (SCHEMAGATE_DATABASE_URL) for the service it connects to, which may require a paid account.

Is Schemagate actively maintained?

The most recent commit was on Oct 24, 2026. The latest release is v1.11.1, published Oct 24, 2026. appsgit only lists MCP servers with a commit in the last six months.