SERVER

ClickHouse MCP Server

Rank #199

io.github.ClickHouse/mcp-clickhouse

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

4 versions

877 GitHub stars

by clickhouse (1 servers)View repository ↗Claim this server

First listed

Dec 25, 2024

Last publish date

Sep 21, 2026

OVERVIEW

ClickHouse MCP Server is a Model Context Protocol (MCP) server published by clickhouse. It ranks #199 of 132,046 servers tracked on MCP Toplist, and its repository has 877 GitHub stars. ClickHouse MCP Server is listed across 4 registries — Official MCP, Glama, mcp.so and PulseMCP, with 4 tracked versions. It was first listed on Dec 25, 2024 and most recently updated on Sep 21, 2026.

STANDING

#199of 132,046 tracked serversTop 0.5%

Ranks ahead of 131,847 of 132,046 servers on MCP Toplist.

Recent momentum

+111GitHub stars since Apr 27 (+14%)

CONNECT

Use ClickHouse MCP Server

API keyNeeds credentials

Requires user-supplied configuration before first use — typically an API key, token or connection string set via environment variables.

Python package (PyPI)

claude mcp add mcp-clickhouse -e "CLICKHOUSE_HOST=<your CLICKHOUSE_HOST>" -e "CLICKHOUSE_USER=<your CLICKHOUSE_USER>" -e "CLICKHOUSE_PASSWORD=<your CLICKHOUSE_PASSWORD>" -e "CLICKHOUSE_PORT=<your CLICKHOUSE_PORT>" -e "CLICKHOUSE_SECURE=<your CLICKHOUSE_SECURE>" -e "CLICKHOUSE_VERIFY=<your CLICKHOUSE_VERIFY>" -e "CLICKHOUSE_CA_CERT=<your CLICKHOUSE_CA_CERT>" -e "CLICKHOUSE_CLIENT_CERT=<your CLICKHOUSE_CLIENT_CERT>" -e "CLICKHOUSE_CLIENT_CERT_KEY=<your CLICKHOUSE_CLIENT_CERT_KEY>" -e "CLICKHOUSE_TLS_MODE=<your CLICKHOUSE_TLS_MODE>" -e "CLICKHOUSE_DATABASE=<your CLICKHOUSE_DATABASE>" -e "CLICKHOUSE_ROLE=<your CLICKHOUSE_ROLE>" -e "CLICKHOUSE_ALLOW_WRITE_ACCESS=<your CLICKHOUSE_ALLOW_WRITE_ACCESS>" -e "CLICKHOUSE_ALLOW_DROP=<your CLICKHOUSE_ALLOW_DROP>" -e "CLICKHOUSE_MCP_QUERY_TIMEOUT=<your CLICKHOUSE_MCP_QUERY_TIMEOUT>" -e "CLICKHOUSE_MCP_MAX_WORKERS=<your CLICKHOUSE_MCP_MAX_WORKERS>" -- uvx mcp-clickhouse

Replace each placeholder with your own value before saving.

Docker image

claude mcp add mcp-clickhouse -e "CLICKHOUSE_HOST=<your CLICKHOUSE_HOST>" -e "CLICKHOUSE_USER=<your CLICKHOUSE_USER>" -e "CLICKHOUSE_PASSWORD=<your CLICKHOUSE_PASSWORD>" -e "CLICKHOUSE_PORT=<your CLICKHOUSE_PORT>" -e "CLICKHOUSE_SECURE=<your CLICKHOUSE_SECURE>" -e "CLICKHOUSE_VERIFY=<your CLICKHOUSE_VERIFY>" -e "CLICKHOUSE_CA_CERT=<your CLICKHOUSE_CA_CERT>" -e "CLICKHOUSE_CLIENT_CERT=<your CLICKHOUSE_CLIENT_CERT>" -e "CLICKHOUSE_CLIENT_CERT_KEY=<your CLICKHOUSE_CLIENT_CERT_KEY>" -e "CLICKHOUSE_TLS_MODE=<your CLICKHOUSE_TLS_MODE>" -e "CLICKHOUSE_DATABASE=<your CLICKHOUSE_DATABASE>" -e "CLICKHOUSE_ROLE=<your CLICKHOUSE_ROLE>" -e "CLICKHOUSE_ALLOW_WRITE_ACCESS=<your CLICKHOUSE_ALLOW_WRITE_ACCESS>" -e "CLICKHOUSE_ALLOW_DROP=<your CLICKHOUSE_ALLOW_DROP>" -e "CLICKHOUSE_MCP_QUERY_TIMEOUT=<your CLICKHOUSE_MCP_QUERY_TIMEOUT>" -e "CLICKHOUSE_MCP_MAX_WORKERS=<your CLICKHOUSE_MCP_MAX_WORKERS>" -- docker run -i --rm ghcr.io/clickhouse/mcp-clickhouse:0.7.0

Replace each placeholder with your own value before saving.

Python package (PyPI)

[mcp_servers.mcp-clickhouse]
command = "uvx"
args = ["mcp-clickhouse"]

[mcp_servers.mcp-clickhouse.env]
CLICKHOUSE_HOST = "<your CLICKHOUSE_HOST>"
CLICKHOUSE_USER = "<your CLICKHOUSE_USER>"
CLICKHOUSE_PASSWORD = "<your CLICKHOUSE_PASSWORD>"
CLICKHOUSE_PORT = "<your CLICKHOUSE_PORT>"
CLICKHOUSE_SECURE = "<your CLICKHOUSE_SECURE>"
CLICKHOUSE_VERIFY = "<your CLICKHOUSE_VERIFY>"
CLICKHOUSE_CA_CERT = "<your CLICKHOUSE_CA_CERT>"
CLICKHOUSE_CLIENT_CERT = "<your CLICKHOUSE_CLIENT_CERT>"
CLICKHOUSE_CLIENT_CERT_KEY = "<your CLICKHOUSE_CLIENT_CERT_KEY>"
CLICKHOUSE_TLS_MODE = "<your CLICKHOUSE_TLS_MODE>"
CLICKHOUSE_DATABASE = "<your CLICKHOUSE_DATABASE>"
CLICKHOUSE_ROLE = "<your CLICKHOUSE_ROLE>"
CLICKHOUSE_ALLOW_WRITE_ACCESS = "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>"
CLICKHOUSE_ALLOW_DROP = "<your CLICKHOUSE_ALLOW_DROP>"
CLICKHOUSE_MCP_QUERY_TIMEOUT = "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>"
CLICKHOUSE_MCP_MAX_WORKERS = "<your CLICKHOUSE_MCP_MAX_WORKERS>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

Docker image

[mcp_servers.mcp-clickhouse]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/clickhouse/mcp-clickhouse:0.7.0"]

[mcp_servers.mcp-clickhouse.env]
CLICKHOUSE_HOST = "<your CLICKHOUSE_HOST>"
CLICKHOUSE_USER = "<your CLICKHOUSE_USER>"
CLICKHOUSE_PASSWORD = "<your CLICKHOUSE_PASSWORD>"
CLICKHOUSE_PORT = "<your CLICKHOUSE_PORT>"
CLICKHOUSE_SECURE = "<your CLICKHOUSE_SECURE>"
CLICKHOUSE_VERIFY = "<your CLICKHOUSE_VERIFY>"
CLICKHOUSE_CA_CERT = "<your CLICKHOUSE_CA_CERT>"
CLICKHOUSE_CLIENT_CERT = "<your CLICKHOUSE_CLIENT_CERT>"
CLICKHOUSE_CLIENT_CERT_KEY = "<your CLICKHOUSE_CLIENT_CERT_KEY>"
CLICKHOUSE_TLS_MODE = "<your CLICKHOUSE_TLS_MODE>"
CLICKHOUSE_DATABASE = "<your CLICKHOUSE_DATABASE>"
CLICKHOUSE_ROLE = "<your CLICKHOUSE_ROLE>"
CLICKHOUSE_ALLOW_WRITE_ACCESS = "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>"
CLICKHOUSE_ALLOW_DROP = "<your CLICKHOUSE_ALLOW_DROP>"
CLICKHOUSE_MCP_QUERY_TIMEOUT = "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>"
CLICKHOUSE_MCP_MAX_WORKERS = "<your CLICKHOUSE_MCP_MAX_WORKERS>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/clickhouse/mcp-clickhouse:0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/clickhouse/mcp-clickhouse:0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "servers": {
    "mcp-clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

Docker image

{
  "servers": {
    "mcp-clickhouse": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/clickhouse/mcp-clickhouse:0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/clickhouse/mcp-clickhouse:0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/clickhouse/mcp-clickhouse:0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<your CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<your CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<your CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<your CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<your CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<your CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<your CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<your CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<your CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<your CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<your CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<your CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.ClickHouse%2Fmcp-clickhouse.svg)](https://mcptoplist.com/server/io.github.ClickHouse%2Fmcp-clickhouse)

HTML

<a href="https://mcptoplist.com/server/io.github.ClickHouse%2Fmcp-clickhouse"><img src="https://mcptoplist.com/badge/io.github.ClickHouse%2Fmcp-clickhouse.svg" alt="MCP Toplist: Top 1% of 132,046" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

REGISTRIES

Listed on 4 registries

ORGANIZATION

clickhouse

Organization

clickhouse

Servers in org

Versions across org

VERSIONS

Available versions (4)

Version	Published
0.7.0	Sep 21, 2026
0.6.0	Sep 3, 2026
0.5.0	Sep 1, 2026
0.4.1	Jul 17, 2026

FAQ

Frequently asked questions

Who maintains ClickHouse MCP Server?: ClickHouse MCP Server is maintained by clickhouse, which publishes 1 MCP server (4 total versions) tracked on MCP Toplist.
Is ClickHouse MCP Server listed on the Official MCP Registry?: Yes — ClickHouse MCP Server is listed on the Official MCP Registry, alongside Glama, mcp.so and PulseMCP.
How many versions does ClickHouse MCP Server have?: MCP Toplist tracks 4 versions of ClickHouse MCP Server, most recently published on Sep 21, 2026.
Where can I find the source code for ClickHouse MCP Server?: The source code for ClickHouse MCP Server is hosted at github.com/clickhouse/mcp-clickhouse.

Used in projects

Do you run this server?

Add to a project

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers