Skip to content
mcp/harbor
Cursor

ClickHouse for Cursor

io.github.clickhouse/mcp-clickhouse

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

client:Cursor transport:stdio runtime:pypi

Install ClickHouse in Cursor

~/.cursor/mcp.json · windows: %USERPROFILE%\.cursor\mcp.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen. 

{
  "mcpServers": {
    "mcp-clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>",
        "CLICKHOUSE_PORT": "<CLICKHOUSE_PORT>",
        "CLICKHOUSE_SECURE": "<CLICKHOUSE_SECURE>",
        "CLICKHOUSE_VERIFY": "<CLICKHOUSE_VERIFY>",
        "CLICKHOUSE_CA_CERT": "<CLICKHOUSE_CA_CERT>",
        "CLICKHOUSE_CLIENT_CERT": "<CLICKHOUSE_CLIENT_CERT>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<CLICKHOUSE_CLIENT_CERT_KEY>",
        "CLICKHOUSE_TLS_MODE": "<CLICKHOUSE_TLS_MODE>",
        "CLICKHOUSE_DATABASE": "<CLICKHOUSE_DATABASE>",
        "CLICKHOUSE_ROLE": "<CLICKHOUSE_ROLE>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<CLICKHOUSE_ALLOW_WRITE_ACCESS>",
        "CLICKHOUSE_ALLOW_DROP": "<CLICKHOUSE_ALLOW_DROP>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<CLICKHOUSE_MCP_QUERY_TIMEOUT>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<CLICKHOUSE_MCP_MAX_WORKERS>"
      }
    }
  }
}

Use .cursor/mcp.json in a project root instead to scope it to that project. Cursor merges both. Cursor docs

ClickHouse in other clients

ClickHouse MCP server