24 tools that work with ClickHouse: 8 MCP servers, 15 Agent Skills and 1 Claude Code plugin. 0 of the remote servers answered our live check, 0 worked without an API key, and 1 come from an official or verified publisher. Ranked by GitHub stars plus official, live and free-to-try signals.
Most common uses: SQL databases (20), Warehouses & analytics (BigQuery, Snowflake...) (2), Agent memory & context (1), Monitoring, logs & incidents (1).
| Tool | Stars | Last update | License | |
|---|---|---|---|---|
| clickhouse-best-practices 28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact PluginAnthropic marketplace | 565 | Apache-2.0 | ||
| ClickHouse Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB. MCP serverGitHub-verified authorLocal · PyPI | 904 | Apache-2.0 | ||
| postiz Postiz is a tool to schedule social media and chat posts to 28+ channels X, LinkedIn, LinkedIn Page, Reddit, Instagram, Facebook Page, Threads, YouTub SkillInstall · skills CLI | 568 | — | ||
| chdb-datastore Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas. SkillInstall · skills CLI | 565 | Apache-2.0 | ||
| chdb-sql Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MyS SkillInstall · skills CLI | 565 | Apache-2.0 | ||
| clickhouse-architecture-advisor MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specif SkillInstall · skills CLI | 565 | Apache-2.0 | ||
| clickhouse-best-practices MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Alway SkillInstall · skills CLI | 565 | Apache-2.0 | ||
| clickhouse-js-node-coding Write idiomatic application code with the ClickHouse Node.js client (`@clickhouse/client`). Use this skill whenever a user is *building* against the N SkillInstall · skills CLI | 565 | Apache-2.0 | ||
| clickhouse-js-node-rowbinary Generate TypeScript/JavaScript code that reads/decodes AND writes/encodes ClickHouse RowBinary streams for the ClickHouse HTTP server. Use this skill SkillInstall · skills CLI | 565 | Apache-2.0 | ||
| clickhouse-js-node-troubleshooting Troubleshoot and resolve common issues with the ClickHouse Node.js client (@clickhouse/client). Use this skill whenever a user reports errors, unexpec SkillInstall · skills CLI | 565 | Apache-2.0 | ||
| infra-clickhouse Sets up and manages ClickHouse using the clickhousectl CLI — installs and runs a local ClickHouse server for development, and creates managed ClickHou SkillInstall · skills CLI | 565 | Apache-2.0 | ||
| us-gov-shutdown-tracker Track and analyze US government shutdown liquidity impacts by monitoring TGA (Treasury General Account), bank reserves, EFFR, and SOFR data from FRED SkillInstall · skills CLI | 329 | MIT | ||
| clickhouse-system-queries Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries. Use when the user me SkillInstall · skills CLI | 328 | — | ||
| diagnose-clickhouse-clusters Diagnose ClickHouse cluster health and provide concrete remediation. SkillInstall · skills CLI | 328 | — | ||
| diagnose-clickhouse-errors Diagnose ClickHouse runtime query failures when the user wants database-level cause and fix guidance from an error or numeric error code, not source-c SkillInstall · skills CLI | 328 | — | ||
| optimize-clickhouse-sql Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads. SkillInstall · skills CLI | 328 | — | ||
| sql-expert Expert system for generating, validating, and optimizing ClickHouse SQL. Use this when the user needs data, queries, or analysis. SkillInstall · skills CLI | 328 | — | ||
| hypequery ClickHouse Governed ClickHouse analytics for agents: named datasets and metrics as tools, never raw SQL. MCP serverGitHub-verified authorLocal · npm | 105 | — | ||
| ClickHouse Loom Shared long-term memory, document search and a code index for AI agents, self-hosted on ClickHouse. MCP serverGitHub-verified authorRemoteDown | 9 | Apache-2.0 | ||
| LightShip Governed access to production AI-agent traces in an existing ClickHouse store. MCP serverGitHub-verified authorRemoteDown | 4 | Apache-2.0 | ||
| io.github.dockndevai/mcp-clickhouse ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating. MCP serverGitHub-verified authorLocal · npm | 3 | MIT | ||
| ClickHouse Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis. MCP serverGitHub-verified authorLocal · PyPI | 1 | MIT | ||
| io.github.Aguantar/clickhouse-dataops-mcp DataOps ClickHouse MCP server with query optimization and pipeline monitoring MCP serverGitHub-verified authorLocal · PyPI | 0 | MIT | ||
| io.github.infoinlet-marketplace/mcp-clickhouse Read-only ClickHouse for AI agents — analytics queries, table inspection, sizes, health. MCP serverGitHub-verified authorLocal · npm | — | — |