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.
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.202,420473MITWhy 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?
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 capabilities3846Apache 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?
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.247MITWhy this server?
Plans to support ClickHouse as an additional analytical database engine.
Why this server?
Manage ClickHouse database clusters: create, delete, and retrieve details.
AlicenseBqualityDmaintenanceEnables management of Timeweb Cloud resources including servers, databases, Kubernetes clusters, S3 storage, DNS, SSH keys, and floating IPs through natural language.9711MITWhy this server?
Provides tools for executing read-only SELECT and SHOW queries, analyzing query plans, and discovering metadata (databases, tables, columns) on ClickHouse instances.
AlicenseAqualityBmaintenanceA read-only MCP server for ClickHouse that enables metadata discovery, parameterized SELECT queries, SHOW introspection, query analysis, and snapshot mode for large result sets, with profile-based configuration and strict no-DML/DDL enforcement.8MITWhy 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.106MIT