ClickHouse MCP Server

by dockndevaiio.github.dockndevai/mcp-clickhousev0.3.0

ClickHouse schema exploration, analytical queries and management, with statements gated by access mode, row caps and auditing.

3Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active11d ago

Install ClickHouse MCP server

claude mcp add clickhouse-dockndevai -e CLICKHOUSE_PASSWORD='<clickhouse-password>' -- npx -y @dockndevai/mcp-clickhouse

{
  "mcpServers": {
    "clickhouse-dockndevai": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "clickhouse-dockndevai": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "clickhouse-dockndevai": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "clickhouse-dockndevai": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
CLICKHOUSE_URL	—	—	ClickHouse HTTP endpoint.
CLICKHOUSE_USER	—	—	ClickHouse user (prefer a read-only user).
CLICKHOUSE_PASSWORD	—	yes	ClickHouse password.
CLICKHOUSE_MODE	—	—	Access mode: read-only \| read-write \| admin.

Freshness

Active — last maintenance signal 11d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-09-29 · 11d ago · GitHub
Latest release
2026-09-29 · 11d ago · GitHub · v0.3.0
Package published
no data · npm/PyPI
Registry entry updated
2026-09-29 · 11d ago · official registry · v0.3.0

FAQ

›How do I install the ClickHouse MCP server in Claude Code?

Run: claude mcp add clickhouse-dockndevai -e CLICKHOUSE_PASSWORD='<clickhouse-password>' -- npx -y @dockndevai/mcp-clickhouse. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does ClickHouse require an API key?

Yes. It expects CLICKHOUSE_PASSWORD, of which 1 is a secret.

›Can I use ClickHouse as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is ClickHouse in the official MCP registry?

Yes, as io.github.dockndevai/mcp-clickhouse.