CtrlK
BlogDocsLog inGet started
Tessl Logo

clickhouse-best-practices

MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 28 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.

55

Quality

61%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./.agents/skills/clickhouse-best-practices/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

56%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The body delivers strong, dense, ClickHouse-specific guidance with clear review workflows and a structured output format, but it is burdened by significant redundancy — the rule catalog is repeated three times across Review Procedures, the priority table, and the Quick Reference — and inlines ~70 lines of Langfuse-specific migration detail that should live in a referenced file. The skill also points at a rules/ directory that is not present in the bundle.

Suggestions

Delete the Quick Reference section (or the Review Procedures rule lists) — the 28 rule names are enumerated three times, and one canonical listing plus the priority table would cut ~60 redundant lines.

Move the Langfuse-Specific Rules block into a separate reference file (e.g. references/langfuse.md) and keep a one-line pointer with the strongest rule (never FINAL on events) in SKILL.md.

Fold the 'When to Apply' list into the description/trigger guidance and drop the 'Rule File Structure' meta-section — both restate information Claude gets elsewhere in the skill.

DimensionReasoningScore

Conciseness

The 28 rule names are enumerated three times (Review Procedures lists, the priority table, and the ~60-line Quick Reference section), "When to Apply" repeats the description's trigger list, and "Rule File Structure" explains meta-details — roughly a third of the body is redundant padding, which goes beyond 'some unnecessary explanation'. Not 1 because the Langfuse and review-procedure sections are dense with genuinely non-obvious, ClickHouse-specific guidance that earns its tokens.

2 / 5

Actionability

Concrete ordered rule-file reads per review type, exact SQL fragments ("ALTER TABLE <mv> {CLICKHOUSE_CLUSTER_CLAUSE} MODIFY QUERY <select>", "DROP VIEW IF EXISTS <name> {CLICKHOUSE_CLUSTER_CLAUSE};"), specific functions ("JSONExtractString(log_comment, 'surface')"), and a copy-paste output format template. Not 5 because guidance is fragment-based rather than complete runnable examples, and the referenced rules/ files are not present to verify.

4 / 5

Workflow Clarity

A five-step priority order with explicit fallbacks (steps 3-4: general knowledge, then web search), per-procedure ordered rule-file sequences, per-review checklists, and a structured output format give a clear, well-checkpointed sequence. Not 5 because the checklists are static 'check for' lists without validate-fix-retry feedback loops; not 3 because sequence and checkpoints are explicit throughout.

4 / 5

Progressive Disclosure

References to rules/*.md are one level deep and clearly signaled with per-rule descriptions, but the ~70-line "Langfuse-Specific Rules" block is fully inlined in SKILL.md where it clearly belongs in a separate reference file, and the referenced rules/ bundle directory is absent from this skill's bundle, so the split cannot be verified. Not 4 because the inlined block is a significant misplacement rather than a minor organization gap.

3 / 5

Total

13

/

20

Passed

Description

66%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

The description has an explicit and concrete trigger clause and a distinct ClickHouse niche, but its 'what' side is under-specified: it describes the rule-count and citation mechanics instead of the skill's actual coverage (schema design, query optimization, data ingestion), and it lacks common trigger synonyms like performance/tuning/optimization. Third-person voice is respected and no vague fluff is present.

Suggestions

State the skill's scope in the description, e.g. "Guidance on ClickHouse schema design, query optimization, and data ingestion" before the rule-count sentence.

Add natural trigger synonyms users would say, such as "query performance", "tuning", "DDL", or "MergeTree", to the when-clause.

Trim the imperative meta-instructions ("MUST be checked", "Always read... and cite") to one sentence so the capability statement dominates.

DimensionReasoningScore

Specificity

Names the domain ("reviewing ClickHouse schemas, queries, or configurations") and 1-2 concrete actions ("read relevant rule files", "cite specific rules"), but never states what the rules actually cover — schema design, query optimization, and data ingestion appear only in the body, and "Contains 28 rules" is a count rather than a specific capability.

3 / 5

Completeness

Both what ("Contains 28 rules that MUST be checked before providing recommendations") and when ("MUST USE when reviewing ClickHouse schemas, queries, or configurations") are explicitly present, and the when-clause is concrete. Not 5 because the 'what' is meta — it describes the artifact's rule count and citation behavior rather than the skill's actual scope.

4 / 5

Trigger Term Quality

"ClickHouse", "schemas", "queries", and "configurations" are natural trigger terms, but common user phrasings like "query performance", "tuning", "optimization", "DDL", or engine names (MergeTree) are missing, leaving keyword coverage incomplete.

3 / 5

Distinctiveness Conflict Risk

"ClickHouse" carves out a clear, specific niche with distinct trigger terms; no realistic conflict risk with other skills in a general-purpose bundle.

5 / 5

Total

15

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
langfuse/langfuse
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.