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.
O que a skill ensina
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.
O que faz
- Review ClickHouse schemas against cited rules
- Check sort keys, types and joins
- Apply Langfuse's migration and query rules
Sobre
- Publicador
- Langfuse
Instalação
O projeto não documenta passos de instalação que tenhamos conseguido confirmar. Veja as instruções do próprio projeto
O que tem dentro
- 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
Servidores MCP e skills podem executar código no seu computador e agir sobre os seus dados. Revise o código-fonte antes de instalar.
Detalhes
| Fato | Valor | Fonte |
|---|---|---|
| Tipo | Skill | |
| Ferramenta | Não informado na documentação | |
| Publicador | Langfuse | fonte |
| Status oficial | Não informado na documentação | |
| Exige chave de API ou login | Não informado na documentação | |
| Inclui scripts | Não | fonte |
| Plataformas | Não informado na documentação | |
| Clientes de IA | Não informado na documentação | |
| Licença | Apache-2.0 | fonte |
| Preço | Não informado na documentação | |
| Atividade | Último commit em 11 de nov. de 202637.296 estrelas no GitHubDados de download indisponíveis (não está no npm nem no PyPI) | fonte |
| Links | Repositório Site |
Fontes
- Arquivo da skill (SKILL.md)github.com/langfuse/langfuse · Comprova: Licença, Inclui scripts10 de nov. de 2026
- Repositório no GitHubgithub.com/langfuse/langfuse · Comprova: Publicador, Atividade11 de nov. de 2026
- Pasta no repositório (clickhouse-best-practices)github.com/langfuse/langfuse · Comprova: Inclui scripts10 de nov. de 2026