ClickHouse

{
  "mcpServers": {
    "clickhouse": {
      "env": {
        "CLICKHOUSE_HOST": "${CLICKHOUSE_HOST}",
        "CLICKHOUSE_PORT": "${CLICKHOUSE_PORT}",
        "CLICKHOUSE_ROLE": "${CLICKHOUSE_ROLE}",
        "CLICKHOUSE_USER": "${CLICKHOUSE_USER}",
        "CLICKHOUSE_SECURE": "${CLICKHOUSE_SECURE}",
        "CLICKHOUSE_VERIFY": "${CLICKHOUSE_VERIFY}",
        "CLICKHOUSE_DATABASE": "${CLICKHOUSE_DATABASE}",
        "CLICKHOUSE_PASSWORD": "${CLICKHOUSE_PASSWORD}",
        "CLICKHOUSE_ALLOW_DROP": "${CLICKHOUSE_ALLOW_DROP}",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "${CLICKHOUSE_MCP_QUERY_TIMEOUT}",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "${CLICKHOUSE_ALLOW_WRITE_ACCESS}"
      },
      "args": [
        "run",
        "--rm",
        "-i",
        "ghcr.io/clickhouse/mcp-clickhouse:0.4.1"
      ],
      "command": "docker"
    }
  }
}