快速接入
安装与连接
选择适合客户端的连接方式，检查环境变量后复制配置。
PYPI / stdio
stdioapi-key
uvx mcp-clickhouse==0.4.1Package：[email protected]
CLICKHOUSE_HOSTCLICKHOUSE_USERCLICKHOUSE_PASSWORDCLICKHOUSE_PORTCLICKHOUSE_SECURECLICKHOUSE_VERIFYCLICKHOUSE_DATABASECLICKHOUSE_ROLECLICKHOUSE_ALLOW_WRITE_ACCESSCLICKHOUSE_ALLOW_DROPCLICKHOUSE_MCP_QUERY_TIMEOUT客户端配置 JSON
{
"mcpServers": {
"clickhouse": {
"env": {
"CLICKHOUSE_HOST": "${CLICKHOUSE_HOST}",
"CLICKHOUSE_PORT": "${CLICKHOUSE_PORT}",
"CLICKHOUSE_ROLE": "${CLICKHOUSE_ROLE}",
"CLICKHOUSE_USER": "${CLICKHOUSE_USER}",
"CLICKHOUSE_SECURE": "${CLICKHOUSE_SECURE}",
"CLICKHOUSE_VERIFY": "${CLICKHOUSE_VERIFY}",
"CLICKHOUSE_DATABASE": "${CLICKHOUSE_DATABASE}",
"CLICKHOUSE_PASSWORD": "${CLICKHOUSE_PASSWORD}",
"CLICKHOUSE_ALLOW_DROP": "${CLICKHOUSE_ALLOW_DROP}",
"CLICKHOUSE_MCP_QUERY_TIMEOUT": "${CLICKHOUSE_MCP_QUERY_TIMEOUT}",
"CLICKHOUSE_ALLOW_WRITE_ACCESS": "${CLICKHOUSE_ALLOW_WRITE_ACCESS}"
},
"args": [
"mcp-clickhouse==0.4.1"
],
"command": "uvx"
}
}
}OCI / stdio
stdioapi-key
docker run --rm -i ghcr.io/clickhouse/mcp-clickhouse:0.4.1Package：ghcr.io/clickhouse/mcp-clickhouse:[email protected]
CLICKHOUSE_HOSTCLICKHOUSE_USERCLICKHOUSE_PASSWORDCLICKHOUSE_PORTCLICKHOUSE_SECURECLICKHOUSE_VERIFYCLICKHOUSE_DATABASECLICKHOUSE_ROLECLICKHOUSE_ALLOW_WRITE_ACCESSCLICKHOUSE_ALLOW_DROPCLICKHOUSE_MCP_QUERY_TIMEOUT客户端配置 JSON
{
"mcpServers": {
"clickhouse": {
"env": {
"CLICKHOUSE_HOST": "${CLICKHOUSE_HOST}",
"CLICKHOUSE_PORT": "${CLICKHOUSE_PORT}",
"CLICKHOUSE_ROLE": "${CLICKHOUSE_ROLE}",
"CLICKHOUSE_USER": "${CLICKHOUSE_USER}",
"CLICKHOUSE_SECURE": "${CLICKHOUSE_SECURE}",
"CLICKHOUSE_VERIFY": "${CLICKHOUSE_VERIFY}",
"CLICKHOUSE_DATABASE": "${CLICKHOUSE_DATABASE}",
"CLICKHOUSE_PASSWORD": "${CLICKHOUSE_PASSWORD}",
"CLICKHOUSE_ALLOW_DROP": "${CLICKHOUSE_ALLOW_DROP}",
"CLICKHOUSE_MCP_QUERY_TIMEOUT": "${CLICKHOUSE_MCP_QUERY_TIMEOUT}",
"CLICKHOUSE_ALLOW_WRITE_ACCESS": "${CLICKHOUSE_ALLOW_WRITE_ACCESS}"
},
"args": [
"run",
"--rm",
"-i",
"ghcr.io/clickhouse/mcp-clickhouse:0.4.1"
],
"command": "docker"
}
}
}能力范围
Server 能力
以下状态来自发布者提交的公开能力声明。
工具调用
向 Agent 提供可调用的操作。
资源读取
发布者未声明此能力。
提示词模板
发布者未声明此能力。
产品概览
Server 说明
了解用途、工作方式、能力边界与配置要求。
ClickHouse 是在官方 MCP Registry 登记并保持 active 状态的 Server，当前版本为 0.4.1。它面向数据访问与搜索场景，提供 Registry 声明的标准连接方式。
Registry 功能说明：Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
热门依据：MCPBeat 2026-08-25 每日榜单，按远程端点实测可用率或 npm/PyPI 真实周安装量排序。榜单详情：https://mcpbeat.com/mcp-servers/clickhouse/mcp-clickhouse/
收录时间：2026-08-26。安装前仍应按最小权限原则审查工具列表、认证范围和数据边界。