ClickHouse

ClickHouse is a hosted MCP server for analytical ClickHouse Cloud queries and table inspection. Its connected endpoint exposes 0 tools after authorization.

Add to Longwave

Install elsewhere

Install ClickHouse

Choose a harness. These instructions connect to the hosted MCP endpoint shown on this page.

Claude Code

Run this in your terminal. It adds a user-scoped server; use --scope project instead if it should apply only to the current project.

terminal

claude mcp add --scope user --transport http clickhouse https://mcp.clickhouse.cloud/mcp

Claude Desktop

Open Claude Desktop → Settings → Developer → Edit Config. Add this entry to claude_desktop_config.json, save it, then fully restart Claude Desktop.

claude_desktop_config.json

{
  "mcpServers": {
    "clickhouse": {
      "url": "https://mcp.clickhouse.cloud/mcp"
    }
  }
}

Codex

Run this in the Codex CLI:

terminal

codex mcp add clickhouse --url https://mcp.clickhouse.cloud/mcp

Codex stores the same server in ~/.codex/config.toml (or a trusted project’s .codex/config.toml):

~/.codex/config.toml

[mcp_servers.clickhouse]
url = "https://mcp.clickhouse.cloud/mcp"

Cursor

Add this to .cursor/mcp.json for the current project or ~/.cursor/mcp.json for all projects. Cursor resolves ${env:NAME} from your environment.

.cursor/mcp.json

{
  "mcpServers": {
    "clickhouse": {
      "type": "streamable-http",
      "url": "https://mcp.clickhouse.cloud/mcp"
    }
  }
}

OpenCode

Add this server under the mcp object in opencode.json or opencode.jsonc. You can also run opencode mcp add and follow its prompts.

opencode.json

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "clickhouse": {
      "type": "remote",
      "url": "https://mcp.clickhouse.cloud/mcp",
      "enabled": true
    }
  }
}

What it does

ClickHouse MCP is for analytical database work. The agent can inspect tables and form queries against ClickHouse Cloud rather than treating an analytics warehouse like a generic SQL endpoint.

Inspect ClickHouse Cloud tables.
Run analytical queries.
Pass identifiers and query parameters explicitly.
Use the live schema returned by the endpoint.
Keep ClickHouse Cloud authorization outside the agent's prompt.

Questions people ask

How do I use ClickHouse MCP in Cursor?

Add the hosted ClickHouse Cloud connection to Cursor's MCP settings and complete the ClickHouse authorization flow.

How do I use ClickHouse MCP with Claude Code?

Connect the hosted ClickHouse Cloud endpoint in Claude Code and authorize the ClickHouse Cloud account. Claude Code can use the operations returned after the connection initializes.

Is ClickHouse MCP a remote server?

Yes. The catalog entry uses ClickHouse Cloud's hosted MCP endpoint. The client connects to that endpoint instead of starting a local ClickHouse MCP process.

Can ClickHouse MCP inspect tables?

Yes. Table inspection is one of the entry's stated uses. The live function schema defines the available table and query arguments after authorization.

Does ClickHouse MCP work with a self-hosted ClickHouse instance?

No. This catalog entry is the ClickHouse Cloud hosted server. A self-hosted instance needs a separate local MCP server pointed at that host.

What does ClickHouse MCP need to run?

A ClickHouse Cloud account and the hosted MCP server enabled on the service. There is no local `uv` process and no host, user or password to paste.

Put the warehouse behind the analysis.

Let the agent inspect ClickHouse tables and query the data instead of working from exports.

Download Longwave