How do I install the clickhouse mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `CLICKHOUSE_HOST`, `CLICKHOUSE_PORT`, `CLICKHOUSE_USER`, `CLICKHOUSE_PASSWORD`, `CLICKHOUSE_ROLE`, `CLICKHOUSE_SECURE`, `CLICKHOUSE_VERIFY`, `CLICKHOUSE_CONNECT_TIMEOUT` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

ClickHouse MCP Server

Query your ClickHouse database server.

Local serverstdioPython

What is the ClickHouse MCP Server?

Clickhouse mcp server connects ClickHouse to AI assistants that speak the Model Context Protocol. Query your ClickHouse database server.

What ClickHouse does

When running with HTTP or SSE transport, a health check endpoint is available at /health. This endpoint: - Returns 200 OK (body: OK) if the server is healthy and can connect to ClickHouse - Returns 503 Service Unavailable with a generic error message if the server cannot connect to ClickHouse

Practical notes

Written in Python.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
tables	Array of table objects for the current page.
next_page_token	Pass this value back to fetch the next page, or null when there are no more tables.
total_tables	Total count of tables that match the supplied filters.

How to install the ClickHouse MCP Server

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": ["mcp-clickhouse"],
      "env": {
        "CLICKHOUSE_HOST": "your-value",
        "CLICKHOUSE_PORT": "your-value",
        "CLICKHOUSE_USER": "your-value",
        "CLICKHOUSE_PASSWORD": "your-value",
        "CLICKHOUSE_ROLE": "your-value",
        "CLICKHOUSE_SECURE": "your-value",
        "CLICKHOUSE_VERIFY": "your-value",
        "CLICKHOUSE_CONNECT_TIMEOUT": "your-value"
      }
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

Variable	Description	Required
CLICKHOUSE_HOST	Endpoint or connection string the server talks to.	Optional
CLICKHOUSE_PORT	Configuration value read at startup.	Optional
CLICKHOUSE_USER	Configuration value read at startup.	Optional
CLICKHOUSE_PASSWORD	Configuration value read at startup.	Optional
CLICKHOUSE_ROLE	Configuration value read at startup.	Optional
CLICKHOUSE_SECURE	Configuration value read at startup.	Optional
CLICKHOUSE_VERIFY	Configuration value read at startup.	Optional
CLICKHOUSE_CONNECT_TIMEOUT	Configuration value read at startup.	Optional

Example prompts to try

“Use ClickHouse to Input.”
“Use ClickHouse to tables.”
“Use ClickHouse to next page token.”

Frequently asked questions

Query your ClickHouse database server. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.