FreeSkills
Commits, branches and sync with the but CLI
- 361361 downloads
- 198198 likes
- 103103 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
ClickHouse schema and query review with 31 rules v1.0.0
Use this resource to review ClickHouse schemas, queries or inserts against best-practice rules
New
- 368 downloads
- 143 likes
- 215 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install clickhouse-schema-query-reviewWith no option, the skill goes to ~/.agents/skills/; add --agent claude-code (or codex, cursor…) to target an agent.
First time: connect the CLI with
npx --yes palatekit@latest loginThe agent consults the relevant rules (schema, queries, inserts, agent connectivity) before any recommendation, then cites each rule it applies in its findings. You get a structured review listing violations and how to fix them.
Mostly picked by
Updated November 2, 2026
Previews
Details
- Install guides
- Generates with
- Your agent's model
- Licence
- Apache-2.0
Similar resources
View all- Free
FreeSkills
Sentry CLI guide
- 525525 downloads
- 117117 likes
- 128128 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Drizzle ORM best practices with PostgreSQL
- 407407 downloads
- 194194 likes
- 151151 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
SLO design wizard
- 537537 downloads
- 105105 likes
- 242242 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
User stories and sprint fit
- 451451 downloads
- 150150 likes
- 132132 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Capacity-based sprint plan
- 423423 downloads
- 192192 likes
- 102102 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Startup CTO advisor
- 580580 downloads
- 201201 likes
- 242242 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Creating GitHub pull requests with quality checks
- 427427 downloads
- 230230 likes
- 196196 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
What you get
- AGENTS.md: how to apply the rules and review procedures
- rules/: one file per rule on inserts, mutations and agent-safe queries
- README.md: overview of the 31-rule set
Good fit for
- You're designing a ClickHouse table and want its schema checked
- A ClickHouse query is slow and you want cited recommendations
Not for
Tags
- clickhouse
- best practices
- schema
- queries
- review
About
You say
“Review this ClickHouse table and cite each rule it breaks.”
Skill published by clickhouse under the Apache-2.0 license, delivered in its original version.
Show moreShow less
How to use it
- Install the skill in your agent's skills folder
- Ask your agent to review ClickHouse schemas, queries or inserts against best-practice rules
- Review and adjust the result
Content preview
Files
- AGENTS.md64 KB
- LICENSE11.3 KB
- metadata.json0.6 KB
- NOTICE-PALATEKIT.md0.5 KB
- README.md1.9 KB
- rules/_sections.md1.8 KB
- rules/_template.md0.6 KB
- rules/agent-connect-mcp.md4.6 KB
- rules/agent-discovery-schema.md5.9 KB
- rules/agent-query-safety.md5.3 KB
- rules/insert-async-small-batches.md1.8 KB
- rules/insert-batch-size.md1.5 KB
- rules/insert-format-native.md0.9 KB
- rules/insert-mutation-avoid-delete.md2 KB
- rules/insert-mutation-avoid-update.md2.2 KB
- rules/insert-optimize-avoid-final.md2 KB
- rules/query-index-skipping-indices.md2.5 KB
- rules/query-join-choose-algorithm.md1.8 KB
- rules/query-join-consider-alternatives.md2.1 KB
- rules/query-join-filter-before.md1.4 KB
- rules/query-join-null-handling.md1.1 KB
- rules/query-join-use-any.md1.1 KB
- rules/query-mv-incremental.md2 KB
- rules/query-mv-refreshable.md2.1 KB
- rules/schema-json-when-to-use.md2.1 KB
- rules/schema-partition-lifecycle.md1.6 KB
- rules/schema-partition-low-cardinality.md1.7 KB
- rules/schema-partition-query-tradeoffs.md1.2 KB
- rules/schema-partition-start-without.md1.2 KB
- rules/schema-pk-cardinality-order.md1.6 KB
- rules/schema-pk-filter-on-orderby.md1.6 KB
- rules/schema-pk-plan-before-creation.md2.1 KB
- rules/schema-pk-prioritize-filters.md1.2 KB
- rules/schema-types-avoid-nullable.md1.9 KB
- rules/schema-types-enum.md1.7 KB
- rules/schema-types-lowcardinality.md1.8 KB
- rules/schema-types-minimize-bitwidth.md1.5 KB
- rules/schema-types-native-types.md1.8 KB
- SKILL.md10.4 KB
Origin and licence
Listed unmodified
- Author
- clickhouse
- Source
- github.com/clickhouse/agent-skills/tree/69a8354b05b5942e5cea77b6c87be7788303fc18/skills/clickhouse-best-practices
- Licence
- Apache-2.0
Notice
« clickhouse-best-practices » (clickhouse, Apache-2.0) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.
User reviews
–
No ratings yet
Loading reviews…