Can VS Code & GitHub Copilot Use ClickHouse? MCP Setup (2026)

Q: Can VS Code & GitHub Copilot use ClickHouse?

Yes. Add a remote URL in VS Code’s mcp.json ("type": "http"). We found no official ClickHouse server; the highest-rated live remote community server is SaturnSQL (trust grade C). Checked live on 2026-10-27.

Updated October 27, 2026 · from live checks of 50,180 MCP servers · Methodology

Built a third-party ClickHouse MCP server? Get the Verified vendor label so buyers can tell yours from the other 10 ($49/mo) Get Verified →

Remote ClickHouse servers

Server	Publisher	Status	Sign-in	Tools	Trust
SaturnSQL Yours? Claim it	Registry domain	Live · sign-in	OAuth sign-in	—	C
WaveHouse Cloud Yours? Claim it	Registry domain	Live · sign-in	OAuth sign-in	—	C
LightShip Yours? Claim it	Community	Down	API key	—	D

Local ClickHouse servers

Server	Publisher	Status	Sign-in	Tools	Trust
ClickHouse Yours? Claim it	Official	Local install	API key	—	A
DB Connect MCP Yours? Claim it	Community	Local install	API key	—	C
ClickHouse Yours? Claim it	Community	Local install	API key	—	C
MCP Clickhouse Yours? Claim it	Community	Local install	API key	—	C
nifi-clickhouse-kafka-mcp Yours? Claim it	Community	Local install	No auth	—	C
Universal DB (read-only) Yours? Claim it	Community	Local install	No auth	—	C
Clickhouse Dataops MCP Yours? Claim it	Community	Local install	API key	—	D
MCP Clickhouse Yours? Claim it	Community	Local install	No auth	—	D

How to add ClickHouse to VS Code & GitHub Copilot

Open the Command Palette and run MCP: Add Server. Choose HTTP for a server URL or Command (stdio) for a local install command.
Or edit .vscode/mcp.json in your workspace: VS Code’s format puts servers under a top-level "servers" object (remote: "type": "http" + "url"; local: "type": "stdio" + "command"). Portable Copilot files (.mcp.json, ~/.copilot/mcp-config.json) use "mcpServers" instead, so don’t copy between them unchecked.
Sign in if the server asks, then use its tools in Copilot agent chat.

Example for SaturnSQL (from the table above), in .vscode/mcp.json:

{
  "servers": {
    "clickhouse": {
      "type": "http",
      "url": "https://mcp.saturnsql.com/mcp"
    }
  }
}

Menus change, so check the VS Code MCP configuration reference. Every server page has a copy-paste config for VS Code & GitHub Copilot.

Is it safe to connect ClickHouse to VS Code & GitHub Copilot?

Use the official server run by ClickHouse. Anything a tool returns is sent to the AI vendor, so use a business plan that doesn't train on your data.

Can ChatGPT or Claude connect to ClickHouse?

See https://canmyaiuse.pages.dev/can/chatgpt/clickhouse/ and https://canmyaiuse.pages.dev/can/claude/clickhouse/

Does ClickHouse have an official MCP server?

Yes: ClickHouse (io.github.ClickHouse/mcp-clickhouse), published by ClickHouse in the official MCP Registry. Full list: https://canmyaiuse.pages.dev/apps/clickhouse/

Can VS Code & GitHub Copilot use ClickHouse?

Official ClickHouse route