clickhouse-mcp-server MCP Server

A Clickhouse database MCP server project.

Local serverstdio

What is the clickhouse-mcp-server MCP Server?

clickhouse-mcp-server is an MCP project maintained in the burakdirin/clickhouse-mcp-server repository. The maintainer describes its purpose as “A Clickhouse database MCP server project”. Read the project documentation for the complete scope.

Local setup

The project provides a local client configuration using uv. Follow the repository’s build and installation steps before copying it, and replace example paths with the paths on your own computer.

Configuration values

The example declares CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_DATABASE, CLICKHOUSE_READONLY. Secret-looking values have been replaced with placeholders. Required and optional labels are shown only when the documentation states them.

Source

Project documentation · Repository · Discovery listing. This profile records the public documentation checked on 2026-10-08.

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.

ToolWhat it does
connect_databaseConnects to a specific Clickhouse database
execute_queryExecutes Clickhouse queries

How to install the clickhouse-mcp-server MCP Server

{
  "mcpServers": {
    "clickhouse-mcp-server": {
      "command": "uv",
      "args": [
        "--directory",
        "/Users/burakdirin/Projects/clickhouse-mcp-server",
        "run",
        "clickhouse-mcp-server"
      ],
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_USER": "root",
        "CLICKHOUSE_PASSWORD": "YOUR_CLICKHOUSE_PASSWORD",
        "CLICKHOUSE_DATABASE": "[optional]",
        "CLICKHOUSE_READONLY": "true"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

VariableDescriptionRequired
CLICKHOUSE_HOSTDeclared in the maintainer’s client configuration.Check documentation
CLICKHOUSE_USERDeclared in the maintainer’s client configuration.Check documentation
CLICKHOUSE_PASSWORDDeclared in the maintainer’s client configuration.Check documentation
CLICKHOUSE_DATABASEDeclared in the maintainer’s client configuration.Optional
CLICKHOUSE_READONLYDeclared in the maintainer’s client configuration.Check documentation