mcp server

ClickHouse MCP Server

ClickHouse's official MCP server for listing databases and tables and running read queries on ClickHouse.

ClickHouse/mcp-clickhouseofficiallistedunreviewednot running here yet

Use tool

Set up

Runs on your computer. Pick your agent and operating system.

Before you start

uv (`curl -LsSf https://astral.sh/uv/install.sh | sh`)
uv (for uvx) or pip

~/Library/Application Support/Claude/claude_desktop_config.json

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

same format Cursor, GitHub Copilot CLI, Junie, JetBrains AI Assistant, Augment (Auggie CLI), Factory Droid, Kiro, Devin CLI +12

Values in angle brackets are placeholders. Restart Claude Desktop after editing its config.Claude Desktop docs

Tools provided

As listed by the project. Your agent asks before calling them, depending on its settings.

run_queryRun a SQL query
list_databasesList databases
list_tablesList tables
run_chdb_select_queryRun a query on chDB (needs the optional extra)

README

synced Oct 13, 2026

ClickHouse MCP Server

ClickHouse's official MCP server for listing databases and tables and running read queries on ClickHouse.

Install

uvx mcp-clickhouse

Configuration

Variable	Required	Description
`CLICKHOUSE_HOST`	Yes	ClickHouse server hostname
`CLICKHOUSE_USER`	Yes	ClickHouse username
`CLICKHOUSE_PASSWORD`	No	ClickHouse password (not needed with client-cert mTLS)

Tools

run_query — Run a SQL query
list_databases — List databases
list_tables — List tables
run_chdb_select_query — Run a query on chDB (needs the optional extra)

About this listing

Details were gathered from the project's public pages on 2026-10-13 and have not been reviewed by a person yet. Read the project's own documentation before giving it access to anything sensitive.

Sources: