Loading…
Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
ClickHouse is an MCP server entry in ChatHome Skills, sourced from Official MCP Registry and scored 73/100. As a Model Context Protocol server, it exposes tools that MCP-compatible LLM clients such as Claude, Cursor, and Copilot can call directly, extending an agent's reach beyond its built-in capabilities. ChatHome Skills discovered this entry through its daily ingest of official registries and GitHub discovery queries, and re-verifies repository facts, freshness signals, and install metadata on every run. The quality score weighs official-registry presence, a working install command, license clarity, GitHub star trajectory, and repository freshness — the full formula is on the Sources page. The install command above is ready to copy. Review the last-pushed date and repository status before adding ClickHouse to a production agent workflow; the snapshot facts below are point-in-time values from the most recent ingest.
uvx mcp-clickhouse==0.7.0Review the upstream source before running this command.
{
"_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."
}
}