ClickHouse MCP Server
A Model Context Protocol (MCP) server for ClickHouse database interactions
context tax
pending
security
82/100
cold start
pending
freshness
Abandoned14mo ago
Our reading of ClickHouse, from the data
ClickHouse is a database MCP server from ahmedrowaihi.
We haven't measured its tool list yet, so its token cost is unknown.
It looks abandoned: the newest commit, release or package publish we found was 14 months ago (2025-09-07). For comparison, 64% of database servers are active or maintained.
With 0 GitHub stars it ranks #676 of 1,397 database servers we index.
It runs locally on your machine over stdio.
Install ClickHouse MCP server
Install in Claude Code
claude mcp add clickhouse-ahmedrowaihi -- npx -y clickhouse-mcp-serverInstall in Cursor
{
"mcpServers": {
"clickhouse-ahmedrowaihi": {
"command": "npx",
"args": [
"-y",
"clickhouse-mcp-server"
]
}
}
}Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).
Install in Claude Desktop
{
"mcpServers": {
"clickhouse-ahmedrowaihi": {
"command": "npx",
"args": [
"-y",
"clickhouse-mcp-server"
]
}
}
}Settings → Developer → Edit Config (claude_desktop_config.json), then restart.
Install in VS Code
{
"servers": {
"clickhouse-ahmedrowaihi": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"clickhouse-mcp-server"
]
}
}
}Add to .vscode/mcp.json in your workspace.
Install in Windsurf
{
"mcpServers": {
"clickhouse-ahmedrowaihi": {
"command": "npx",
"args": [
"-y",
"clickhouse-mcp-server"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json.
Security signals
82/100 — minor findings as of 2026-10-19, from the checks below. This is not a guarantee of safety; review what a server can do before connecting it.
Deductions
- No commits in over 12 months-10
- No license detected-5
- No security policy (SECURITY.md)-3
Checks
- ✓Repository hygiene (archived, activity, license, security policy)
- ○Package metadata (install scripts, provenance) — pending
- ○Tool descriptions (prompt-injection and hidden-text heuristics) — pending
- ○Source scan (secrets, CVEs, risky code) by vectra-guard — pending
Scan it yourself before installing with vectra-guard, the open-source agent security CLI. Scoring rules
Freshness
Abandoned — last maintenance signal 14mo ago. The newest of the signals below sets the band.
Last commit (default branch)
2025-09-07 · 14mo ago · GitHub
Latest release
2025-09-07 · 14mo ago · GitHub · v0.1.8
Package published
no data · npm/PyPI
Registry entry updated
no data · official registry
How it compares in Database
Against the most-starred database servers we index. Token cost is per model turn, measured from each server's live tool list.
| Server | Stars | Tools | Tokens / turn | Freshness | Runs |
|---|---|---|---|---|---|
| ClickHouse (this) | 0 | — | not measured | Abandoned | local |
| Screenpipe | 21,982 | — | not measured | Active | — |
| Genai Toolbox | 16,679 | — | not measured | Active | hosted |
| Convex Backend | 12,716 | — | not measured | Active | — |
| Kubeshark | 12,100 | — | not measured | Active | local |
| Baserow | 6,174 | — | not measured | Active | — |
FAQ
›How do I install the ClickHouse MCP server in Claude Code?
Run: claude mcp add clickhouse-ahmedrowaihi -- npx -y clickhouse-mcp-server. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.
›Does ClickHouse require an API key?
No required environment variables are declared in its published metadata.
›Can I use ClickHouse as a remote (hosted) MCP server?
No hosted endpoint is published; it runs locally over stdio.
›Is ClickHouse in the official MCP registry?
No. It was indexed from npm.
Sources and method
- GitHub repository
- fetched 2026-10-19
- Package registry (npm / PyPI)
- listed
- Security signals, computed by us
- 2026-10-19
- Last checked against all sources
- 2026-10-19
The description, packages and links come from the maintainer's own published metadata. Token cost, security signals, freshness and the reading above are MCPSkillHub's own measurements; see the methodology. Spot an error? Request a correction or claim the listing.
Alternatives to ClickHouse
Other database MCP servers.
ScreenpipeActiveLocal screen and audio capture with timestamped indexing, SQL and embedding storage, semantic search, history analysis and event-triggered actions.
Genai ToolboxActiveOpen source MCP server specializing in easy, fast, and secure tools for Databases.
Convex BackendActiveConvex database integration to introspect tables and functions and run one-off queries.
KubesharkActiveReal-time Kubernetes network traffic visibility and API analysis for HTTP, gRPC, Redis, Kafka, DNS.
BaserowActiveBaserow database integration: search and list tables, and create, read, update and delete rows.
WigoloActiveLocal web search, fetching, crawling, extraction and research, with multi-engine search, local ML reranking, a SQLite cache and JavaScript rendering.