OfficialLocalFree server, account needed

ClickHouse MCP server

ClickHouse/mcp-clickhouse

ClickHouse database integration with schema inspection and query capabilities.

899 GitHub stars210 forks

Install ClickHouse in Claude Code

PyPI (uv)

Claude Code
claude mcp add clickhouse -e CLICKHOUSE_HOST=... -e CLICKHOUSE_USER=... -- uvx mcp-clickhouse
mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)
{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "...",
        "CLICKHOUSE_USER": "..."
      }
    }
  }
}

Docker

Claude Code
claude mcp add clickhouse -e CLICKHOUSE_HOST=... -e CLICKHOUSE_USER=... -- docker run -i --rm -e CLICKHOUSE_HOST -e CLICKHOUSE_USER ghcr.io/clickhouse/mcp-clickhouse:0.7.0
mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)
{
  "mcpServers": {
    "clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "CLICKHOUSE_HOST",
        "-e",
        "CLICKHOUSE_USER",
        "ghcr.io/clickhouse/mcp-clickhouse:0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "...",
        "CLICKHOUSE_USER": "..."
      }
    }
  }
}

Replace each ... with your own value.

Frequently asked questions

What does the ClickHouse MCP server do?

ClickHouse database integration with schema inspection and query capabilities.

Is the ClickHouse MCP server free?

The server is free, but you will likely need an account. The server itself is free, but it connects to a service that needs an account or API key, which may have paid tiers. Check the provider for current pricing.

Does ClickHouse run locally or remotely?

Local. Runs on your machine (stdio). You install it with npx, uvx, Docker or from source.

How do I add ClickHouse to Claude Code?

Run: claude mcp add clickhouse -e CLICKHOUSE_HOST=... -e CLICKHOUSE_USER=... -- uvx mcp-clickhouse

More databases MCP servers

View all