ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.
Connect Runs on your machine
claude mcp add mcp-clickhouse -e CLICKHOUSE_URL=<CLICKHOUSE_URL> -e CLICKHOUSE_USER=<CLICKHOUSE_USER> -e CLICKHOUSE_PASSWORD=<CLICKHOUSE_PASSWORD> -e CLICKHOUSE_MODE=<CLICKHOUSE_MODE> -- npx -y @dockndevai/[email protected]{
"mcpServers": {
"mcp-clickhouse": {
"command": "npx",
"args": [
"-y",
"@dockndevai/[email protected]"
],
"env": {
"CLICKHOUSE_URL": "<CLICKHOUSE_URL>",
"CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
"CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
"CLICKHOUSE_MODE": "<CLICKHOUSE_MODE>"
}
}
}
}{
"mcpServers": {
"mcp-clickhouse": {
"command": "npx",
"args": [
"-y",
"@dockndevai/[email protected]"
],
"env": {
"CLICKHOUSE_URL": "<CLICKHOUSE_URL>",
"CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
"CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
"CLICKHOUSE_MODE": "<CLICKHOUSE_MODE>"
}
}
}
}{
"servers": {
"mcp-clickhouse": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@dockndevai/[email protected]"
],
"env": {
"CLICKHOUSE_URL": "<CLICKHOUSE_URL>",
"CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
"CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
"CLICKHOUSE_MODE": "<CLICKHOUSE_MODE>"
}
}
}
}Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
CLICKHOUSE_URLOptional | ClickHouse HTTP endpoint. |
CLICKHOUSE_USEROptional | ClickHouse user (prefer a read-only user). |
CLICKHOUSE_PASSWORDOptional, secret | ClickHouse password. |
CLICKHOUSE_MODEOptional | Access mode: read-only | read-write | admin. |
Details
| Package | @dockndevai/[email protected] (NPM, stdio) |
| First published | 29 Sep 2026 |
| Last updated | 29 Sep 2026 |
| Registry name | io.github.dockndevai/mcp-clickhouse |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.