ClickHouse

Indexed by io.github.ClickHouse

About

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

Use this server

Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.

Transportstdio (runs a local command)

Env varsCLICKHOUSE_HOST CLICKHOUSE_USER CLICKHOUSE_PASSWORD CLICKHOUSE_PORT CLICKHOUSE_SECURE CLICKHOUSE_VERIFY CLICKHOUSE_DATABASE CLICKHOUSE_ROLE CLICKHOUSE_ALLOW_WRITE_ACCESS CLICKHOUSE_ALLOW_DROP CLICKHOUSE_MCP_QUERY_TIMEOUT

Claude Code

claude mcp add --env CLICKHOUSE_HOST= --env CLICKHOUSE_USER= --env CLICKHOUSE_PASSWORD= --env CLICKHOUSE_PORT= --env CLICKHOUSE_SECURE= --env CLICKHOUSE_VERIFY= --env CLICKHOUSE_DATABASE= --env CLICKHOUSE_ROLE= --env CLICKHOUSE_ALLOW_WRITE_ACCESS= --env CLICKHOUSE_ALLOW_DROP= --env CLICKHOUSE_MCP_QUERY_TIMEOUT= mcp-clickhouse -- uvx mcp-clickhouse

Cursor

Add to Cursor

If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.

VS Code

code --add-mcp '{"name":"mcp-clickhouse","command":"uvx","args":["mcp-clickhouse"],"env":{"CLICKHOUSE_HOST":"","CLICKHOUSE_USER":"","CLICKHOUSE_PASSWORD":"","CLICKHOUSE_PORT":"","CLICKHOUSE_SECURE":"","CLICKHOUSE_VERIFY":"","CLICKHOUSE_DATABASE":"","CLICKHOUSE_ROLE":"","CLICKHOUSE_ALLOW_WRITE_ACCESS":"","CLICKHOUSE_ALLOW_DROP":"","CLICKHOUSE_MCP_QUERY_TIMEOUT":""}}'

JSON

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "",
        "CLICKHOUSE_USER": "",
        "CLICKHOUSE_PASSWORD": "",
        "CLICKHOUSE_PORT": "",
        "CLICKHOUSE_SECURE": "",
        "CLICKHOUSE_VERIFY": "",
        "CLICKHOUSE_DATABASE": "",
        "CLICKHOUSE_ROLE": "",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "",
        "CLICKHOUSE_ALLOW_DROP": "",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": ""
      }
    }
  }
}

Environment variables are listed by name only — fill in your own values. Entries never carry secrets.