Add the ClickHouse MCP server to Cursor

Config last verified Jun 1, 2026

The exact config to run ClickHouse in Cursor — paste it in, restart, and the tools load.

Prerequisites

Cursor installed.
CLICKHOUSE_HOST — Hostname of your ClickHouse server.
CLICKHOUSE_USER — ClickHouse username used to authenticate.
CLICKHOUSE_PASSWORD — Password for the ClickHouse user.

Setup

1. Open `~/.cursor/mcp.json`

2. Add this configuration

Add to ~/.cursor/mcp.json

~/.cursor/mcp.json

json

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "--with",
        "mcp-clickhouse",
        "--python",
        "3.10",
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

3. Restart Cursor and confirm the ClickHouse tools load.

Gotchas

Cursor keeps MCP servers under an "mcpServers" object in ~/.cursor/mcp.json for global use, and also reads a project-scoped .cursor/mcp.json so a repository can ship its own servers. Remote servers are configured with a bare "url" field and connect natively, with OAuth handled in-app when a server requires it.

← Back to the ClickHouse MCP server