Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
To add ClickHouse to Claude, run the install command below or copy the ready-made config for Claude Code, Claude Desktop, Cursor and VS Code further down. Restart your client after adding it and its tools show up in your next conversation. It needs 16 environment variables, listed below.
Install
uvx mcp-clickhouse@0.7.0Environment variables
CLICKHOUSE_HOSTSet in your MCP configCLICKHOUSE_USERSet in your MCP configCLICKHOUSE_PASSWORDSet in your MCP configCLICKHOUSE_PORTSet in your MCP configCLICKHOUSE_SECURESet in your MCP configCLICKHOUSE_VERIFYSet in your MCP configCLICKHOUSE_CA_CERTSet in your MCP configCLICKHOUSE_CLIENT_CERTSet in your MCP configCLICKHOUSE_CLIENT_CERT_KEYSet in your MCP configCLICKHOUSE_TLS_MODESet in your MCP configCLICKHOUSE_DATABASESet in your MCP configCLICKHOUSE_ROLESet in your MCP configCLICKHOUSE_ALLOW_WRITE_ACCESSSet in your MCP configCLICKHOUSE_ALLOW_DROPSet in your MCP configCLICKHOUSE_MCP_QUERY_TIMEOUTSet in your MCP configCLICKHOUSE_MCP_MAX_WORKERSSet in your MCP configInstall with your client
claude mcp add clickhouse --env CLICKHOUSE_HOST=<YOUR_CLICKHOUSE_HOST> --env CLICKHOUSE_USER=<YOUR_CLICKHOUSE_USER> --env CLICKHOUSE_PASSWORD=<YOUR_CLICKHOUSE_PASSWORD> --env CLICKHOUSE_PORT=<YOUR_CLICKHOUSE_PORT> --env CLICKHOUSE_SECURE=<YOUR_CLICKHOUSE_SECURE> --env CLICKHOUSE_VERIFY=<YOUR_CLICKHOUSE_VERIFY> --env CLICKHOUSE_CA_CERT=<YOUR_CLICKHOUSE_CA_CERT> --env CLICKHOUSE_CLIENT_CERT=<YOUR_CLICKHOUSE_CLIENT_CERT> --env CLICKHOUSE_CLIENT_CERT_KEY=<YOUR_CLICKHOUSE_CLIENT_CERT_KEY> --env CLICKHOUSE_TLS_MODE=<YOUR_CLICKHOUSE_TLS_MODE> --env CLICKHOUSE_DATABASE=<YOUR_CLICKHOUSE_DATABASE> --env CLICKHOUSE_ROLE=<YOUR_CLICKHOUSE_ROLE> --env CLICKHOUSE_ALLOW_WRITE_ACCESS=<YOUR_CLICKHOUSE_ALLOW_WRITE_ACCESS> --env CLICKHOUSE_ALLOW_DROP=<YOUR_CLICKHOUSE_ALLOW_DROP> --env CLICKHOUSE_MCP_QUERY_TIMEOUT=<YOUR_CLICKHOUSE_MCP_QUERY_TIMEOUT> --env CLICKHOUSE_MCP_MAX_WORKERS=<YOUR_CLICKHOUSE_MCP_MAX_WORKERS> -- uvx mcp-clickhouse@0.7.0
Run this in a terminal to add the server to Claude Code.
What this does
ClickHouse exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation.
Requirements
This server needs the following environment variables to be set before it can run:
CLICKHOUSE_HOST CLICKHOUSE_USER CLICKHOUSE_PASSWORD CLICKHOUSE_PORT CLICKHOUSE_SECURE CLICKHOUSE_VERIFY CLICKHOUSE_CA_CERT CLICKHOUSE_CLIENT_CERT CLICKHOUSE_CLIENT_CERT_KEY CLICKHOUSE_TLS_MODE CLICKHOUSE_DATABASE CLICKHOUSE_ROLE CLICKHOUSE_ALLOW_WRITE_ACCESS CLICKHOUSE_ALLOW_DROP CLICKHOUSE_MCP_QUERY_TIMEOUT CLICKHOUSE_MCP_MAX_WORKERS
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Frequently asked questions
How do I install ClickHouse?
Run the Claude Code command in the install section to add ClickHouse to Claude Code, or copy the ready-made config for your client from the install section on this page. Restart your client afterwards and the tools appear in your next conversation.
Which clients work with ClickHouse?
This page carries setup and config for Claude Code, Claude Desktop, Cursor and VS Code. Any other MCP client that accepts a standard server config can connect to ClickHouse as well.
Does ClickHouse need an API key?
Yes. Before it can run, set these environment variables: CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_PORT, CLICKHOUSE_SECURE, CLICKHOUSE_VERIFY, CLICKHOUSE_CA_CERT, CLICKHOUSE_CLIENT_CERT, CLICKHOUSE_CLIENT_CERT_KEY, CLICKHOUSE_TLS_MODE, CLICKHOUSE_DATABASE, CLICKHOUSE_ROLE, CLICKHOUSE_ALLOW_WRITE_ACCESS, CLICKHOUSE_ALLOW_DROP, CLICKHOUSE_MCP_QUERY_TIMEOUT, CLICKHOUSE_MCP_MAX_WORKERS. They go in the env block of your MCP config.
What license is ClickHouse under?
ClickHouse is listed under the Apache-2.0 license.
Imported from the Official MCP Registry. The details above come from the registry entry; the maker can claim this listing to correct them, add docs, and see its traffic.
Is this your MCP server?
Claim this listing to see its traffic, fix details yourself, and skip the review queue on future updates.
Add this badge to your README
Show visitors this server is listed in the ClaudeRules directory. The badge links straight to this listing.
[](https://clauderules.net/mcp/clickhouse-mcp-clickhouse)<a href="https://clauderules.net/mcp/clickhouse-mcp-clickhouse" target="_blank" rel="noopener noreferrer"><img src="https://clauderules.net/api/badge/clickhouse-mcp-clickhouse" alt="Listed on clauderules.net" /></a>More DevTools MCP servers
GitHub
Connect AI assistants to GitHub - manage repos, issues, PRs, and workflows through natural language.
Serena MCP: the IDE for your agent
A powerful toolkit for coding, providing semantic retrieval and editing capabilities.
Figma-Context-MCP
Give your coding agent access to your Figma data. Implement designs in any framework in one-shot.
Inbox Zero
Search Gmail and Outlook, save drafts, manage email rules, and view email stats.