clickhouse-best-practices
MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.
- Version
- 0.4.0
- License
- Apache-2.0
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/clickhouse-best-practices/SKILL.md
- skills/clickhouse-best-practices/AGENTS.md
- skills/clickhouse-best-practices/LICENSE
- skills/clickhouse-best-practices/README.md
- skills/clickhouse-best-practices/metadata.json
- skills/clickhouse-best-practices/rules/_sections.md
- skills/clickhouse-best-practices/rules/_template.md
- skills/clickhouse-best-practices/rules/agent-connect-mcp.md
- skills/clickhouse-best-practices/rules/agent-discovery-schema.md
- skills/clickhouse-best-practices/rules/agent-query-safety.md
- skills/clickhouse-best-practices/rules/insert-async-small-batches.md
- skills/clickhouse-best-practices/rules/insert-batch-size.md
- skills/clickhouse-best-practices/rules/insert-format-native.md
- skills/clickhouse-best-practices/rules/insert-mutation-avoid-delete.md
- skills/clickhouse-best-practices/rules/insert-mutation-avoid-update.md
- skills/clickhouse-best-practices/rules/insert-optimize-avoid-final.md
- skills/clickhouse-best-practices/rules/query-index-skipping-indices.md
- skills/clickhouse-best-practices/rules/query-join-choose-algorithm.md
- skills/clickhouse-best-practices/rules/query-join-consider-alternatives.md
- skills/clickhouse-best-practices/rules/query-join-filter-before.md
- skills/clickhouse-best-practices/rules/query-join-null-handling.md
- skills/clickhouse-best-practices/rules/query-join-use-any.md
- skills/clickhouse-best-practices/rules/query-mv-incremental.md
- skills/clickhouse-best-practices/rules/query-mv-refreshable.md
- skills/clickhouse-best-practices/rules/schema-json-when-to-use.md
- skills/clickhouse-best-practices/rules/schema-partition-lifecycle.md
- skills/clickhouse-best-practices/rules/schema-partition-low-cardinality.md
- skills/clickhouse-best-practices/rules/schema-partition-query-tradeoffs.md
- skills/clickhouse-best-practices/rules/schema-partition-start-without.md
- skills/clickhouse-best-practices/rules/schema-pk-cardinality-order.md
- skills/clickhouse-best-practices/rules/schema-pk-filter-on-orderby.md
- skills/clickhouse-best-practices/rules/schema-pk-plan-before-creation.md
- skills/clickhouse-best-practices/rules/schema-pk-prioritize-filters.md
- skills/clickhouse-best-practices/rules/schema-types-avoid-nullable.md
- skills/clickhouse-best-practices/rules/schema-types-enum.md
- skills/clickhouse-best-practices/rules/schema-types-lowcardinality.md
- skills/clickhouse-best-practices/rules/schema-types-minimize-bitwidth.md
- skills/clickhouse-best-practices/rules/schema-types-native-types.md
Every link opens the file at its source, pinned to the revision this page describes.