ClickHouse MCP Server
MCP ServerFreeOfficial ClickHouse MCP — read-only SQL analytics over ClickHouse and chDB for agents.
- Best for
- overview, 1.1 system architecture, core components
- Type
- MCP Server · Free
- Score
- 56/100
- Best alternative
- AWS MCP Servers
- Agent-compatible
- Yes — MCP protocol
Capabilities4 decomposed
overview
Medium confidenceClickHouse/mcp-clickhouse | DeepWiki Loading... Index your code with Devin DeepWiki DeepWiki ClickHouse/mcp-clickhouse Index your code with Devin Edit Wiki Share Loading... Last indexed: 26 April 2025 ( d42bc1 ) Overview System Architecture Dependencies and Requirements Core Components MCP Server Configuration System ClickHouse Tools Database and Table Listing Query Execution Setup and Usage Installation Configuration Integration with Claude Desktop Development Guide Testing CI/CD Pipeline Code Style and Standards Menu Overview Relevant source files README.md mcp_clickhouse/mcp_server.py pyproject.toml This document provides a comprehensive introduction to the mcp-clickhouse repository, which implements a FastMCP server that provides read-only access to ClickHouse databases. This system enables applications like Claude Desktop to interact with ClickHouse databases in a controlled, secure manner without requiring direct database connection handling in those applications. For detailed setup instructions, see Setup and Usage , and for integration with Claude Desktop specifically, see Integration with Claude Desktop . Key Purpose and Features mcp-clickhouse serves as a bridge between client applications and ClickHouse databases, providing three primary capabilities: Database Listing : Retrieve a list of all available databases in the ClickHouse instance Table Information : Get det
1.1 system architecture
Medium confidenceSystem Architecture | ClickHouse/mcp-clickhouse | DeepWiki Loading... Index your code with Devin DeepWiki DeepWiki ClickHouse/mcp-clickhouse Index your code with Devin Edit Wiki Share Loading... Last indexed: 26 April 2025 ( d42bc1 ) Overview System Architecture Dependencies and Requirements Core Components MCP Server Configuration System ClickHouse Tools Database and Table Listing Query Execution Setup and Usage Installation Configuration Integration with Claude Desktop Development Guide Testing CI/CD Pipeline Code Style and Standards Menu System Architecture Relevant source files mcp_clickhouse/__init__.py mcp_clickhouse/main.py mcp_clickhouse/mcp_server.py This document describes the architectural design and components of the mcp-clickhouse system. It outlines the high-level structure, component relationships, data flow, and execution patterns of the system. For information on dependencies and requirements, see Dependencies and Requirements . Overview The mcp-clickhouse system is designed to provide a secure, read-only interface to ClickHouse databases through a FastMCP server. It offers tools for database exploration and query execution while maintaining strict security controls. Sources: mcp_clickhouse/mcp_server.py 1-229 mcp_clickhouse/__init__.py 1-13 mcp_clickhouse/main.py 1-10 Core Components The system consists of several key components that work together to provid
core components
Medium confidenceCore Components | ClickHouse/mcp-clickhouse | DeepWiki Loading... Index your code with Devin DeepWiki DeepWiki ClickHouse/mcp-clickhouse Index your code with Devin Edit Wiki Share Loading... Last indexed: 26 April 2025 ( d42bc1 ) Overview System Architecture Dependencies and Requirements Core Components MCP Server Configuration System ClickHouse Tools Database and Table Listing Query Execution Setup and Usage Installation Configuration Integration with Claude Desktop Development Guide Testing CI/CD Pipeline Code Style and Standards Menu Core Components Relevant source files mcp_clickhouse/mcp_env.py mcp_clickhouse/mcp_server.py This document provides detailed information about the main components that make up the mcp-clickhouse system. It covers the architectural structure, functional elements, and how they interact to provide a simplified interface for ClickHouse database operations. For information about how to set up and use these components, see Setup and Usage . Component Overview The mcp-clickhouse system consists of several core components that work together to provide secure, read-only access to ClickHouse databases. Sources: mcp_clickhouse/mcp_server.py 34-151 mcp_clickhouse/mcp_env.py 12-137 Key Components and Their Functions The mcp-clickhouse system contains the following key components: Component Description Implementation FastMCP Server The server that exposes t
ClickHouse MCP Server
Medium confidenceClickHouse/mcp-clickhouse | DeepWiki Loading... Index your code with Devin DeepWiki DeepWiki ClickHouse/mcp-clickhouse Index your code with Devin Edit Wiki Share Loading... Last indexed: 26 April 2025 ( d42bc1 ) Overview System Architecture Dependencies and Requirements Core Components MCP Server Configuration System ClickHouse Tools Database and Table Listing Query Execution Setup and Usage Installation Configuration Integration with Claude Desktop Development Guide Testing CI/CD Pipeline Code Style and Standards Menu Overview Relevant source files README.md mcp_clickhouse/mcp_server.py pyproject.toml This document provides a comprehensive introduction to the mcp-clickhouse repository, which implements a FastMCP server that provides read-only access to ClickHouse databases. This system enables applications like Claude Desktop to interact with ClickHouse databases in a controlled, secure manner without requiring direct database connection handling in those applications. For detailed setup instructions, see Setup and Usage , and for integration with Claude Desktop specifically, see Integration
Capabilities are decomposed by AI analysis. Each maps to specific user intents and improves with match feedback.
Related Artifactssharing capabilities
Artifacts that share capabilities with ClickHouse MCP Server, ranked by overlap. Discovered automatically through the match graph.
Daytona
Secure elastic sandboxes for AI-generated code — sub-90ms spin-up, OCI images, Python/TS SDKs.
Chroma MCP Server
Official Chroma MCP — vector + full-text retrieval and collection management as agent tools.
Claude Agent SDK
Anthropic's official agent SDK — the Claude Code harness (tools, MCP, subagents, permissions) as a library.
Pipecat
Open-source realtime voice-agent framework — composable STT/LLM/TTS pipelines, every provider, WebRTC.
Gemini CLI
Google's open-source terminal coding agent — Gemini + 1M context + Search grounding in the shell.
Browser Use
Most-starred open-source browser-agent library — agents drive real browsers via Playwright + any LLM.
UnfragileRank
UnfragileRank is computed from adoption signals, documentation quality, ecosystem connectivity, match graph feedback, and freshness. No artifact can pay for a higher rank.
Repository Details
About
Official ClickHouse MCP server letting agents run SQL analytics against ClickHouse clusters and embedded chDB. Tools include run_select_query (read-only guarded), list_databases, and list_tables. Connects to ClickHouse Cloud or self-hosted clusters over HTTPS with credential isolation, and can query local files via chDB without a server. Best for agents doing analytics, log exploration, and large-scale aggregations where Postgres-class databases time out. Maintained by ClickHouse Inc. Limitation: read-only by design — no inserts or DDL through the MCP surface.
Categories
Alternatives to ClickHouse MCP Server
AWS Labs' official MCP suite — docs, CDK, Bedrock KB, cost, Lambda and more as agent tools.
Compare →Zapier's hosted MCP — 8,000+ app integrations exposed as allowlisted agent tools.
Compare →Official Hugging Face MCP — search models/datasets/Spaces/papers and call Spaces as tools.
Compare →Atlassian's official hosted MCP — Jira + Confluence with OAuth, permission-bounded agent access.
Compare →Are you the builder of ClickHouse MCP Server?
Claim this artifact to get a verified badge, access match analytics, see which intents users search for, and manage your listing.
Get the weekly brief
New tools, rising stars, and what's actually worth your time. No spam.
Data Sources
Looking for something else?
Search →