We and selected third parties use cookies or similar technologies for technical purposes and, with your consent, to analyze how the site is used.

You can freely give, refuse or withdraw your consent at any time.

ClickHouse, verified

MCP server by ClickHouse · Verified

Run read-only SQL and explore databases and tables on any ClickHouse cluster or in the embedded chDB engine.

Runs locally (Runs on your machine: its page has the install command)Runs with uvxNeeds an API key

Install ClickHouse

Runs on your machine. Your client starts it with this command:

uvx mcp-clickhouse

Needs uv (Python) on your computer. The setup steps below show where the command goes in each client.

  • CLICKHOUSE_HOST Hostname of the ClickHouse server
  • CLICKHOUSE_USER Username for ClickHouse authentication
  • CLICKHOUSE_PASSWORD secret optional Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode
  • CLICKHOUSE_PORT optional ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise
  • CLICKHOUSE_SECURE optional Use HTTPS to connect to ClickHouse
  • CLICKHOUSE_VERIFY optional Verify SSL certificates

Share this server

Opens this page, with the install command and setup steps.

mcp.tc/i/clickhouse

About

Connects an assistant to a ClickHouse cluster or to chDB, the embedded ClickHouse engine. It can run SQL queries, list databases, list tables with pagination and filters, and run SELECT queries through chDB. Queries are read-only by default, and writes can be enabled explicitly. Parameterized queries with typed placeholders are supported.

Runs locally over stdio with uvx mcp-clickhouse (PyPI package), or as the ghcr.io/clickhouse/mcp-clickhouse container image. It needs CLICKHOUSE_HOST and CLICKHOUSE_USER, plus CLICKHOUSE_PASSWORD unless a client certificate is used. Optional variables set the port, TLS options, default database and role.

What you can do

  • Run SQL queries on a ClickHouse cluster, read-only by default
  • List all databases on the cluster
  • List tables in a database with LIKE filters and pagination
  • Bind typed query parameters with ClickHouse placeholders
  • Check a query with DESCRIBE or EXPLAIN ESTIMATE before running it
  • Run SELECT queries on the embedded chDB engine

Tools

ClickHouse lists its tools only to clients with a key, so we can’t show them here.

Example prompts

  • List all databases on my ClickHouse cluster.

  • Show the tables in the analytics database that start with events_.

  • Count rows per day in default.events for the last 30 days.

  • Estimate how many rows this query would read before running it.

Set up

Every client starts ClickHouse on your machine with the same command. Pick yours; the page remembers your choice.

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport stdio clickhouse --env "CLICKHOUSE_HOST=<YOUR_CLICKHOUSE_HOST>" --env "CLICKHOUSE_USER=<YOUR_CLICKHOUSE_USER>" --env "CLICKHOUSE_PASSWORD=<YOUR_CLICKHOUSE_PASSWORD>" -- uvx mcp-clickhouse
  1. Start Claude Code and type /mcp. clickhouse should show as connected.

Add --scope user to make it available in every project. Replace the placeholders with your own values.

Claude Desktop

  1. Open Settings → Developer → Edit Config. It opens claude_desktop_config.json. Add:
claude_desktop_config.json
{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}
  1. Save the file and restart Claude Desktop. Replace the placeholders with your own values.

Needs uv (Python) on your computer. The file lives in ~/Library/Application Support/Claude/ on macOS and %APPDATA%\Claude\ on Windows.

Cursor

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

mcp.json
{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Needs uv (Python) on your computer. Replace the placeholders with your own values.

VS Code

Add it to .vscode/mcp.json. VS Code asks for the secret the first time and stores it securely:

.vscode/mcp.json
{
  "servers": {
    "clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "${input:clickhouse-password}"
      }
    }
  },
  "inputs": [
    {
      "type": "promptString",
      "id": "clickhouse-password",
      "description": "CLICKHOUSE_PASSWORD",
      "password": true
    }
  ]
}

Needs uv (Python) on your computer.

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}
  1. Refresh the MCP server list in Cascade. Replace the placeholders with your own values.

Devin Desktop is the new name for Windsurf.

Codex

codex mcp add clickhouse --env "CLICKHOUSE_HOST=<YOUR_CLICKHOUSE_HOST>" --env "CLICKHOUSE_USER=<YOUR_CLICKHOUSE_USER>" --env "CLICKHOUSE_PASSWORD=<YOUR_CLICKHOUSE_PASSWORD>" -- uvx mcp-clickhouse

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.clickhouse]
command = "uvx"
args = ["mcp-clickhouse"]
env = { CLICKHOUSE_HOST = "<YOUR_CLICKHOUSE_HOST>", CLICKHOUSE_USER = "<YOUR_CLICKHOUSE_USER>", CLICKHOUSE_PASSWORD = "<YOUR_CLICKHOUSE_PASSWORD>" }

Needs uv (Python) on your computer. Replace the placeholders with your own values.

Gemini CLI

gemini mcp add -e "CLICKHOUSE_HOST=<YOUR_CLICKHOUSE_HOST>" -e "CLICKHOUSE_USER=<YOUR_CLICKHOUSE_USER>" -e "CLICKHOUSE_PASSWORD=<YOUR_CLICKHOUSE_PASSWORD>" clickhouse uvx mcp-clickhouse

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients that start local servers accept this shape:

{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<YOUR_CLICKHOUSE_HOST>",
        "CLICKHOUSE_USER": "<YOUR_CLICKHOUSE_USER>",
        "CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD>"
      }
    }
  }
}

Zed puts servers under context_servers in its settings, with the same command, args and env fields.

Needs uv (Python) on your computer. Replace the placeholders with your own values.

Embed

Show ClickHouse in a README or on your site. Each embed links to this page, uses the server’s own install command, 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

Badge preview, lightBadge preview, dark
Markdown
[![ClickHouse on mcp.tc](https://mcp.tc/i/clickhouse/badge.svg)](https://mcp.tc/i/clickhouse)
HTML
<a href="https://mcp.tc/i/clickhouse"><img src="https://mcp.tc/i/clickhouse/badge.svg" alt="ClickHouse 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

HTML
<script src="https://mcp.tc/w/clickhouse.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

HTML
<iframe src="https://mcp.tc/embed/clickhouse" title="ClickHouse 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, install command, tools and the “Add to” links. Any site can read it (CORS is open).

https://mcp.tc/i/clickhouse.json

What each field means

AI prompt

Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the ClickHouse card to your site.

Markdown
Add the mcp.tc card for ClickHouse, 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.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"><a href="https://mcp.tc/i/clickhouse">ClickHouse 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
[![ClickHouse on mcp.tc](https://mcp.tc/i/clickhouse/badge.svg)](https://mcp.tc/i/clickhouse)
```

Reference: https://mcp.tc/embed

Change history

This server runs on your computer, so we follow its PyPI package: each new version shows up here, with edits by its owner.

Follow ClickHouse and we’ll email you when something changes.

  1. , Automatic check

    Tracking started: version 0.7.0.

FAQ

Can I paste mcp.tc/i/clickhouse into my MCP client?

No. ClickHouse runs on your own computer, started by your client, so it has no web address to connect to. The quick link is the page to share; the install command is uvx mcp-clickhouse.

Does ClickHouse need an API key?

Yes. It reads CLICKHOUSE_HOST, CLICKHOUSE_USER and CLICKHOUSE_PASSWORD from its environment, and CLICKHOUSE_PASSWORD is a secret. Put the value in your client’s config on your own machine, never in a shared file.

Is ClickHouse a remote or a local server?

Local. Your client starts it as a process on your computer with uvx mcp-clickhouse, which needs uv (Python).

What can ClickHouse do?

You can run SQL queries on a ClickHouse cluster, read-only by default, list all databases on the cluster and list tables in a database with LIKE filters and pagination.

Which clients can use it?

Any client that starts local servers: Claude Code, Claude Desktop, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. claude.ai and ChatGPT only connect to remote servers.

Does mcp.tc track changes to ClickHouse?

Partly. It runs on your computer, so we follow its PyPI package: its History tab shows each new version and edits by its owner. Follow the listing to get an email when it changes.

Who wrote this page?

mcp.tc’s robot read ClickHouse’s public metadata (its package and repository 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’s public metadata, last checked on 3 Oct 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.