clickhouse-best-practices
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
Install
If the official marketplace isn’t added yet, run
- Category
- Database
- Author
- ClickHouse Inc
- GitHub
- ClickHouse/agent-skills
- Website
- clickhouse.com
Good for
- Design ClickHouse table schemas using rules on primary keys and data types
- Optimize JOINs and query performance
- Plan data ingestion, including insert batching and async inserts
- Check partitioning strategy, skipping indices and materialized views
Getting started
- Run /plugin install clickhouse-best-practices@claude-plugins-official
- Ask Claude to create tables, write queries or design pipelines as usual; the skill activates automatically
- Read SKILL.md for an overview of the 28 rules
Before you install
Works with open-source ClickHouse and ClickHouse Cloud.
Summarized by AI from the project docs; check the official docs before relying on it.
Similar tools
- aivenOfficial plugin · Database
Easily deploy managed PostgreSQL (pg), Kafka, OpenSearch, Clickhouse and other databases, streaming and apps. Free tier available, up and running in minutes.
- alloydbOfficial plugin · Database
Create, connect, and interact with an AlloyDB for PostgreSQL database and data.
- alloydb-omniOfficial plugin · Database
Create, connect, and interact with an AlloyDB Omni database and data.
- altimate-codeOfficial plugin · 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 profiling, FinOps, connectivity to Snowflake, BigQuery, Redshift, Databricks, Postgres, MySQL, DuckDB).
- azure-sql-developerOfficial plugin · Database
Agent skills for Azure SQL Developer, the Azure SQL Database engine running locally in a container. Teaches your agent to run the engine, connect, migrate, scaffold, build RAG, wire CI, and go local-to-cloud, using the real Private Preview image instead of the SQL Server image.
Source anthropics/claude-plugins-official · Updated Oct 11, 2026 · All rights belong to the original creators