clickhouse-best-practices
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.
スキルの内容
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.
できること
- Review ClickHouse schemas against cited rules
- Check sort keys, types and joins
- Apply Langfuse's migration and query rules
概要
- 公開元
- Langfuse
インストール
プロジェクトのドキュメントに、確認できるインストール手順がありません。 プロジェクトの手順を見る
含まれるファイル
- README.md
- rules/_sections.md
- rules/_template.md
- rules/insert-async-small-batches.md
- rules/insert-batch-size.md
- rules/insert-format-native.md
- rules/insert-mutation-avoid-delete.md
- rules/insert-mutation-avoid-update.md
- rules/insert-optimize-avoid-final.md
- rules/query-index-skipping-indices.md
- rules/query-join-choose-algorithm.md
- rules/query-join-consider-alternatives.md
- rules/query-join-filter-before.md
- rules/query-join-null-handling.md
- rules/query-join-use-any.md
- rules/query-mv-incremental.md
- rules/query-mv-refreshable.md
- rules/schema-json-when-to-use.md
- rules/schema-partition-lifecycle.md
- rules/schema-partition-low-cardinality.md
- rules/schema-partition-query-tradeoffs.md
- rules/schema-partition-start-without.md
- rules/schema-pk-cardinality-order.md
- rules/schema-pk-filter-on-orderby.md
- rules/schema-pk-plan-before-creation.md
MCPサーバーやスキルは、お使いのコンピューターでコードを実行したり、データを操作したりできます。インストールする前にソースを確認してください。
詳細
出典
- スキルファイル(SKILL.md)github.com/langfuse/langfuse · 根拠となる項目:ライセンス, スクリプトを含む2026年11月10日
- GitHubリポジトリgithub.com/langfuse/langfuse · 根拠となる項目:公開元, 活動状況2026年11月11日
- リポジトリ内のフォルダ(clickhouse-best-practices)github.com/langfuse/langfuse · 根拠となる項目:スクリプトを含む2026年11月10日