ClickHouse/mcp-clickhouse
Apache-2.0API key required🐍 ☁️ - ClickHouse database integration with schema inspection and query capabilities
Install
npx -y clickhouse-mcp-clickhouseRequired environment variables
CLICKHOUSE_MCP_AUTH_TOKENSet in your MCP configFASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRETSet in your MCP configCLIENT_CONFIG_OVERRIDES_KEYSet in your MCP configclaude_desktop_config.json
{
"mcpServers": {
"clickhouse-mcp-clickhouse": {
"command": "npx",
"args": [
"-y",
"clickhouse-mcp-clickhouse"
],
"env": {
"CLICKHOUSE_MCP_AUTH_TOKEN": "<YOUR_CLICKHOUSE_MCP_AUTH_TOKEN>",
"FASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRET": "<YOUR_FASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRET>",
"CLIENT_CONFIG_OVERRIDES_KEY": "<YOUR_CLIENT_CONFIG_OVERRIDES_KEY>"
}
}
}
}Add this to your Claude Desktop config file. Find it at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS.
What this does
ClickHouse/mcp-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. That makes it useful when you want Claude to reach into your databases without copy-pasting context every turn.
Requirements
This server needs the following environment variables to be set before it can run:
CLICKHOUSE_MCP_AUTH_TOKEN FASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRET CLIENT_CONFIG_OVERRIDES_KEY
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Common use cases
- •Query structured data without writing SQL by hand
- •Let Claude read table schemas before answering data questions
- •Run read-only operational reports or sanity checks during incidents
More Python MCP servers
microsoft/markitdown
🎖️ 🐍 🏠 - MCP tool access to MarkItDown -- a library that converts many file formats (local or remote) to Markdown for LLM consumption.
mindsdb/mindsdb
Connect and unify data across various platforms and databases with .
FastMCP
🐍 - A high-level framework for building MCP servers in Python
oraios/serena
🐍 🏠 - A fully-featured coding agent that relies on symbolic code operations by using language servers.