UnknownClickHouse MCP Server
MCP server for ClickHouse — query and manage ClickHouse databases through AI.
Quick Answer
- 1. ClickHouse MCP Server gives AI agents databases capabilities with 28,000 GitHub stars and a quality score of 79/99.
- 2. Install: Run
npx -y @modelcontextprotocol/server-clickhouseor add the config to your MCP client. - 3. Runtime: npm — requires an API key.
- 4. Health: Unknown status — last checked Invalid Date.
Overview
Category: Databases
Runtime: npm
Install: npx -y @modelcontextprotocol/server-clickhouse
Auth: API key required
Source: official
Stars: 28,000
Setup time: ~2 min (API key needed)
What You Can Build
With the ClickHouse MCP Server MCP server, your AI assistant can:
- Access databases functionality through natural language
- Securely use your API credentials for authenticated operations
- Combine with other MCP servers for cross-tool automation workflows
- Run with npm for reliable, consistent deployments
Health Status
UnknownOne-Click Install
Copy the snippet for your MCP client and paste it in.
Claude Desktop
Add to claude_desktop_config.json
{
"mcpServers": {
"clickhouse-mcp-server": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-clickhouse"
],
"env": {
"API_KEY": "your-api-key-here"
}
}
}
}Cursor
Settings → MCP Servers → Add
{
"mcpServers": {
"clickhouse-mcp-server": {
"command": "npx -y @modelcontextprotocol/server-clickhouse"
}
}
}Saves as .cursor/mcp.json in the download. Move it to your project root.
VS Code
Use with MCP extension
{
"mcpServers": {
"clickhouse-mcp-server": {
"command": "npx -y @modelcontextprotocol/server-clickhouse"
}
}
}SDK & Code Integration Examples
Connect to ClickHouse MCP Server programmatically using TypeScript or Python MCP SDKs.
import { Client } from "@modelcontextprotocol/sdk/client/index.js";
import { StdioClientTransport } from "@modelcontextprotocol/sdk/client/stdio.js";
// Initialize ClickHouse MCP Server MCP client transport
const transport = new StdioClientTransport({
command: "npx",
args: ["-y","@modelcontextprotocol/server-clickhouse"],
env: { API_KEY: process.env.API_KEY || "your-api-key-here" }
});
const client = new Client(
{ name: "mcp-app-client", version: "1.0.0" },
{ capabilities: { tools: {} } }
);
async function connectAndRun() {
await client.connect(transport);
const tools = await client.listTools();
console.log("Connected to ClickHouse MCP Server. Available tools:", tools);
}
connectAndRun().catch(console.error);MCP Server Configuration
Add this to your claude_desktop_config.json
{
"mcpServers": {
"clickhouse-mcp-server": {
"command": "npx",
"args": ["-y","@modelcontextprotocol/server-clickhouse"],
"env": {
"API_KEY": "your-api-key-here"
}
}
}
}Topics
Error Resolution & Troubleshooting Matrix
Common JSON-RPC protocol error codes and environment troubleshooting for ClickHouse MCP Server.
-32600 (Invalid Request)Cause: Malformed JSON-RPC payload sent to server
Resolution: Verify MCP client payload adheres to JSON-RPC 2.0 specs.
-32601 (Method Not Found)Cause: Requested tool or resource method does not exist
Resolution: Call list_tools() to inspect supported tool names.
-32602 (Invalid Params)Cause: Missing or invalid tool arguments
Resolution: Check argument schema types against tool definition.
-32603 (Internal Error)Cause: Unhandled execution exception inside server process
Resolution: Inspect process stderr logs or check API key credentials.
AUTH_KEY_MISSINGCause: Required environment variable not set in MCP config
Resolution: Define required API key under 'env' object in claude_desktop_config.json.
STDIO_PIPE_CLOSEDCause: Server process crashed on startup
Resolution: Run install command manually in terminal to inspect error output.
Quality Score
Automated quality ranking of maintaining source repository.
Own this server?
Claim your listing to update description, links, and category — and get a verified badge.
Claim this listing →Similar MCP Servers
Other servers in the Databases category.
PostgreSQL MCP Server
MCP server for PostgreSQL databases — query tables, inspect schemas, run migrations via AI.
SQLite MCP Server
MCP server for SQLite databases — query, analyze, and manage SQLite databases through AI.
Supabase MCP Server
MCP server for Supabase — manage databases, auth, storage, and edge functions.
Redis MCP Server
MCP server for Redis — manage caches, queues, and key-value stores through AI.