ClickHouse MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add mcp-clickhouse -- uvx mcp-clickhouse

{
  "mcpServers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse"
      ],
      "command": "uvx"
    }
  }
}

[mcp_servers.mcp-clickhouse]
command = "uvx"
args = ["mcp-clickhouse"]

{
  "mcpServers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse"
      ],
      "command": "uvx"
    }
  }
}

{
  "mcpServers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse"
      ],
      "command": "uvx"
    }
  }
}

This one needs environment variables set before it will start: CLICKHOUSE_HOST (Hostname of the ClickHouse server), CLICKHOUSE_USER (Username for ClickHouse authentication), CLICKHOUSE_PASSWORD (Password for ClickHouse authentication), CLICKHOUSE_PORT (ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise), CLICKHOUSE_SECURE (Use HTTPS to connect to ClickHouse), CLICKHOUSE_VERIFY (Verify SSL certificates), CLICKHOUSE_DATABASE (Default database to use), CLICKHOUSE_ROLE (ClickHouse role to activate for the session), CLICKHOUSE_ALLOW_WRITE_ACCESS (Allow write operations (DDL and DML). Queries run read-only by default), CLICKHOUSE_ALLOW_DROP (Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled), CLICKHOUSE_MCP_QUERY_TIMEOUT (Query tool timeout in seconds), CLICKHOUSE_MCP_MAX_WORKERS (Maximum query worker thread pool size). The author declared them in the registry entry; get the values from the project itself.