# io.github.dockndevai/mcp-clickhouse (npm · @dockndevai/mcp-clickhouse)

ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.

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

## Components

- npm · `@dockndevai/mcp-clickhouse`: 94/100 (this document), [markdown](https://verifymcp.io/servers/dockndevai-mcp-clickhouse/dockndevai-mcp-clickhouse.md), [page](https://verifymcp.io/servers/dockndevai-mcp-clickhouse/dockndevai-mcp-clickhouse)

## Channel facts

- Registry: `npm`
- Package: `@dockndevai/mcp-clickhouse`
- Version: `0.2.2`
- 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**: 98/100
  - No malware found by supply-chain analysis.
  - No known CVEs affecting this package version or its production dependencies.
  - No install/post-install scripts declared.
  - 31 of 96 dependencies flagged as unhealthy.
- **Provenance & Transparency**: 100/100
  - Source repository is publicly reachable at the declared URL.
  - Cryptographically verified build provenance (signed, bound to dockndevai/mcp-clickhouse).
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 7 days ago).
  - Publishes a security disclosure policy (SECURITY.md).
- **Schema Quality & AI Usability**: 77/100
  - AI-judged instruction clarity (good).
  - Tool/resource definitions use about 304 tokens (~33/item across 9 items; 9 tools + 0 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 93/100
  - Stability observed for 28 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Tool Safety**: 100/100
  - No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.
  - We read all 9 captured tool definition(s), and no name or description among them implies an irreversible operation.
  - An AI judge read all 9 captured unit(s) of tool text and found none that tries to manipulate the model reading it.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

## Install

### How do I install the io.github.dockndevai/mcp-clickhouse server?

io.github.dockndevai/mcp-clickhouse runs locally as an npm package, launched with npx -y @dockndevai/mcp-clickhouse. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.

### Claude

```bash
claude mcp add dockndevai-mcp-clickhouse -- npx -y @dockndevai/mcp-clickhouse
```

### Cursor

```json
{
  "mcpServers": {
    "dockndevai-mcp-clickhouse": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ]
    }
  }
}
```

### VS Code

```json
{
  "servers": {
    "dockndevai-mcp-clickhouse": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ]
    }
  }
}
```

### Codex

```bash
codex mcp add dockndevai-mcp-clickhouse -- npx -y @dockndevai/mcp-clickhouse
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "dockndevai-mcp-clickhouse": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "@dockndevai/mcp-clickhouse"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add dockndevai-mcp-clickhouse --command npx --arg -y --arg @dockndevai/mcp-clickhouse
```

### Hermes

```yaml
mcp_servers:
  dockndevai-mcp-clickhouse:
    command: "npx"
    args: ["-y", "@dockndevai/mcp-clickhouse"]
```

### Netclaw

```json
{
  "McpServers": {
    "dockndevai-mcp-clickhouse": {
      "Transport": "stdio",
      "Command": "npx",
      "Arguments": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ]
    }
  }
}
```

### Vellum

```bash
assistant mcp add dockndevai-mcp-clickhouse -t stdio -c npx -a -y @dockndevai/mcp-clickhouse
```

### Other

```json
{
  "mcpServers": {
    "dockndevai-mcp-clickhouse": {
      "command": "npx",
      "args": [
        "-y",
        "@dockndevai/mcp-clickhouse"
      ]
    }
  }
}
```

## 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-19 (score 94, +1)

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

### 2026-09-17 (score 93, +1)

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

### 2026-09-15 (score 92, +1)

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

### 2026-09-13 (score 91, +15)

- [security improvement] Malware scan: unverified → pass

### 2026-09-12 (score 76, −14)

- [security regression] Malware scan: pass → unverified
- [security regression] Tool safety: pass → unverified
- [security regression] Stability: 0.63 → unverified
- [functional regression] Capabilities: pass → unverified
- [functional regression] Tool coverage: 100 → unverified
- [functional] First check of Schema quality: unverified
- [functional] Package version: 0.2.1 → 0.2.2

### 2026-09-10 (score 90, +11)

- [security improvement] Known CVEs: unverified → pass
- [functional improvement] Dependency health: unverified → 0.85

### 2026-09-09 (score 79, −10)

- [security regression] Known CVEs: pass → unverified
- [security regression] Stability: 0.53 → unverified
- [security regression] Tool safety: pass → unverified
- [functional regression] Dependency health: 0.85 → unverified
- [functional regression] Capabilities: pass → unverified
- [functional regression] Tool coverage: 100 → unverified
- [functional] First check of Schema quality: unverified
- [functional] Package version: 0.1.2 → 0.2.1
- [functional] Package version: 0.1.2 → 0.2.0
- [functional] Package version: 0.1.2 → 0.1.3

### 2026-09-08 (score 89, +1)

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

## MCP tools (9)

### `list_databases` (~15 tokens)

List databases

List databases and their engines.

### `list_tables` (~31 tokens)

List tables

List tables in a database with engine, row count, and size.

Input parameters:

- `database` (string, required): Database name

### `describe_table` (~39 tokens)

Describe table

Column names, types, defaults, and comments for a table.

Input parameters:

- `database` (string, required): Database name
- `table` (string, required): Table name

### `show_create_table` (~44 tokens)

Show CREATE TABLE

Return the full CREATE TABLE statement (schema, engine, settings) for a table.

Input parameters:

- `database` (string, required): Database name
- `table` (string, required): Table name

### `table_stats` (~44 tokens)

Table stats

Part count, row count, on-disk size, and time range from system.parts.

Input parameters:

- `database` (string, required): Database name
- `table` (string, required): Table name

### `running_queries` (~24 tokens)

Running queries

Currently executing queries from system.processes (id, user, elapsed, memory).

### `server_metrics` (~23 tokens)

Server metrics

Non-zero metrics from system.metrics (connections, merges, memory, etc.).

### `cluster_info` (~22 tokens)

Cluster info

Cluster topology from system.clusters (shards, replicas, hosts).

### `query` (~62 tokens)

Run a read-only query

Run a SELECT/SHOW/DESCRIBE query and return rows. Non-read statements are refused here — use `execute` (read-write mode) for those. Results are capped at CLICKHOUSE_MAX_ROWS.

Input parameters:

- `sql` (string, required): A single read-only SQL statement

## Diagnostics

Captured diagnostic sections: Provenance, Dependencies. The full working is on the page: https://verifymcp.io/servers/dockndevai-mcp-clickhouse/dockndevai-mcp-clickhouse#diagnostics

## Score history

- 2026-09-20: 94
- 2026-09-19: 94
- 2026-09-18: 93
- 2026-09-17: 93
- 2026-09-16: 92
- 2026-09-15: 92
- 2026-09-14: 91
- 2026-09-13: 91
- 2026-09-12: 76
- 2026-09-11: 90
- 2026-09-10: 90
- 2026-09-09: 79
- 2026-09-08: 89
- 2026-09-07: 88
- 2026-09-06: 88
- 2026-09-05: 87
- 2026-09-04: 87
- 2026-09-03: 86
- 2026-09-02: 86
- 2026-09-01: 85
- 2026-08-31: 85
- 2026-08-30: 59
- 2026-08-29: 84
- 2026-08-28: 69
- 2026-08-27: 81
- 2026-08-26: 81
- 2026-08-25: 80
- 2026-08-24: 80
- 2026-08-23: 80

## Common questions

### What is the io.github.dockndevai/mcp-clickhouse server?

io.github.dockndevai/mcp-clickhouse is listed in the public MCP registry as io.github.dockndevai/mcp-clickhouse. ClickHouse query & management for AI agents, SQL-classified read/write/destructive gating. This page covers its npm package (@dockndevai/mcp-clickhouse).

### Is the io.github.dockndevai/mcp-clickhouse server safe to use?

io.github.dockndevai/mcp-clickhouse scores 94 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 20 September 2026. It declares no install or post-install scripts. Its build provenance is signed and verified. 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 io.github.dockndevai/mcp-clickhouse server expose?

io.github.dockndevai/mcp-clickhouse exposes 9 tools: list_databases, list_tables, describe_table, show_create_table, table_stats, and 4 more. Their descriptions and schemas cost roughly 304 tokens of context every time the server is loaded.

### Is the io.github.dockndevai/mcp-clickhouse server still maintained?

io.github.dockndevai/mcp-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 io.github.dockndevai/mcp-clickhouse server under?

io.github.dockndevai/mcp-clickhouse declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.

## Links

- npm package: https://www.npmjs.com/package/@dockndevai/mcp-clickhouse
- Socket report: https://socket.dev/npm/package/@dockndevai/mcp-clickhouse
- Repository: https://github.com/dockndevai/mcp-clickhouse
- Changelog RSS feed: https://verifymcp.io/servers/dockndevai-mcp-clickhouse/dockndevai-mcp-clickhouse.xml
- Changelog JSON feed: https://verifymcp.io/servers/dockndevai-mcp-clickhouse/dockndevai-mcp-clickhouse.json
- HTML version of this page: https://verifymcp.io/servers/dockndevai-mcp-clickhouse/dockndevai-mcp-clickhouse