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 updated3809Apache 2.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
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 updated181,847467MITWhy this server?
Allows creating and managing ClickHouse databases in Coolify.
AlicenseAqualityDmaintenanceA Model Context Protocol server that provides integration with the Coolify API, enabling DevOps teams to manage Coolify deployments, applications, services, and servers through MCP tools.Last updated329342MITWhy this server?
Provides read-only exploratory data analysis for ClickHouse databases, including schema listing, table metadata, column profiling, data sampling, and custom queries.
AlicenseAqualityBmaintenanceA read-only MCP server for exploratory data analysis across PostgreSQL, MySQL, and ClickHouse databases, providing safe, read-only access with comprehensive analysis capabilities.Last updated104MITWhy this server?
Enables secure and structured exploration of ClickHouse databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
AlicenseBqualityDmaintenanceA Model Context Protocol server that enables AI assistants to securely interact with ClickHouse databases, supporting table exploration and SQL query execution through a controlled interface.Last updated18Apache 2.0Why 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?
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 governed access to ClickHouse databases, allowing AI agents to search data catalogs, describe table schemas, and execute semantic queries.
AlicenseBqualityCmaintenanceAn 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 updated3701MIT