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?
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.301,201 PyPI2Apache 2.0Why 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.2328AGPL 3.0Why 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,141 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 capabilities3899Apache 2.0Why this server?
Provides ClickHouse integration as a source/sink endpoint, supporting bulk inserts and resumable reads for moving data to and from ClickHouse.
Why this server?
Detects and redacts ClickHouse database credentials and connection strings in text.

classifinder-mcpofficial
AlicenseAqualityBmaintenanceEnables AI agents to scan text for leaked secrets and prompt injection markers, and redact them before reaching an LLM.21MITWhy 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.161,854 npm8MITWhy this server?
Allows AI agents to discover and query ClickHouse data through OtterStax's federated SQL server using MCP tools for SQL execution, schema listing, table description, object search, and table statistics.
AlicenseAqualityCmaintenanceEnables AI agents to discover and query data federated across MySQL/MariaDB, PostgreSQL, ClickHouse, S3 and Kafka with SQL, exposing tools to list databases, schemas, tables and connections, describe columns, search objects, inspect table statistics, run EXPLAIN, and execute arbitrary statements. It runs locally over stdio against a PostgreSQL-wire endpoint and returns structured results or SQLSTATE-coded errors.8Apache 2.0Why this server?
Plans to support ClickHouse as an additional analytical database engine.