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 -e 'CLICKHOUSE_HOST=<CLICKHOUSE_HOST>' -e 'CLICKHOUSE_USER=<CLICKHOUSE_USER>' -- uvx mcp-clickhouse

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>"
      }
    }
  }
}

[mcp_servers.mcp-clickhouse]
command = "uvx"
args = ["mcp-clickhouse"]
env = { CLICKHOUSE_HOST = "<CLICKHOUSE_HOST>", CLICKHOUSE_USER = "<CLICKHOUSE_USER>" }

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>"
      }
    }
  }
}

{
  "servers": {
    "mcp-clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>"
      }
    }
  }
}

Put your own values in place of <CLICKHOUSE_HOST> (Hostname of the ClickHouse server), <CLICKHOUSE_USER> (Username for ClickHouse authentication). The author’s registry entry marks them as required.

Optional settings from the registry entry, left out of the block above: CLICKHOUSE_PASSWORD (Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode), 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_CA_CERT (Path to a PEM CA bundle for ClickHouse server certificate verification), CLICKHOUSE_CLIENT_CERT (Path to a PEM client certificate for the ClickHouse HTTPS connection), CLICKHOUSE_CLIENT_CERT_KEY (Path to the PEM private key for CLICKHOUSE_CLIENT_CERT), CLICKHOUSE_TLS_MODE (Client certificate mode: mutual, proxy, or strict), 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).