ClickHouse MCP Server

About ClickHouse

The ClickHouse MCP server enables seamless interaction with ClickHouse databases through the MCP framework. Offers tools to execute SQL queries (read-only), list databases, and list tables within a specified database. Designed for easy integration with Claude Desktop.

Tags

How to install ClickHouse

Package

mcp-clickhouse (pypi)

Transport

Local (stdio), Remote (Streamable HTTP), Remote (SSE)

Install or run

python3 -m pip install mcp-clickhouse

Client configuration

{
  "mcpServers": {
    "clickhouse": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "mcp-clickhouse",
        "--python",
        "3.12",
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<clickhouse-host>",
        "CLICKHOUSE_PORT": "<clickhouse-port>",
        "CLICKHOUSE_USER": "<clickhouse-user>",
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>",
        "CLICKHOUSE_ROLE": "<clickhouse-role>",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_CONNECT_TIMEOUT": "30"
      }
    }
  }
}

Copied from the official README — verified October 4, 2026. Replace placeholder keys with your own credentials.

Client setup documented by the maintainer

“Not documented” means the README has no client-specific steps — most MCP clients can still run a local stdio server from the configuration above.

Related MCP servers in Databases