Skip to content
Kitbay
Skill

clickhouse-best-practices

Apache-2.0Updated on Nov 11, 202637,296GitHub stars

A skill kept in the Langfuse repository for reviewing ClickHouse schemas, queries and settings against 28 rules before recommending changes, citing the rule behind each finding.

What the skill teaches

A skill kept in the Langfuse repository for reviewing ClickHouse schemas, queries and settings against 28 rules before recommending changes, citing the rule behind each finding. The rules cover primary key and sort order, column types, joins, insert batch sizes, avoiding updates and deletes, partitioning, skipping indexes, materialised views, asynchronous inserts, avoiding OPTIMIZE and JSON columns, ordered by impact. Its frontmatter names ClickHouse Inc as author under Apache-2.0, and Langfuse adds its own section: a query builder for the events table without FINAL, query attribution through log comments, migration templates for clustered and single-node installs, and no CREATE OR REPLACE because of NFS self-hosting problems.

Capabilities

  • Review ClickHouse schemas against cited rules
  • Check sort keys, types and joins
  • Apply Langfuse's migration and query rules