ClickHouse MCP Server
Rank #354io.github.ClickHouse/mcp-clickhouse
Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
What you can do with ClickHouse MCP Server
ClickHouse MCP Server is a Model Context Protocol (MCP) server published by clickhouse. It ranks #354 of 185,028 active servers on MCP Toplist, and its repository has 913 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.
Not verifiedMCP Toplist has not yet written a checked profile for this server, so the paragraph above is assembled from registry data only. The repository README is the authority on what it does.
What ClickHouse MCP Server can and cannot do
Not verifiedMCP Toplist has not catalogued this server's tools or limitations. The repository README lists them.
What you need before using ClickHouse MCP Server
The registry listing declares required configuration before first use — typically an API key, token or connection string set via environment variables.
Declared by Glama, last synced Nov 22, 2026. Not independently verified by MCP Toplist.
- CLICKHOUSE_HOST · required
- CLICKHOUSE_USER · required
- CLICKHOUSE_PASSWORD · optional
- CLICKHOUSE_PORT · optional
- CLICKHOUSE_SECURE · optional
- CLICKHOUSE_VERIFY · optional
- CLICKHOUSE_CA_CERT · optional
- CLICKHOUSE_CLIENT_CERT · optional
- CLICKHOUSE_CLIENT_CERT_KEY · optional
- CLICKHOUSE_TLS_MODE · optional
- CLICKHOUSE_DATABASE · optional
- CLICKHOUSE_ROLE · optional
- CLICKHOUSE_ALLOW_WRITE_ACCESS · optional
- CLICKHOUSE_ALLOW_DROP · optional
- CLICKHOUSE_MCP_QUERY_TIMEOUT · optional
- CLICKHOUSE_MCP_MAX_WORKERS · optional
Connect ClickHouse MCP Server and confirm it works
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-clickhouseReplace each placeholder with your own value before saving.
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.0Replace each placeholder with your own value before saving.
[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.
[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.
{
"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.
{
"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.
{
"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.
{
"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.
{
"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.
{
"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.
{
"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.
{
"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.
{
"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.
{
"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.
After adding the config, ask your client to list this server's tools. A tool list confirms the connection; an empty list or an error means the server did not start or needs credentials.
When to choose another server
No task-specific alternatives are catalogued for ClickHouse MCP Serveryet; the list above is its publisher's other servers.
What changed, and when this was checked
- First listed
- Dec 25, 2024
- Latest version published
- Sep 21, 2026
- Version history
- 4 versions tracked (below)
- Requirements evidence
- Declared by Glama, last synced Nov 22, 2026. Not independently verified by MCP Toplist.
- Profile checked
- Not yet — purpose, capabilities and requirements above come from registry data only
- Ranking data as of
- Nov 22, 2026
- Glama ↗listed since Apr 26, 2026 · still listed
- mcp.so ↗listed since Jun 4, 2026 · still listed
- PulseMCP ↗listed since Jun 4, 2026 · still listed
- Official MCP ↗listed since Jul 24, 2026 · still listed
Do you maintain ClickHouse MCP Server? to show as its verified maintainer and add your own summary, sign-in details and links. The rest of this page is read from the registry listings and from MCP Toplist's own connection check.
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 |
Ranks ahead of 184,674 of 185,028 servers on MCP Toplist.
Show your rank
Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.
[](https://mcptoplist.com/server/io.github.ClickHouse%2Fmcp-clickhouse)<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 185,028" /></a>Variants: append ?metric=score or ?metric=stars to the image URL.
Frequently asked questions
- Who maintains ClickHouse MCP Server?
- ClickHouse MCP Server is maintained by clickhouse, which publishes 2 MCP servers (6 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.
Do you run this server?
Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.