MCP ClickHouse

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

Connector by dockndevai · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)★ 3

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/dockndevai-mcp-clickhouse

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

About

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

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list, install config and code. Checked Oct 26, 2026.

Tools: 7 read · 0 write · 1 delete · 2 not yet classified
Secrets: 1 (API keys, tokens or passwords)
Install scripts: None found
Runs as: Node.js package

Tools by what they do 10

Read from the source code; the running server may list different tools.

Read 7 · Look things up without changing anything.

cluster_info
describe_table
list_databases
list_tables
running_queries
show_create_table
table_stats

Delete 1 · Delete, drop, revoke or wipe things.

execute

Not yet classified 2 · We could not tell from the name and description.

query
server_metrics

Secrets and settings it asks for

Secrets: values you paste in that let it act as you.

CLICKHOUSE_PASSWORD

Other settings (environment variables or headers).

CLICKHOUSE_MODE
CLICKHOUSE_URL
CLICKHOUSE_USER

Network hosts it talks to 2

github.com · found in code
glama.ai · found in code

Tools (10)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

cluster_infoCluster info
Cluster topology from system.clusters (shards, replicas, hosts).
describe_tableDescribe table
Column names, types, defaults, and comments for a table.
executeExecute a statement
Execute a single SQL statement (INSERT/CREATE/ALTER, or a destructive DROP/TRUNCATE/DELETE). The statement is classified: writes need read-write mode; destructive statements need admin mode AND CLICKHOUSE_ALLOW_DELETE=true. Pass an optional `database` for allowlist/protection checks.
list_databasesList databases
List databases and their engines.
list_tablesList tables
List tables in a database with engine, row count, and size.
queryRun 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.
running_queriesRunning queries
Currently executing queries from system.processes (id, user, elapsed, memory).
server_metricsServer metrics
Non-zero metrics from system.metrics (connections, merges, memory, etc.).
show_create_tableShow CREATE TABLE
Return the full CREATE TABLE statement (schema, engine, settings) for a table.
table_statsTable stats
Part count, row count, on-disk size, and time range from system.parts.

Signals

Stars: 3
Forks: 0
Open issues: 2
Weekly downloads: 43
Last commit: Oct 19, 2026 (9 days ago)
Last release: Sep 29, 2026 (29 days ago)
Last package publish: Sep 29, 2026 (29 days ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name: io.github.dockndevai/mcp-clickhouse
Version: 0.3.0
Auth: API key
Packages: npm @dockndevai/mcp-clickhouse
License: MIT
Repository: github.com/dockndevai/mcp-clickhouse
First seen: Oct 24, 2026
Last checked: Oct 25, 2026
Source: Official MCP Registry github-graphql

More from dockndevai

Cite this page

MCP ClickHouse. Agent Mart. https://agentmart.dev/connectors/dockndevai-mcp-clickhouse (last updated 2026-10-25)