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

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

- Trust score: 34/100 (low)
- Change this week: −4
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-03

## Components

- oci · `ghcr.io/clickhouse/mcp-clickhouse:0.4.1`: 34/100 (this document), [markdown](https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-4-1.md), [page](https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-4-1)
- pypi · `mcp-clickhouse`: 10/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.4.1`
- 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-08-03.

- **Supply Chain Security**: 0/100
  - Malware scan not yet available for this package.
  - CVE data not yet available for this package.
  - Install-script risk not yet assessed.
  - Dependency-health data not yet available.
- **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**: 66/100
  - AI-judged instruction clarity (good).
  - Tool/resource definitions use about 386 tokens (~128/item across 3 items; 3 tools + 0 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 0/100
  - Stability not yet verified: not enough scan history yet (needs a 30-day window).
- **Tool Coverage**: 71/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 0% of tool parameters carry a description.
  - Structured output schemas are declared (100% of tools); any adoption earns full credit.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

**Unverified: 2 categories.** Categories scored 0 because we could not verify them: 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

### Claude

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

### Codex

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

### 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.4.1"
      ],
      "enabled": true
    }
  }
}
```

### Hermes

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

### Other

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

## 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-07-31 (score 34, −4)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-27 (score 38, +27)

- [functional improvement] Tool coverage: unverified → 100
- [functional] First check of Tool coverage: 100
- [functional] First check of Tool coverage: 0
- [functional] First check of Schema quality: fail
- [functional] First check of Schema quality: pass
- [functional] First check of Schema quality: good

### 2026-07-26 (score 11)

First indexed and scored.

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

## MCP tools (3)

### `list_databases` (~15 tokens)

List available ClickHouse databases

Output parameters:

- `result` (string)

### `list_tables` (~242 tokens)

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

Args:
    database: The database to list tables from
    like: Optional LIKE pattern to filter table names
    not_like: Optional NOT LIKE pattern to exclude table names
    page_token: Token for pagination, obtained from a previous call
    page_size: Number of tables to return per page (default: 50)
    include_detailed_columns: 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 large schemas.

Returns:
    A JSON-encoded string of an object containing:
    - tables: List of table information (as dictionaries)
    - next_page_token: Token for the next page, or None if no more pages
    - total_tables: Total number of tables matching the filters

Input parameters:

- `database` (string, required)
- `include_detailed_columns` (boolean)
- `like`
- `not_like`
- `page_size` (integer)
- `page_token`

Output parameters:

- `result` (string)

### `run_query` (~65 tokens)

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).

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-4-1#diagnostics

## Score history

- 2026-08-03: 34
- 2026-08-02: 34
- 2026-08-01: 34
- 2026-07-31: 34
- 2026-07-30: 38
- 2026-07-29: 38
- 2026-07-28: 38
- 2026-07-27: 38
- 2026-07-26: 11

## 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-4-1/changelog.xml
- Changelog JSON feed: https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-4-1/changelog.json
- HTML version of this page: https://verifymcp.io/servers/clickhouse-mcp-clickhouse/ghcr-io-clickhouse-mcp-clickhouse-0-4-1