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?
Provides on-chain SQL queries across 13 blockchains using ClickHouse tables via the blockrun_surf tool.
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 updated191,554475MITWhy 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
AlicenseAqualityBmaintenanceClickHouse database integration with schema inspection and query capabilitiesLast updated3832Apache 2.0Why this server?
Provides governed access to ClickHouse databases, allowing AI agents to search data catalogs, describe table schemas, and execute semantic queries.
AlicenseBqualityDmaintenanceAn MCP server that bridges AI assistants with data warehouses through Cube.js to enable governed, natural language semantic analytics queries. It provides tools for metadata discovery and secure query execution while enforcing governance policies like PII blocking and access limits.Last updated31111MITWhy this server?
Supports executing SQL queries against ClickHouse via the Logflare Management API.
AlicenseAqualityCmaintenanceEnables querying and managing Logflare log sources, endpoints, and executing ad-hoc SQL via MCP.Last updated7MITWhy 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 updated6256MITWhy 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.Last updated8MITWhy this server?
Provides read-only exploratory data analysis for ClickHouse databases, including schema listing, table metadata, column profiling, data sampling, and custom queries.
AlicenseAqualityAmaintenanceA read-only MCP server for exploratory data analysis across PostgreSQL, MySQL, and ClickHouse databases, providing safe, read-only access with comprehensive analysis capabilities.Last updated106MIT