ClickHouse

Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.

build.protocol_tooling.mcp

Install ClickHouse in your MCP client

ClickHouse is a Model Context Protocol server. Add it to your MCP client config once, restart, and the server's tools become available to your AI assistant. The same JSON snippet below works across all four major clients — only the config file path differs.

  1. Locate your client's MCP config file.
    • Cursor: ~/.cursor/mcp.json
    • Claude Desktop (macOS): ~/Library/Application Support/Claude/claude_desktop_config.json
    • Claude Desktop (Windows): %APPDATA%\Claude\claude_desktop_config.json
    • VS Code: Settings → Extensions → MCP
    • Windsurf: Settings → MCP Servers
  2. Add ClickHouse to the mcpServers map — paste the snippet below into your config file. If you already have other MCP servers, merge the entry into the existing mcpServers object.
  3. Restart your client so it picks up the new server.
  4. Verify — ask the assistant to list available tools; ClickHouse's tools should appear.
{
  "mcpServers": {
    "clickhouse": {
      "command": "npx",
      "args": [
        "-y",
        "@clickhouse/mcp-server"
      ],
      "note": "Replace with the actual package name from the server's documentation."
    }
  }
}

Install ClickHouse in Cursor

Open ~/.cursor/mcp.json in your editor, paste the snippet above into mcpServers, save, and restart Cursor. ClickHouse will show up in the assistant's tool list on next launch.

Install ClickHouse in Claude Desktop (macOS)

Open ~/Library/Application Support/Claude/claude_desktop_config.json in your editor, paste the snippet above into mcpServers, save, and restart Claude Desktop (macOS). ClickHouse will show up in the assistant's tool list on next launch.

Install ClickHouse in Claude Desktop (Windows)

Open %APPDATA%\Claude\claude_desktop_config.json in your editor, paste the snippet above into mcpServers, save, and restart Claude Desktop (Windows). ClickHouse will show up in the assistant's tool list on next launch.

Install ClickHouse in VS Code

Open Settings → Extensions → MCP in your editor, paste the snippet above into mcpServers, save, and restart VS Code. ClickHouse will show up in the assistant's tool list on next launch.

Transport

ClickHouse supports the following MCP transports. Most AI clients use stdio by default for locally-installed servers.

stdio

Other Model Context Protocol servers in the same space as ClickHouse. Each one adds different capabilities to your AI assistant — pick based on the data sources or workflows you need.

Browse the full MCP server directory or use Stork's one-line install to let your agent pick the right server automatically.