ClickHouse Cloud, verified
MCP server by ClickHouse · Verified
Run read-only SQL queries and inspect databases, tables and schemas on your ClickHouse Cloud services.
Connect to ClickHouse Cloud
ClickHouse Cloud needs sign-in. Connect with its own URL:
Your client opens ClickHouse’s sign-in the first time you use it. The token stays between your client and ClickHouse.
Share this server
Opens this page, with the URL and setup steps.
mcp.tc/i/clickhouse-cloudAbout
This is the managed remote MCP server for ClickHouse Cloud. It lets an assistant list databases and tables, inspect schemas and run read-only SELECT queries against your ClickHouse Cloud services. Tool calls run with the permissions of the signed-in user.
It runs as a hosted streamable HTTP endpoint at https://mcp.clickhouse.cloud/mcp. MCP must first be enabled for each service in the ClickHouse Cloud console. Users sign in with OAuth, and a ClickHouse Cloud API key can be used instead for headless clients. It is separate from the local mcp-clickhouse server.
What you can do
- List databases and tables in a ClickHouse Cloud service
- Inspect table schemas
- Run read-only SELECT queries
- Authenticate per user with OAuth
- Use a Cloud API key for headless clients
Tools
ClickHouse Cloud lists its tools only after you sign in, so we can’t show them here. Your client lists them once you’re connected.
Example prompts
List the databases and tables in my ClickHouse Cloud service.
Show the schema of the events table.
Run a SELECT counting rows per day in the last week from the logs table.
Which tables in analytics have a timestamp column?
Set up
Every client connects to mcp.clickhouse.cloud, and ClickHouse asks you to sign in the first time. Pick yours; the page remembers your choice.
Claude Code
- Run this in a terminal, in your project folder:
claude mcp add --transport http clickhouse-cloud https://mcp.clickhouse.cloud/mcp- Start Claude Code, type
/mcp, pick clickhouse-cloud and choose Authenticate. A browser window opens for the ClickHouse sign-in.
Add --scope user to make it available in every project, not just this one.
Claude Desktop
- Open Customize → Connectors, click + Add, then Add custom connector.
- Name it ClickHouse Cloud and paste this URL:
https://mcp.clickhouse.cloud/mcp- Click Add, then Connect, and sign in when ClickHouse asks.
Claude Desktop’s JSON config file only starts local servers. Remote servers go through Connectors, and connectors you add on claude.ai show up here too.
claude.ai
- Open the connector form on claude.ai. This button fills in the name and URL for you:
Add to claude.ai (opens in a new tab)
- Check that the URL reads
https://mcp.clickhouse.cloud/mcpand click Add. - Click Connect and sign in when ClickHouse asks.
Free plans allow one custom connector. On Team and Enterprise plans an owner adds it under Organization settings → Connectors.
ChatGPT
- On chatgpt.com, go to Plugins, select +, then Add custom MCP server.
- Enter a name for the server.
- Under Connection, paste
https://mcp.clickhouse.cloud/mcpas the server URL, then for authentication choose OAuth. ChatGPT sends you to ClickHouse to sign in. - Check I understand and want to continue, then select Create as a plugin.
Whether you can add a custom MCP server depends on your ChatGPT plan and your workspace permissions (in Business workspaces, admins and owners can).
Cursor
Add to Cursor (opens in a new tab)
Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):
{
"mcpServers": {
"clickhouse-cloud": {
"url": "https://mcp.clickhouse.cloud/mcp"
}
}
}Cursor shows Needs authentication next to the server. Click the button beside it to sign in.
VS Code
Install in VS Code (opens in a new tab)
Or from a terminal:
code --add-mcp '{"name":"clickhouse-cloud","type":"http","url":"https://mcp.clickhouse.cloud/mcp"}'Or commit it to the repo in .vscode/mcp.json:
{
"servers": {
"clickhouse-cloud": {
"type": "http",
"url": "https://mcp.clickhouse.cloud/mcp"
}
}
}VS Code asks you to sign in the first time the server starts.
Devin Desktop
- Add it to
~/.config/devin/mcp_config.json(macOS and Linux) or%APPDATA%\devin\mcp_config.json(Windows):
{
"mcpServers": {
"clickhouse-cloud": {
"serverUrl": "https://mcp.clickhouse.cloud/mcp"
}
}
}- Refresh the MCP server list in Cascade and sign in when asked.
Devin Desktop is the new name for Windsurf. It reads serverUrl (or url) for remote servers.
Codex
codex mcp add clickhouse-cloud --url https://mcp.clickhouse.cloud/mcp
codex mcp login clickhouse-cloudOr edit ~/.codex/config.toml directly:
[mcp_servers.clickhouse-cloud]
url = "https://mcp.clickhouse.cloud/mcp"Gemini CLI
gemini mcp add --transport http clickhouse-cloud https://mcp.clickhouse.cloud/mcpThen, inside Gemini CLI, run /mcp auth clickhouse-cloud to sign in.
This adds it to the current project. Add -s user to use it everywhere.
Any client
Most clients accept this shape. Some name the URL field differently: serverUrl in Devin Desktop, httpUrl in Gemini CLI’s settings file.
{
"mcpServers": {
"clickhouse-cloud": {
"type": "http",
"url": "https://mcp.clickhouse.cloud/mcp"
}
}
}Zed puts servers under context_servers in its settings. Cline needs "type": "streamableHttp", or it assumes SSE.
Client only starts local servers? Bridge it with npx -y mcp-remote https://mcp.clickhouse.cloud/mcp.
Embed
Show ClickHouse Cloud in a README or on your site. Each embed links to this page, uses the server’s own URL, and sets no cookies. How embeds work
The card, the iframe and the JSON are in English. Add ?lang=it, fr, de or es to their address for another language.
README badge
[](https://mcp.tc/i/clickhouse-cloud)<a href="https://mcp.tc/i/clickhouse-cloud"><img src="https://mcp.tc/i/clickhouse-cloud/badge.svg" alt="ClickHouse Cloud on mcp.tc" height="20"></a>It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.
Website card
<script src="https://mcp.tc/w/clickhouse-cloud.js" async></script>The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.
iframe
<iframe src="https://mcp.tc/embed/clickhouse-cloud" title="ClickHouse Cloud on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.
JSON
The listing as data for your own pages and tools: name, tagline, the server’s own URL, tools and the “Add to” links. Any site can read it (CORS is open).
https://mcp.tc/i/clickhouse-cloud.jsonAI prompt
Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the ClickHouse Cloud card to your site.
Add the mcp.tc card for ClickHouse Cloud, an MCP server, to my website. It is one static script: no build step, no package to install, no cookies.
Put this tag where the card should appear. The card renders right before it:
```html
<script src="https://mcp.tc/w/clickhouse-cloud.js" async></script>
```
To show the card somewhere else, put this placeholder there and load the same script once, for example before `</body>`. Keep the link inside: visitors without JavaScript see it.
```html
<div data-mcptc="clickhouse-cloud"><a href="https://mcp.tc/i/clickhouse-cloud">ClickHouse Cloud on mcp.tc</a></div>
```
Options:
- `data-theme="light"` or `"dark"` on the tag or the placeholder fixes the colors. Without it, the card follows the visitor’s light or dark mode.
- `data-size="compact"` gives a smaller card without the tagline.
- The CSS variable `--mcptc-max-width` on the placeholder or a parent sets the width (default `520px`).
- `?lang=` on the script URL sets the card’s language: `en`, `it`, `fr`, `de` or `es`.
If the site has a Content Security Policy, allow `script-src https://mcp.tc` and `img-src data:` (the icon is inline).
For a README or other Markdown docs, use the badge instead:
```markdown
[](https://mcp.tc/i/clickhouse-cloud)
```
Reference: https://mcp.tc/embedChange history
Its tools are behind a sign-in, so we can’t read them. Edits by its owner show up here.
Nothing recorded yet. Edits by the server’s owner will show up here.
FAQ
Can I paste mcp.tc/i/clickhouse-cloud into my MCP client?
No. mcp.tc links are pages, not server addresses. Connect with https://mcp.clickhouse.cloud/mcp, so your client talks to ClickHouse Cloud directly. The sign-in token only works there anyway. The quick link is for sharing: it opens this page, with setup steps for every client.
Does ClickHouse Cloud need an API key or a sign-in?
Yes, you need a ClickHouse account. The first time your client connects, it opens ClickHouse’s sign-in page. The token goes straight to the server’s own URL, never through mcp.tc.
Is ClickHouse Cloud a remote or a local server?
Remote. ClickHouse hosts it at https://mcp.clickhouse.cloud/mcp, and it speaks Streamable HTTP. There’s nothing to install.
What can ClickHouse Cloud do?
You can list databases and tables in a ClickHouse Cloud service, inspect table schemas and run read-only SELECT queries.
Which clients can use it?
Any client that supports remote MCP servers: Claude Code, Claude Desktop, claude.ai, ChatGPT, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. The setup steps cover each one.
Does mcp.tc track changes to ClickHouse Cloud?
Partly. ClickHouse Cloud’s tools are behind a sign-in, so its History tab shows only edits by its owner. Follow the listing to get an email when it changes.
Who wrote this page?
mcp.tc’s robot read ClickHouse Cloud’s own metadata (its MCP handshake, tool list and public pages), and an AI model drafted the text from it. A person reviews anything the checks can’t confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.
mcp.tc isn’t affiliated with ClickHouse. This page was built from ClickHouse Cloud’s public metadata, last checked on 17 Nov 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.