Loading MCP server directory, please wait...
Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
npx @getmcp/cli add io.github.ClickHouse/mcp-clickhouseRequires Python 3.10+. Community-contributed server. Review source before installing.
CLICKHOUSE_HOSTHostname of the ClickHouse server
CLICKHOUSE_USERUsername for ClickHouse authentication
CLICKHOUSE_PASSWORDPassword for ClickHouse authentication
Config file: ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"io.github.ClickHouse/mcp-clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "",
"CLICKHOUSE_USER": "",
"CLICKHOUSE_PASSWORD": "",
"CLICKHOUSE_PORT": "",
"CLICKHOUSE_SECURE": "true",
"CLICKHOUSE_VERIFY": "true",
"CLICKHOUSE_DATABASE": "",
"CLICKHOUSE_ROLE": "",
"CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
"CLICKHOUSE_ALLOW_DROP": "false",
"CLICKHOUSE_MCP_QUERY_TIMEOUT": "30"
}
}
}
}