Back to MCP Servers
🔌

ClickHouse/mcp-clickhouse

Apache-2.0API key required

🐍 ☁️ - ClickHouse database integration with schema inspection and query capabilities

PythonDatabases

Install

npx -y clickhouse-mcp-clickhouse

Required environment variables

CLICKHOUSE_MCP_AUTH_TOKENSet in your MCP config
FASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRETSet in your MCP config
CLIENT_CONFIG_OVERRIDES_KEYSet in your MCP config

claude_desktop_config.json

claude_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.