ClickHouse · VS Code (GitHub Copilot)
Add the ClickHouse MCP server to VS Code (GitHub Copilot)
Query and explore ClickHouse clusters and chDB.
1. Add the server
Run in your terminal
code --add-mcp '{"name":"clickhouse","command":"uvx","args":["mcp-clickhouse"],"env":{"CLICKHOUSE_HOST":"<your CLICKHOUSE_HOST>","CLICKHOUSE_USER":"<your CLICKHOUSE_USER>"}}'2. Sign in
VS Code opens the sign-in flow when Copilot first calls a remote OAuth server. ClickHouse runs locally and needs CLICKHOUSE_HOST, CLICKHOUSE_USER. Replace the placeholder values above with your own before starting VS Code (GitHub Copilot).
3. Try it
Ask VS Code (GitHub Copilot) for something ClickHouse can do. Query and explore ClickHouse clusters and chDB. Approve the first tool call and check the result before allowing write actions automatically.
- · mcp.json uses a top-level servers key, not mcpServers.
- · code --add-mcp installs a server into your user profile from the terminal.
FAQ
- How do I add the ClickHouse MCP server to VS Code (GitHub Copilot)?
- Run: code --add-mcp '{"name":"clickhouse","command":"uvx","args":["mcp-clickhouse"],"env":{"CLICKHOUSE_HOST":"<your CLICKHOUSE_HOST>","CLICKHOUSE_USER":"<your CLICKHOUSE_USER>"}}'. VS Code opens the sign-in flow when Copilot first calls a remote OAuth server.
- Is this the official ClickHouse MCP server?
- Yes. It is published by ClickHouse as io.github.ClickHouse/mcp-clickhouse in the official MCP registry.
- Does the ClickHouse MCP server need an API key?
- Yes. It runs locally and requires CLICKHOUSE_HOST, CLICKHOUSE_USER.
Links
ClickHouse in other clients
More databases for VS Code (GitHub Copilot)
Work at ClickHouse?
Feature ClickHouse across the directory and its category from $49/month.
Reviewed Oct 5, 2026. Command generated from the registry record and checked against VS Code (GitHub Copilot)'s documented syntax.