FreeSkills
Commits, branches and sync with the but CLI
- 361361 downloads
- 198198 likes
- 103103 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
Reviewing ClickHouse schemas and queries v1.0.0
Use this resource to review a ClickHouse schema, query or insert strategy
New
- 391 downloads
- 117 likes
- 185 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install clickhouse-schema-query-review-2With 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 applies the 28 ClickHouse best-practice rules to CREATE TABLE statements, SELECT and join queries, and insert strategies. It cites each rule, separates violations from compliant points and proposes the fix.
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
- README.md: overview and how to apply the rules
- rules/query-join-filter-before.md: filtering before a join
- rules/insert-batch-size.md: insert batch size
Good fit for
- You are designing a ClickHouse table to store traces
- A join-heavy query is slow on a large volume
Not for
Tags
- clickhouse
- schema
- query
- insert
About
You say
“Review this ClickHouse query with a join and tell me which rules it breaks.”
Skill published by langfuse 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 a ClickHouse schema, query or insert strategy
- Review and adjust the result
Content preview
Files
- LICENSE1.6 KB
- NOTICE-PALATEKIT.md0.5 KB
- README.md2 KB
- rules/_sections.md1.2 KB
- rules/_template.md0.6 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.md1.8 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.md14.1 KB
Origin and licence
Listed unmodified
- Author
- langfuse
- Source
- github.com/langfuse/langfuse/tree/b1067f3a8c7deb449893f7f84d2e2699a4405656/.agents/skills/clickhouse-best-practices
- Licence
- Apache-2.0
Notice
« clickhouse-best-practices » (langfuse, 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…