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 querying local and remote ClickHouse databases with full ClickHouse SQL syntax and functions, including federation via remoteSecure().
Why 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 capabilities3863Apache 2.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.201,168393MITWhy this server?
Provides query optimization, pipeline latency analysis, data quality monitoring, and table management tools for ClickHouse databases, enabling automated query performance advice and data quality checks.
AlicenseAqualityDmaintenanceA DataOps-focused MCP server for ClickHouse that provides query optimization advice, pipeline latency analysis, and data quality monitoring, with read-only safety.8MITWhy this server?
Provides read-only tools for exploring ClickHouse databases, including listing tables, running queries (with caching, validation, and row limits), describing table schemas, and building time-windowed aggregations.
AlicenseAqualityCmaintenanceProvides AI agents safe, read-only access to a ClickHouse database, enabling table listing, query execution, schema inspection, and caching.6946MITWhy this server?
Queries a USA-market ClickHouse warehouse with 1.49 billion rows of 1-minute bars across 1,388 symbols for large-scale, cross-sectional quant analysis.
AlicenseAqualityBmaintenanceRead-only MCP server for large-scale cross-sectional quant analysis of US stock market data (1.49 billion rows) using ClickHouse.7MITWhy this server?
Provides tools for interacting with ClickHouse databases, including executing SQL queries, listing databases, and listing tables in a database, all with read-only access to ensure safety.
Apache 2.0Why this server?
Enables exporting the anonymized, prioritized, and stitched historical dataset directly to a ClickHouse data warehouse for high-performance analytics.
AlicenseBqualityAmaintenanceA sovereign, high-speed, local-first Big Data Ingestion, Filtering, and Analytical Pipeline Orchestrator.7MIT