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?
Supports ClickHouse query analysis through the analyze-pipe tool, which provides optimization suggestions for query performance, indexes, sorting keys, and partition keys.
AsecurityAlicense-qualityAn MCP server to interact with a Tinybird Workspace from any MCP client.Last updated 7 months ago77Apache 2.0Why 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
AsecurityAlicense-qualityClickHouse database integration with schema inspection and query capabilitiesLast updated 10 days ago3745Apache 2.0Why this server?
Provides architecture-aware visual styling for ClickHouse database components within Excalidraw diagrams.
AsecurityAlicense-qualityAn MCP server that generates beautiful Excalidraw architecture diagrams with perfect auto-layout, stateful editing, and architecture-aware component styling.Last updated a month ago1488MITWhy this server?
Provides access to Aiven for ClickHouse services, allowing interaction with analytical databases hosted on the Aiven platform.

Aiven MCP Serverofficial
AsecurityAlicense-qualityA Model Context Protocol server that provides access to Aiven services (PostgreSQL, Kafka, ClickHouse, Valkey, OpenSearch), enabling LLMs to build full stack solutions by interacting with these services.Last updated a day ago314Apache 2.0Why this server?
Integrates with ClickHouse to provide security scan analytics, visualization, and posture scoring for AI infrastructure.
AsecurityAlicense-qualityAI supply chain security scanner for MCP servers and AI agents. 18 tools for CVE scanning, blast radius mapping, CIS benchmarks, SBOM generation, and compliance enforcement across OWASP LLM Top 10, MITRE ATLAS, NIST AI RMF, and EU AI Act.Last updated 2 hours ago2010Apache 2.0Why this server?
Provides tools for connecting to a ClickHouse database and executing SQL queries, with support for multiple queries and JSON-formatted results.
AsecurityAlicense-qualityAn MCP server implementation that enables Claude AI to interact with Clickhouse databases. Features include secure database connections, query execution, read-only mode support, and multi-query capabilities.Last updated a year ago22MITWhy this server?
Enables performing analytical queries against ClickHouse databases via defined metrics and semantic models.

bonnardofficial
-securityAlicense-qualityOpen-source agentic schema layer. Define metrics once in YAML, query governed data from any warehouse (Snowflake, BigQuery, Databricks, PostgreSQL, DuckDB) via MCP.Last updated a month ago22Apache 2.0Why 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.
AsecurityAlicense-qualitymcp-clickhouse-long-runningLast updated 10 months ago3Apache 2.0Why 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.
AsecurityAlicense-qualityA 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 updated a year ago18Apache 2.0