mcp-clickhouse
CommunityMCP server by dockndevai · updated · ★ 3 · 44 downloads a week
ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating. mcp-clickhouse is a community project by dockndevai, not verified by a company domain.
Last commit 3 days ago
MIT: permissive, fine for commercial use
Clear description, published package or server URL, original repository
No risky patterns in the files we checked
What you need
| Setting | Needed | What it is |
|---|---|---|
CLICKHOUSE_URLEnvironment variable | Optional | ClickHouse HTTP endpoint. |
CLICKHOUSE_USEREnvironment variable | Optional | ClickHouse user (prefer a read-only user). |
CLICKHOUSE_PASSWORDEnvironment variable, secret | Optional | ClickHouse password. |
CLICKHOUSE_MODEEnvironment variable | Optional | Access mode: read-only | read-write | admin. |
From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.
Install mcp-clickhouse
Built from the published package, never by AIclaude mcp add mcp-clickhouse -- npx -y @dockndevai/mcp-clickhouseRun in your terminal. Add --scope user to use it in every project.
{
"mcpServers": {
"mcp-clickhouse": {
"command": "npx",
"args": [
"-y",
"@dockndevai/mcp-clickhouse"
]
}
}
}Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.
{
"mcpServers": {
"mcp-clickhouse": {
"command": "npx",
"args": [
"-y",
"@dockndevai/mcp-clickhouse"
]
}
}
}Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).
{
"servers": {
"mcp-clickhouse": {
"command": "npx",
"args": [
"-y",
"@dockndevai/mcp-clickhouse"
]
}
}
}Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".
codex mcp add mcp-clickhouse -- npx -y @dockndevai/mcp-clickhouse{
"mcpServers": {
"mcp-clickhouse": {
"command": "npx",
"args": [
"-y",
"@dockndevai/mcp-clickhouse"
]
}
}
}Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).
gemini mcp add mcp-clickhouse npx -y @dockndevai/mcp-clickhouseGemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.
MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the mcp-clickhouse block.
Security check
ANo download-and-run commands, hidden instructions or signs of sending keys out were found.
Checked automatically: README.md, package.json. This looks for known risky patterns and is not a full audit. How grades work
Alternatives to mcp-clickhouse
All alternatives →MCP server for interacting with the Supabase platform
Built-in MCP server for ArcadeDB multi-model database (graph, document, vector, time-series)
MCP Toolbox for Databases enables your agent to connect to your database.
MCP Toolbox for Databases enables your agent to connect to your database.
Real-time Kubernetes network traffic visibility and API analysis for HTTP, gRPC, Redis, Kafka, DNS.
Self-learning vector database for Node.js — hybrid search, Graph RAG, FlashAttention-3, HNSW, 50+ attention mechanisms
mcp-clickhouse: common questions
How do I install mcp-clickhouse?
In Claude Code run claude mcp add mcp-clickhouse -- npx -y @dockndevai/mcp-clickhouse. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.
Is mcp-clickhouse the official server?
mcp-clickhouse is a community project by dockndevai, not verified by a company domain.
Is mcp-clickhouse free?
The code is published under the MIT licence. The service it connects to may have its own pricing.
Is mcp-clickhouse safe to use?
It scores 74 of 100. Grades: maintenance A, licence A, quality C. Security check: grade A, no risky patterns found in the files checked. Review the code before you install. How grades work.
What are alternatives to mcp-clickhouse?
Similar MCP servers: Supabase, ArcadeDB MCP Server, MCP Toolbox for Databases, MCP Toolbox for Databases.
Does mcp-clickhouse work with ChatGPT?
Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.
