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 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.
AlicenseAqualityBmaintenanceClickHouse database integration with schema inspection and query capabilitiesLast updated3833Apache 2.0Why this server?
Plans to support ClickHouse as an additional analytical database engine.
Why this server?
Provides on-chain SQL queries across 13 blockchains using ClickHouse tables via the blockrun_surf tool.

BlockRun MCPofficial
AlicenseAqualityBmaintenanceProvides Claude with real-time access to markets, research, X/Twitter, and crypto data via a unified pay-per-call system with no API keys.Last updated201,059478MITWhy 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.Last updated147MITWhy this server?
Allows querying local and remote ClickHouse databases with full ClickHouse SQL syntax and functions, including federation via remoteSecure().
Why this server?
Execute SQL queries on ClickHouse clusters, list databases and tables with enhanced filtering capabilities using LIKE/NOT LIKE patterns.
AlicenseAqualityDmaintenanceAn MCP server for ClickHouse with enhanced filtering for database and table discovery, supporting LIKE/NOT LIKE patterns and both ClickHouse and chDB tools.Last updated3Apache 2.0Why 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.Last updated7MITWhy 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.Last updated6956MITWhy this server?
Provides AI-driven analysis of ClickHouse databases via natural language queries, with structured outputs and per-call access restrictions.
AlicenseAqualityAmaintenanceEnables querying ClickHouse databases using natural language with AI models, supporting multiple providers and access restrictions via per-call allow-lists.Last updated32MIT