ClickHouse

Official 🗄️ Data & Files

The official ClickHouse MCP server enables AI agents to query and explore ClickHouse databases. Supports both ClickHouse Cloud and self-hosted instances with read-only access by default. Optional write access for data modification operations.

Tools (4)

Client configuration

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.6.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "your-clickhouse-host-here",
        "CLICKHOUSE_USER": "your-clickhouse-user-here",
        "CLICKHOUSE_PASSWORD": "your-clickhouse-password-here",
        "CLICKHOUSE_SECURE": "your-clickhouse-secure-here"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse@0.6.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "your-clickhouse-host-here",
        "CLICKHOUSE_USER": "your-clickhouse-user-here",
        "CLICKHOUSE_PASSWORD": "your-clickhouse-password-here",
        "CLICKHOUSE_SECURE": "your-clickhouse-secure-here"
      },
      "type": "stdio"
    }
  }
}

Replace the placeholders before connecting. Authorize in your client when prompted.

The Cursor JSON also works in Claude Desktop's local MCP configuration. Install the required runtime and local software first.

Documentation →

Activate on Zubnet →

ClickHouse

Tags

Tools (4)

Client configuration

Cursor (.cursor/mcp.json)

VS Code (.vscode/mcp.json)

Related Servers