加载中…
官方 ClickHouse MCP 服务器 用于 querying 和 exploring ClickHouse clusters 和 chDB。
ClickHouse 是 ChatHome Skills 收录的 MCP 条目，来源为 Official MCP Registry，质量分 73/100。 作为 Model Context Protocol 服务器，它向 Claude、Cursor、Copilot 等兼容 MCP 的 LLM 客户端暴露可直接调用的工具，让 agent 的能力超出模型内置范围。 该条目由 ChatHome Skills 的每日抓取从官方 registry 和 GitHub 发现查询中收录，每次运行都会重新核验仓库事实、新鲜度信号和安装元数据。 质量分综合了官方 registry 收录情况、可用安装命令、许可证完整性、仓库活跃度和 GitHub star 趋势，完整算法说明见来源页。安装命令已列于上方，可直接复制使用。 在将 ClickHouse 加入生产 agent 工作流前，请核对上方的最近更新日期和仓库状态——下方事实快照是最近一次抓取的时点值。
uvx mcp-clickhouse==0.7.0运行此命令前，请先核对上游源码。
{
"_meta": {
"io.modelcontextprotocol.registry/official": {
"status": "active",
"isLatest": true,
"updatedAt": "2026-09-21T14:02:19.431473Z",
"publishedAt": "2026-09-21T14:02:19.431473Z",
"statusChangedAt": "2026-09-21T14:02:19.431473Z"
}
},
"server": {
"name": "io.github.ClickHouse/mcp-clickhouse",
"title": "ClickHouse",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "0.7.0",
"packages": [
{
"version": "0.7.0",
"transport": {
"type": "stdio"
},
"identifier": "mcp-clickhouse",
"runtimeHint": "uvx",
"registryType": "pypi",
"environmentVariables": [
{
"name": "CLICKHOUSE_HOST",
"isRequired": true,
"description": "Hostname of the ClickHouse server"
},
{
"name": "CLICKHOUSE_USER",
"isRequired": true,
"description": "Username for ClickHouse authentication"
},
{
"name": "CLICKHOUSE_PASSWORD",
"isSecret": true,
"description": "Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode"
},
{
"name": "CLICKHOUSE_PORT",
"description": "ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise"
},
{
"name": "CLICKHOUSE_SECURE",
"format": "boolean",
"default": "true",
"description": "Use HTTPS to connect to ClickHouse"
},
{
"name": "CLICKHOUSE_VERIFY",
"format": "boolean",
"default": "true",
"description": "Verify SSL certificates"
},
{
"name": "CLICKHOUSE_CA_CERT",
"format": "filepath",
"description": "Path to a PEM CA bundle for ClickHouse server certificate verification"
},
{
"name": "CLICKHOUSE_CLIENT_CERT",
"format": "filepath",
"description": "Path to a PEM client certificate for the ClickHouse HTTPS connection"
},
{
"name": "CLICKHOUSE_CLIENT_CERT_KEY",
"format": "filepath",
"description": "Path to the PEM private key for CLICKHOUSE_CLIENT_CERT"
},
{
"name": "CLICKHOUSE_TLS_MODE",
"choices": [
"mutual",
"proxy",
"strict"
],
"description": "Client certificate mode: mutual, proxy, or strict"
},
{
"name": "CLICKHOUSE_DATABASE",
"description": "Default database to use"
},
{
"name": "CLICKHOUSE_ROLE",
"description": "ClickHouse role to activate for the session"
},
{
"name": "CLICKHOUSE_ALLOW_WRITE_ACCESS",
"format": "boolean",
"default": "false",
"description": "Allow write operations (DDL and DML). Queries run read-only by default"
},
{
"name": "CLICKHOUSE_ALLOW_DROP",
"format": "boolean",
"default": "false",
"description": "Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled"
},
{
"name": "CLICKHOUSE_MCP_QUERY_TIMEOUT",
"format": "number",
"default": "30",
"description": "Query tool timeout in seconds"
},
{
"name": "CLICKHOUSE_MCP_MAX_WORKERS",
"format": "number",
"default": "10",
"description": "Maximum query worker thread pool size"
}
]
},
{
"transport": {
"type": "stdio"
},
"identifier": "ghcr.io/clickhouse/mcp-clickhouse:0.7.0",
"registryType": "oci",
"environmentVariables": [
{
"name": "CLICKHOUSE_HOST",
"isRequired": true,
"description": "Hostname of the ClickHouse server"
},
{
"name": "CLICKHOUSE_USER",
"isRequired": true,
"description": "Username for ClickHouse authentication"
},
{
"name": "CLICKHOUSE_PASSWORD",
"isSecret": true,
"description": "Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode"
},
{
"name": "CLICKHOUSE_PORT",
"description": "ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise"
},
{
"name": "CLICKHOUSE_SECURE",
"format": "boolean",
"default": "true",
"description": "Use HTTPS to connect to ClickHouse"
},
{
"name": "CLICKHOUSE_VERIFY",
"format": "boolean",
"default": "true",
"description": "Verify SSL certificates"
},
{
"name": "CLICKHOUSE_CA_CERT",
"format": "filepath",
"description": "Path to a PEM CA bundle for ClickHouse server certificate verification"
},
{
"name": "CLICKHOUSE_CLIENT_CERT",
"format": "filepath",
"description": "Path to a PEM client certificate for the ClickHouse HTTPS connection"
},
{
"name": "CLICKHOUSE_CLIENT_CERT_KEY",
"format": "filepath",
"description": "Path to the PEM private key for CLICKHOUSE_CLIENT_CERT"
},
{
"name": "CLICKHOUSE_TLS_MODE",
"choices": [
"mutual",
"proxy",
"strict"
],
"description": "Client certificate mode: mutual, proxy, or strict"
},
{
"name": "CLICKHOUSE_DATABASE",
"description": "Default database to use"
},
{
"name": "CLICKHOUSE_ROLE",
"description": "ClickHouse role to activate for the session"
},
{
"name": "CLICKHOUSE_ALLOW_WRITE_ACCESS",
"format": "boolean",
"default": "false",
"description": "Allow write operations (DDL and DML). Queries run read-only by default"
},
{
"name": "CLICKHOUSE_ALLOW_DROP",
"format": "boolean",
"default": "false",
"description": "Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled"
},
{
"name": "CLICKHOUSE_MCP_QUERY_TIMEOUT",
"format": "number",
"default": "30",
"description": "Query tool timeout in seconds"
},
{
"name": "CLICKHOUSE_MCP_MAX_WORKERS",
"format": "number",
"default": "10",
"description": "Maximum query worker thread pool size"
}
]
}
],
"repository": {
"url": "https://github.com/ClickHouse/mcp-clickhouse",
"source": "github"
},
"websiteUrl": "https://clickhouse.com",
"description": "Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB."
}
}