Clickhouse Best Practices
by ClickHousee3229ed4aafbApache-2.07 starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 3 days ago
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.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| AGENTS.md | 62.1 KB | text/markdown |
| metadata.json | 643 B | application/json |
| README.md | 1.9 KB | text/markdown |
| rules/agent-connect-mcp.md | 4.4 KB | text/markdown |
| rules/agent-discovery-schema.md | 5.7 KB | text/markdown |
| rules/agent-query-safety.md | 5.2 KB | text/markdown |
| rules/insert-async-small-batches.md | 1.8 KB | text/markdown |
| rules/insert-batch-size.md | 1.5 KB | text/markdown |
| rules/insert-format-native.md | 933 B | text/markdown |
| rules/insert-mutation-avoid-delete.md | 2 KB | text/markdown |
| rules/insert-mutation-avoid-update.md | 2.1 KB | text/markdown |
| rules/insert-optimize-avoid-final.md | 1.9 KB | text/markdown |
| rules/query-index-skipping-indices.md | 2.4 KB | text/markdown |
| rules/query-join-choose-algorithm.md | 1.8 KB | text/markdown |
| rules/query-join-consider-alternatives.md | 2.1 KB | text/markdown |
| rules/query-join-filter-before.md | 1.3 KB | text/markdown |
| rules/query-join-null-handling.md | 1 KB | text/markdown |
| rules/query-join-use-any.md | 1.1 KB | text/markdown |
| rules/query-mv-incremental.md | 2 KB | text/markdown |
| rules/query-mv-refreshable.md | 2 KB | text/markdown |
| rules/schema-json-when-to-use.md | 2 KB | text/markdown |
| rules/schema-partition-lifecycle.md | 1.5 KB | text/markdown |
| rules/schema-partition-low-cardinality.md | 1.6 KB | text/markdown |
| rules/schema-partition-query-tradeoffs.md | 1.1 KB | text/markdown |
| rules/schema-partition-start-without.md | 1.2 KB | text/markdown |
| rules/schema-pk-cardinality-order.md | 1.6 KB | text/markdown |
| rules/schema-pk-filter-on-orderby.md | 1.5 KB | text/markdown |
| rules/schema-pk-plan-before-creation.md | 2 KB | text/markdown |
| rules/schema-pk-prioritize-filters.md | 1.2 KB | text/markdown |
| rules/schema-types-avoid-nullable.md | 1.8 KB | text/markdown |
| rules/schema-types-enum.md | 1.7 KB | text/markdown |
| rules/schema-types-lowcardinality.md | 1.7 KB | text/markdown |
| rules/schema-types-minimize-bitwidth.md | 1.4 KB | text/markdown |
| rules/schema-types-native-types.md | 1.8 KB | text/markdown |
| rules/_sections.md | 1.8 KB | text/markdown |
| rules/_template.md | 624 B | text/markdown |
| SKILL.md | 10.1 KB | text/markdown |
Source and attribution
Source:ClickHouse/clickhouse-claude-code-plugininskills/clickhouse-best-practicesat commite3229ed
License: Apache-2.0
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from ClickHouse/clickhouse-claude-code-plugin
More in Software Development
Playground
anthropics
Builds self-contained interactive HTML playgrounds with controls, live preview, and copyable prompt output.
M5 Onboard
anthropics
Provisions M5Stack ESP32 boards by detecting them on USB, flashing UIFlow 2.0 firmware, and installing a MicroPython app bundle.
Cardputer Buddy
anthropics
Guides iterating on a Cardputer-Adv MicroPython app bundle: adding apps, pushing files over USB-serial, tailing logs, and running REPL commands.
Dpop Adoption
Guides implementation of OAuth 2.0 DPoP (RFC 9449) sender-constrained refresh tokens for Google's OAuth platform.
Gemini Live Api
Generates a Gemini Live API WebSocket client class, tests, docs, and a demo UI for bidirectional streaming.
Gemini Api
Guides use of the Gemini API on Google's Agent Platform with the Gen AI SDK across languages and capabilities.