database
ClickHouse MCP servers and skills
There are 12 ways to connect ClickHouse to Claude, ChatGPT, Cursor and other AI assistants: 9 MCP servers and 3 skills. The most used is ClickHouse (889 GitHub stars).
Best ClickHouse MCP servers, compared →Most used
Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
OpenTabs plugin for ClickHouse Cloud
ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.
Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.
A Model Context Protocol (MCP) server for ClickHouse database interactions
Read-only Apache NiFi, ClickHouse and Kafka access with OIDC, audit and secret masking
MCP servers (9)
- 1ClickHouse ClickHouse · DatabasesOfficial ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.87
- 2Opentabs Plugin Clickhouse opentabs-dev · DatabasesOpenTabs plugin for ClickHouse Cloud84
- 3mcp-clickhouse dockndevai · DatabasesClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.74
- 4ClickHouse alyiox · DatabasesRead-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.39
- 5Clickhouse MCP Server ahmedrowaihi · DatabasesA Model Context Protocol (MCP) server for ClickHouse database interactions36
- 6nifi-clickhouse-kafka-mcp arogan178 · DatabasesRead-only Apache NiFi, ClickHouse and Kafka access with OIDC, audit and secret masking30
- 7Clickhouse MCP dmkozloff · DatabasesClickHouse Model Context Protocol server27
- 8clickhouse-dataops-mcp Aguantar · DatabasesDataOps ClickHouse MCP server with query optimization and pipeline monitoring21
- 9mcp-clickhouse infoinlet-marketplace · DatabasesRead-only ClickHouse for AI agents — analytics queries, table inspection, sizes, health.12
Skills (3)
- 1clickhouse-analytics arvnfly · DatabasesClickHouse columnar database modeling, MergeTree engine family, partitioning keys, and OLAP query tuning.26
- 2clickhouse PeiKeSmart · DatabasesA high-performance database interface anchored on near-pure black canvas with electric yellow as the brand voltage. White typography in confident sans, yellow CTAs, and yellow-text stat numbers carry ...26
- 3pdf-clickhouse-analytics-configuration qyb156 · DatabasesPDF ClickHouse Analytics Configuration for PDF toolkit.23
Questions
Is there an official ClickHouse MCP server?
Check the publisher on each listing: servers published by ClickHouse itself are the official ones. The most used ClickHouse server here is ClickHouse by ClickHouse.
How do I connect ClickHouse to Claude?
Pick a server below, open its page and copy the install command for Claude Code, or the config block for Claude Desktop. Most ClickHouse servers need an API key or token from your ClickHouse account.