mcp clickhouse for VS Code

io.github.dockndevai/mcp-clickhouse

ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.

client:VS Code transport:stdio runtime:npm

Install mcp clickhouse in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "clickhouse-url",
      "description": "CLICKHOUSE_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "clickhouse-user",
      "description": "CLICKHOUSE_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "clickhouse-password",
      "description": "CLICKHOUSE_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "clickhouse-mode",
      "description": "CLICKHOUSE_MODE",
      "password": true
    }
  ],
  "servers": {
    "mcp-clickhouse": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_URL": "${input:clickhouse-url}",
        "CLICKHOUSE_USER": "${input:clickhouse-user}",
        "CLICKHOUSE_PASSWORD": "${input:clickhouse-password}",
        "CLICKHOUSE_MODE": "${input:clickhouse-mode}"
      }
    }
  }
}

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

mcp clickhouse in other clients

mcp clickhouse MCP server