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.
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
About
- Publisher
- Langfuse
Install
The project doesn't document install steps that we could confirm. See the project's own instructions
What's inside
- 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 servers and skills can run code on your computer and act on your data. Review the source before installing.
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tool | Not stated in its documentation | |
| Publisher | Langfuse | source |
| Official status | Not stated in its documentation | |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | No | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | Apache-2.0 | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 11, 202637,296 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository Website |
Sources
- Skill file (SKILL.md)github.com/langfuse/langfuse · Backs: Licence, Includes scriptsNov 10, 2026
- GitHub repositorygithub.com/langfuse/langfuse · Backs: Publisher, ActivityNov 11, 2026
- Folder in the repository (clickhouse-best-practices)github.com/langfuse/langfuse · Backs: Includes scriptsNov 10, 2026