clickhouse-best-practices
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
Plugin bundle · by ClickHouse
About
clickhouse-best-practices is a plugin bundle for AI coding tools published by ClickHouse. Marketplaces we read that list it: 3 (Claude Code: claude-plugins-official, Community GitHub marketplaces, Claude Code: claude-plugins-community). We first saw it on 2026-10-11 and have recorded no change since. As of our marketplace pass on 2026-10-12.
What it asks for
- Installs as a plugin bundle
None of the marketplaces we read publishes its tools or the settings it asks for.
What it declares, asks for and runs, in full
Only install plugins from developers you trust. We list what marketplaces publish and do not test plugins.
Works with
- Claude Code
From the marketplaces that list it and the MCP transport it declares, as each client documents them. We do not test plugins.
Connect
Commands and configs built only from what its marketplaces declare. We do not run them for you and do not test plugins.
As a Claude Code plugin
Built from what Claude Code: claude-plugins-official declares.
/plugin install clickhouse-best-practices@claude-plugins-officialClaude Code adds this marketplace by itself, so one command is enough.
Where it is published
| Marketplace | Status | Version | Figures | Verified | First seen |
|---|---|---|---|---|---|
| Claude Code: claude-plugins-official (Open the source on GitHub) | Listed | 0.3.0 | Forks (GitHub): 39 Stars (GitHub): 545 |
Not marked | |
| Claude Code: claude-plugins-community (Open the source on GitHub) | Listed | 0.3.0 | No figure published | Not marked |
Each figure is the marketplace's own and is never added up across marketplaces. A marketplace that publishes no figure shows none: no number is not zero.
Also listed in one community marketplace
| Marketplace | Repository | Stars (GitHub) |
|---|---|---|
| clickhouse-agent-skills | clickhouse/agent-skills | 545 |
What the bundle contains
As published on Claude Code: claude-plugins-official.
Skills: 8
chdb-datastorechdb-sqlclickhouse-architecture-advisorclickhouse-best-practicesclickhouse-js-node-troubleshootingclickstack-otel-collectorinfra-clickhouseinfra-postgres
What changed
Nothing has moved on this plugin since we started watching it.
Similar plugins
Products whose own names, descriptions, tools and skills are closest in meaning to this one, on every marketplace we read. Closeness is ranked within this list only.
-
clickhouse-architecture-advisor
Workload-aware architecture decision skill for ClickHouse — ingestion strategies, partitioning, enrichment, upsert patterns, and pre-aggregation with explicit…
-
Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant…
-
Local and cloud workflows for running ClickHouse with clickhousectl — local development (install ClickHouse, start a server, create schemas, seed data) and ClickHouse Cloud…
-
mcp-clickhouse io.github.infoinlet-marketplace/mcp-clickhouse
Read-only ClickHouse for AI agents — analytics queries, table inspection, sizes, health.
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
mcp-clickhouse io.github.dockndevai/mcp-clickhouse
ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.
-
clickhouse-dataops-mcp io.github.Aguantar/clickhouse-dataops-mcp
DataOps ClickHouse MCP server with query optimization and pipeline monitoring
-
Enable AI agents to manage, monitor, and query CockroachDB using natural language. Perform complex database operations, cluster management, and query execution seamlessly through…
-
Database administration, SQL optimization, and data management tools for PostgreSQL, SQL Server, and general database development best practices.
-
PostgreSQL performance Tuner MCP Server
provides AI-powered PostgreSQL performance tuning capabilities.
Similar plugins by marketplace
The same question asked of one marketplace at a time: is there an analog of this plugin there?
Has a listing on Claude Code: claude-plugins-community (5)
-
Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Database management tools for Claude Code. Query databases, explore schemas, analyze data quality, and get optimization recommendations. Supports PostgreSQL, MySQL/MariaDB…
-
Collection of official CrateDB agent skills
-
Create, connect, and interact with an AlloyDB Omni database and data.
Has a listing on Claude Code: claude-plugins-official (5)
-
Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Delegates dbt and warehouse work to altimate-code, a specialized CLI agent with 100+ purpose-built data tools (SQL analysis, column-level lineage, dbt build/test/run, warehouse…
-
Create, connect, and interact with an AlloyDB Omni database and data.
-
Expert assistant for Azure Cosmos DB — data modeling, query optimization, performance tuning, and best practices.
Has a listing on Claude: knowledge-work-plugins (5)
-
Connect Claude to your ClickHouse Cloud databases. Browse organizations, services, databases, and table schemas. Run read-only SQL queries against your data and get instant…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
An authenticated hosted MCP server that accesses your PlanetScale organizations, databases, branches, schema, and Insights data. Query against your data, surface slow queries, and…
-
Official SigNoz plugin for MCP setup, docs, queries, dashboards, and alerts
-
informatica-for-claude-platform
Governed catalog discovery for Informatica Intelligent Data Management Cloud (CDGC): find tables, columns, files, glossary terms and policies across the enterprise catalog, check…
Has a listing on Codex: openai-curated (openai/plugins) (5)
-
Manage Supabase projects directly through ChatGPT. Execute SQL queries on PostgreSQL databases, design and modify table schemas, deploy serverless edge functions, and configure…
-
Available for US1 customers only. Analyze, investigate, and act on your Datadog telemetry directly from ChatGPT using natural language. Ask questions about your production…
-
Answer product and business questions with data
-
PostHog gives your AI agent direct access to your product analytics, feature flags, experiments, error tracking, surveys, logs, and LLM analytics. Ask questions about your data…
-
Bring operational data and context into the flow of your ChatGPT conversations. You can ask questions, create and update records, and analyze your data—all through conversation…
Has a listing on Community GitHub marketplaces (5)
-
clickhouse-architecture-advisor
Workload-aware architecture decision skill for ClickHouse — ingestion strategies, partitioning, enrichment, upsert patterns, and pre-aggregation with explicit…
-
Local and cloud workflows for running ClickHouse with clickhousectl — local development (install ClickHouse, start a server, create schemas, seed data) and ClickHouse Cloud…
-
Connect Claude Code directly to your CockroachDB clusters for hands-on database work — explore schemas, write optimized SQL, debug queries, and manage distributed database…
-
Embedded ClickHouse SQL engine for Python via chDB — run analytical SQL on parquet/csv/json files, URLs, S3, and remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud…
-
Local and cloud workflows for running Postgres with clickhousectl — local Docker-backed Postgres for development (start, psql client, .env wiring, lifecycle) and managed…
Has a listing on Copilot CLI: github/awesome-copilot (5)
-
Database administration, SQL optimization, and data management tools for PostgreSQL, SQL Server, and general database development best practices.
-
Connect GitHub Copilot to your CockroachDB clusters: run and explore SQL through MCP, with DBA/Developer/Operator agents, CockroachDB best-practice skills, and safety hooks that…
-
Expert PostgreSQL guidance and live database tools for Postgres anywhere, including local, self-hosted, containers, on-premises, AWS, Google Cloud, Azure Database for PostgreSQL…
-
Use Datadog directly in Copilot / VS Code through a preconfigured Datadog MCP server. Query logs, metrics, traces, dashboards, and more through natural conversation.
-
Build and manage Microsoft Dataverse solutions using natural language. Includes table/column creation, solution lifecycle, data operations, and MCP server configuration.
Has a listing on Copilot CLI: github/copilot-plugins (5)
-
powerbi-authoring
Developer skills for authoring Microsoft Power BI solutions.
-
Toolkit for building Microsoft 365 Copilot declarative agents — scaffolding, JSON manifest development, and capability configuration.
-
workiq
Query Microsoft 365 data with natural language — emails, meetings, documents, Teams messages, and more.
-
Complete bundle: all Microsoft Skills for Fabric for developers and consumers.
-
Advanced Security plugin for GitHub Copilot.
Has a listing on Cursor: cursor/plugins (5)
-
Explore datasets and tables and run SQL queries.
-
Work with PostHog from chat: query product analytics and run SQL, manage feature flags and experiments, triage error tracking issues, and review session replays, surveys, and…
-
Inspect and manage feature gates, experiments, dynamic configs, and metrics.
-
Search docs, read pages, and update tables.
-
Fan large tasks out across parallel cloud agents with planners, workers, verifiers, and structured handoffs.
Has a listing on Docker MCP Catalog (5)
-
Enable AI agents to manage, monitor, and query CockroachDB using natural language. Perform complex database operations, cluster management, and query execution seamlessly through…
-
mongodb-mcp-server io.github.mongodb-js/mongodb-mcp-server
MongoDB Model Context Protocol Server
-
schemacrawler-ai io.github.schemacrawler/schemacrawler-ai
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
-
Database interaction and business intelligence capabilities.
-
mcp-server-couchbase io.github.Couchbase-Ecosystem/mcp-server-couchbase
Couchbase Model Context Protocol Server to interact with Couchbase clusters
Has a listing on Official MCP Registry (5)
-
mcp-clickhouse io.github.infoinlet-marketplace/mcp-clickhouse
Read-only ClickHouse for AI agents — analytics queries, table inspection, sizes, health.
-
mcp-clickhouse io.github.dockndevai/mcp-clickhouse
ClickHouse query & management for AI agents — SQL-classified read/write/destructive gating.
-
clickhouse-dataops-mcp io.github.Aguantar/clickhouse-dataops-mcp
DataOps ClickHouse MCP server with query optimization and pipeline monitoring
-
PostgreSQL performance Tuner MCP Server
provides AI-powered PostgreSQL performance tuning capabilities.
-
postgres-scout-mcp io.github.bluwork/postgres-scout-mcp
Scout your PostgreSQL databases with AI - safety features, monitoring, and data quality
Found by meaning, not by shared code or a shared repository: similar plugins stay separate products, and this is not a review or a recommendation.
Is this your plugin?
Add it to your projects and prove you maintain it with a file in its repository, a file on your domain or a DNS record. You get alerts when a marketplace lists it, drops it, changes its verified mark or what it asks for, and its remote endpoint goes on monitoring as a web service.
Data comes from the public marketplace file https://github.com/anthropics/claude-plugins-official/blob/HEAD/.claude-plugin/marketplace.json. Data comes from public marketplace files in GitHub repositories of their authors. Data comes from the public marketplace file https://github.com/anthropics/claude-plugins-community/blob/HEAD/.claude-plugin/marketplace.json. Figures come from our own regular passes over the marketplaces, last read on . We publish no contact details for plugin publishers.