A MCP server implementation for ClickHouse database integration
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"clickhouse-mcp-server","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# Clickhouse MCP server [](https://smithery.ai/server/@burakdirin/clickhouse-mcp-server) A Clickhouse database MCP server project. ## Installation You can install the package using `uv`: ```bash uv pip install clickhouse-mcp-server ``` Or using `pip`: ```bash pip install clickhouse-mcp-server ``` ## Components ### Tools The server provides two tools: - `connect_database`: Connects to a specific Clickhouse database - `database` parameter: Name of the database to connect to (string) - Returns a confirmation message when connection is successful - `execute_query`: Executes Clickhouse queries - `query` parameter: SQL query/queries to execute (string) - Returns query results in JSON format - Multiple queries can be sent separated by semicolons ## Configuration The server uses the following environment variables: - `CLICKHOUSE_HOST`: Clickhouse server address (default: "localhost") - `CLICKHOUSE_USER`: Clickhouse username (default: "root") - `CLICKHOUSE_PASSWORD`: Clickhouse password (default: "") - `CLICKHOUSE_DATABASE`: Initial database (optional) - `CLICKHOUSE_READONLY`: Read-only mode (set to 1/true to enable, default: false) ## Quickstart ### Installation #### Claude Desktop MacOS: `~/Library/Application\ Support/Claude/claude_desktop_config.json` Windows: `%APPDATA%/Claude/claude_desktop_config.json` <details> <summary>Development/Unpublished Server Configuration</summary> ```json { "mcpServers": { "clickhouse-mcp-server": { "command": "uv", "args": [ "--directory", "/Users/burakdirin/Projects/clickhouse-mcp-server", "run", "clickhouse-mcp-server" ], "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_USER": "root", "CLICKHOUSE_PASSWORD": "password", "CLICKHOUSE_DATABASE": "[optional]", "CLICKHOUSE_READONLY": "true" } } } } ``` </details> <de…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.