schemagate for VS Code

io.github.ashishsinha1602/schemagate

Identity-scoped schema selection for text-to-SQL. Returns only the tables the caller may read.

client:VS Code transport:stdio runtime:pypi

Install schemagate in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "schemagate-database-url",
      "description": "SCHEMAGATE_DATABASE_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schemagate-catalog-config",
      "description": "SCHEMAGATE_CATALOG_CONFIG",
      "password": true
    }
  ],
  "servers": {
    "schemagate": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "schemagate"
      ],
      "env": {
        "SCHEMAGATE_DATABASE_URL": "${input:schemagate-database-url}",
        "SCHEMAGATE_CATALOG_CONFIG": "${input:schemagate-catalog-config}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

schemagate in other clients

schemagate MCP server