# ClickHouse (oci · ghcr.io/clickhouse/mcp-clickhouse:0.6.0)

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

- Trust score: 46/100 (low)
- Change this week: +3
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-09-20

## Components

- oci · `ghcr.io/clickhouse/mcp-clickhouse:0.6.0`: 46/100 (this document), [markdown](https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-6-0.md), [page](https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-6-0)
- pypi · `mcp-clickhouse`: 78/100, [markdown](https://verifymcp.io/servers/clickhouse-mcp-clickhouse/mcp-clickhouse.md), [page](https://verifymcp.io/servers/clickhouse-mcp-clickhouse/mcp-clickhouse)

## Channel facts

- Registry: `oci`
- Package: `ghcr.io/clickhouse/mcp-clickhouse:0.6.0`
- Transport: `stdio`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-09-20.

- **Supply Chain Security**: 0/100
  - Malware scan not yet available for this package.
  - Known CVEs could not be checked: this artifact ships no SBOM, so there is no dependency list to read. Publishing one would let us assess it.
  - Install-script risk not yet assessed.
  - Dependency health could not be checked: this artifact ships no SBOM, so there is no dependency list to read. Publishing one would let us assess it.
- **Provenance & Transparency**: 45/100
  - Source repository is publicly reachable at the declared URL.
  - Provenance check failed: no build-provenance attestation is published.
  - Clear OSI-approved license (Apache-2.0).
  - Actively maintained (last published 16 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 74/100
  - AI-judged instruction clarity (good).
  - Context-footprint check failed: tool/resource definitions use about 420 tokens (~140/item across 3 items; 3 tools + 0 resources), over budget; trim descriptions and params.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 57/100
  - Stability observed for 17 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 96/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 86% of tool parameters carry a description.
  - Structured output schemas are declared (100% of tools); any adoption earns full credit.
- **Tool Safety**: 75/100
  - No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.
  - 0 of 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "run_query" implies "execute" and declares no destructiveHint at all, which the MCP spec reads as destructive by default.
  - An AI judge read all 4 captured unit(s) of tool text and found none that tries to manipulate the model reading it.
- **Capabilities**: 100/100
  - Implements a current MCP spec version (2026-07-28).

**Unverified: 1 category.** A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.

## Install

### How do I install the ClickHouse MCP server?

ClickHouse runs locally as a container image, launched with docker run --rm -i ghcr.io/clickhouse/mcp-clickhouse:0.6.0. Ready-made configuration for Claude, Cursor, VS Code, Codex and 3 more is on this page, copied from each client's own documentation.

### Claude

```bash
claude mcp add clickhouse-mcp-clickhouse -- docker run --rm -i ghcr.io/clickhouse/mcp-clickhouse:0.6.0
```

### Cursor

```json
{
  "mcpServers": {
    "clickhouse-mcp-clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "ghcr.io/clickhouse/mcp-clickhouse:0.6.0"
      ]
    }
  }
}
```

### VS Code

```json
{
  "servers": {
    "clickhouse-mcp-clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "ghcr.io/clickhouse/mcp-clickhouse:0.6.0"
      ]
    }
  }
}
```

### Codex

```bash
codex mcp add clickhouse-mcp-clickhouse -- docker run --rm -i ghcr.io/clickhouse/mcp-clickhouse:0.6.0
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "clickhouse-mcp-clickhouse": {
      "type": "local",
      "command": [
        "docker",
        "run",
        "--rm",
        "-i",
        "ghcr.io/clickhouse/mcp-clickhouse:0.6.0"
      ],
      "enabled": true
    }
  }
}
```

### Hermes

```yaml
mcp_servers:
  clickhouse-mcp-clickhouse:
    command: "docker"
    args: ["run", "--rm", "-i", "ghcr.io/clickhouse/mcp-clickhouse:0.6.0"]
```

### Netclaw

```json
{
  "McpServers": {
    "clickhouse-mcp-clickhouse": {
      "Transport": "stdio",
      "Command": "docker",
      "Arguments": [
        "run",
        "--rm",
        "-i",
        "ghcr.io/clickhouse/mcp-clickhouse:0.6.0"
      ]
    }
  }
}
```

### Other

```json
{
  "mcpServers": {
    "clickhouse-mcp-clickhouse": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "ghcr.io/clickhouse/mcp-clickhouse:0.6.0"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-09-18 (score 46, +1)

No change was recorded against any check on this day. Stability & Change Management went from 47 to 50. That category is still filling its 30-day observation window: 14 days of observed history at the previous scan, 15 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-16 (score 45, +1)

No change was recorded against any check on this day. Stability & Change Management went from 40 to 43. That category is still filling its 30-day observation window: 12 days of observed history at the previous scan, 13 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-14 (score 44, +1)

No change was recorded against any check on this day. Stability & Change Management went from 33 to 37. That category is still filling its 30-day observation window: 10 days of observed history at the previous scan, 11 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-12 (score 43, +1)

No change was recorded against any check on this day. Stability & Change Management went from 27 to 30. That category is still filling its 30-day observation window: 8 days of observed history at the previous scan, 9 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-11 (score 42, +3)

- [functional improvement] Stability: unverified → 0.27

### 2026-09-03 (score 39)

First indexed and scored.

## MCP tools (3)

### `list_databases` (~15 tokens)

List Databases

List available ClickHouse databases

Output parameters:

- `result` (string)

### `list_tables` (~205 tokens)

List Tables

List available ClickHouse tables in a database, including schema, comment,
row count, and column count.

Integers outside [-9007199254740991, 9007199254740991] in table metadata are
returned as decimal strings.
Pagination tokens are single-use and retained for up to one hour.

Input parameters:

- `database` (string, required): The database to list tables from
- `include_detailed_columns` (boolean): Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for la…
- `like`: Optional LIKE pattern to filter table names
- `not_like`: Optional NOT LIKE pattern to exclude table names
- `page_size` (integer): Number of tables to return per page (default: 50, must be greater than 0)
- `page_token`: Single-use token from a previous call, retained for up to one hour

Output parameters:

- `result` (string)

### `run_query` (~136 tokens)

Run Query

Execute SQL queries in ClickHouse. Queries run in read-only mode by default. Set CLICKHOUSE_ALLOW_WRITE_ACCESS=true to allow DDL and DML operations. Set CLICKHOUSE_ALLOW_DROP=true to additionally allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE TABLE/PARTITION, CREATE OR REPLACE, CLEAR COLUMN/INDEX/PROJECTION, DETACH PERMANENTLY). That gate is a best-effort accident guard, not a security boundary. Integers outside [-9007199254740991, 9007199254740991] are returned as decimal strings.

Input parameters:

- `query` (string, required)

Output parameters:

- `result` (string)

## Diagnostics

Captured diagnostic sections: Provenance. The full working is on the page: https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-6-0#diagnostics

## Score history

- 2026-09-20: 46
- 2026-09-19: 46
- 2026-09-18: 46
- 2026-09-17: 45
- 2026-09-16: 45
- 2026-09-15: 44
- 2026-09-14: 44
- 2026-09-13: 43
- 2026-09-12: 43
- 2026-09-11: 42
- 2026-09-10: 39
- 2026-09-09: 39
- 2026-09-08: 39
- 2026-09-07: 39
- 2026-09-06: 39
- 2026-09-05: 39
- 2026-09-04: 39
- 2026-09-03: 39

## Common questions

### What is the ClickHouse MCP server?

ClickHouse is an MCP server listed in the public MCP registry as io.github.ClickHouse/mcp-clickhouse. Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB. This page covers its container image (ghcr.io/clickhouse/mcp-clickhouse:0.6.0).

### Is the ClickHouse MCP server safe to use?

ClickHouse scores 46 out of 100 on VerifyMCP. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.

### What tools does the ClickHouse MCP server expose?

ClickHouse exposes 3 tools: list_databases, list_tables, run_query. Their descriptions and schemas cost roughly 356 tokens of context every time the server is loaded.

### Is the ClickHouse MCP server still maintained?

ClickHouse is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.

### What licence is the ClickHouse MCP server under?

ClickHouse declares the Apache-2.0 licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.

## Links

- Repository: https://github.com/ClickHouse/mcp-clickhouse
- Website: https://clickhouse.com/
- Changelog RSS feed: https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-6-0.xml
- Changelog JSON feed: https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-6-0.json
- HTML version of this page: https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-6-0