Warehouse MCP for VS Code

io.github.tantn89/warehouse-mcp

Governed read-only warehouse access for agents: SQL guard, row policies, PII pseudonyms, audit log.

client:VS Code transport:stdio runtime:pypi

Install Warehouse MCP in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "warehouse-mcp-postgres-dsn",
      "description": "WAREHOUSE_MCP_POSTGRES_DSN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "warehouse-mcp-pii-salt",
      "description": "WAREHOUSE_MCP_PII_SALT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "warehouse-mcp-audit-log",
      "description": "WAREHOUSE_MCP_AUDIT_LOG",
      "password": true
    }
  ],
  "servers": {
    "warehouse-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "warehouse-mcp"
      ],
      "env": {
        "WAREHOUSE_MCP_POSTGRES_DSN": "${input:warehouse-mcp-postgres-dsn}",
        "WAREHOUSE_MCP_PII_SALT": "${input:warehouse-mcp-pii-salt}",
        "WAREHOUSE_MCP_AUDIT_LOG": "${input:warehouse-mcp-audit-log}"
      }
    }
  }
}

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

Warehouse MCP in other clients

Warehouse MCP MCP server