Best ClickHouse MCP Servers
ClickHouse is an open-source, high performance columnar OLAP (online analytical processing) database management system for real-time analytics using SQL.
Why this server?
Detects and redacts ClickHouse database credentials and connection strings in text.
AlicenseAqualityBmaintenanceEnables AI agents to scan text for leaked secrets and prompt injection markers, and redact them before reaching an LLM.21MITWhy this server?
Allows monitoring ClickHouse database connectivity and query execution as a check type.
AlicenseAqualityAmaintenanceUptime monitoring from your AI agent: create and diagnose checks (40 types: HTTP, TCP, DNS, SSL, ICMP, databases, message queues and more), read results and incidents, and manage status pages and maintenance windows. Built into the self-hostable SolidPing server, served over streamable HTTP at /api/v1/mcp.4212AGPL 3.0Why this server?
Allows querying local and remote ClickHouse databases with full ClickHouse SQL syntax and functions, including federation via remoteSecure().
Why this server?
Provides on-chain SQL queries across 13 blockchains using ClickHouse tables via the blockrun_surf tool.

BlockRun MCPofficial
AlicenseAqualityAmaintenanceProvides Claude with real-time access to markets, research, X/Twitter, and crypto data via a unified pay-per-call system with no API keys.191,144 npm391MITWhy this server?
Allows executing SQL queries on a ClickHouse cluster and retrieving information about databases and tables. It provides tools to run SELECT queries, list databases, and list tables in a database.

mcp-clickhouseofficial
AlicenseAqualityAmaintenanceClickHouse database integration with schema inspection and query capabilities3880Apache 2.0Why this server?
Provides exposure radar data for unauthenticated ClickHouse instances, including counts of exposed services and top countries/engines from EchelonGraph's internet-exposure scans.
AlicenseAqualityAmaintenanceEnables any MCP client to look up CVE intelligence — severity summaries, filtered searches, and full per-CVE detail fusing NVD, MITRE-CNA pre-NVD, CISA KEV, EPSS, and GitHub GHSA data — alongside a Shodan-derived internet-exposure footprint showing how many internet-facing services run a version mapping to a given CVE. It is free, keyless, and read-only, and distinguishes verified zeros from unassessed or failed lookups.162,857 npm2MITWhy this server?
Enables ClickHouse as a columnar analytics sink for HKEx filings, using ReplacingMergeTree for idempotent upserts.
AlicenseAqualityAmaintenanceA read-only MCP server so AI agents can query the corpus or the live site.212135 PyPI16MITWhy this server?
Allows Semantic Rails to use ClickHouse as a warehouse target for governed semantic queries, metric discovery, validation, and execution.
AlicenseBqualityBmaintenanceEnables agents to interact with a governed semantic layer for querying and authoring metrics, providing tools for discovery, planning, validation, and execution of analytics queries.27536 PyPI1Apache 2.0Why this server?
Provides architecture-aware visual styling for ClickHouse database components within Excalidraw diagrams.
AlicenseBqualityAmaintenanceAn MCP server that generates beautiful Excalidraw architecture diagrams with perfect auto-layout, stateful editing, and architecture-aware component styling.26427 PyPI158MIT