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.

60

Quality

70%

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

65%

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

The body is highly actionable with concrete checklists, sequenced procedures, and an output template, but it is hurt by redundancy across sections, missing validation checkpoints for destructive database operations, and reliance on a 'rules/' directory and 'AGENTS.md' that are not present in the bundle.

Suggestions

Ship the referenced 'rules/*.md' files and 'AGENTS.md' (or remove the references) so progressive-disclosure navigation resolves to real content.

Add an explicit validation step to the review workflow, e.g. 'Confirm each finding cites a real rule and verify the suggested change is non-destructive before recommending it', to satisfy the destructive-operation feedback-loop requirement.

Dedupe the rule listings — keep either 'Review Procedures' or 'Quick Reference' as the primary index and cross-reference rather than repeating every rule name with its description twice.

DimensionReasoningScore

Conciseness

The body is mostly efficient actionable reference material, but rule names and counts recur redundantly across 'Review Procedures', the priority table, and 'Quick Reference' (e.g. schema-pk and insert-mutation rules each appear 2-3 times), so it could be tightened. It does not earn a 3 because of that repetition; it avoids a 1 by not explaining basic concepts Claude already knows.

2 / 3

Actionability

Concrete sequenced procedures ('Read these rule files in order'), specific quantitative checklists ('Batch size 10K-100K rows', 'partition count 100-1,000'), and a copy-paste output format template provide fully executable guidance.

3 / 3

Workflow Clarity

A clear priority order and sequenced rule reading exist, but this is a database-review skill covering destructive/batch operations (ALTER TABLE, mutations, OPTIMIZE) and lacks any validation or verification checkpoint before issuing recommendations, which per the rubric caps workflow clarity at 2.

2 / 3

Progressive Disclosure

The body is well-structured with one-level-deep references to a 'rules/' directory and 'AGENTS.md', but none of these referenced bundle files actually exist in the skill, so the navigation points to missing material rather than genuinely splitting content. It is above 1 because the in-body structure is clear and well-signaled, but below 3 because the references are broken.

2 / 3

Total

9

/

12

Passed

Description

75%

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 is specific and clearly scoped to ClickHouse with an explicit use-trigger, but it uses imperative/second-person voice ('MUST USE when reviewing') instead of third person, which the rubric penalizes, and its trigger terms are limited to a few technical keywords.

Suggestions

Rewrite in third-person voice, e.g. 'Reviews ClickHouse schemas, queries, and configurations against 28 rules. Use when reviewing ClickHouse DDL, query plans, or ingestion pipelines.'

Add more natural user trigger terms such as 'slow query', 'MergeTree', 'partitioning', or 'ClickHouse tuning'.

DimensionReasoningScore

Specificity

Concrete actions are named ('reviewing ClickHouse schemas, queries, or configurations', '28 rules that MUST be checked', 'cite specific rules'), but the imperative 'MUST USE' voice is second-person rather than third person, which per the rubric guidelines reduces the specificity score by one.

2 / 3

Completeness

It explicitly answers both what ('Contains 28 rules that MUST be checked') and when ('MUST USE when reviewing ClickHouse schemas, queries, or configurations'), with an explicit trigger clause.

3 / 3

Trigger Term Quality

Domain keywords like 'ClickHouse', 'schemas', 'queries', and 'configurations' are present and natural for this audience, but common user variations (e.g. 'tuning', 'slow query', 'MERGETREE', 'partition') are missing.

2 / 3

Distinctiveness Conflict Risk

'ClickHouse' is a distinct, narrowly-scoped niche with specific triggers, making it unlikely to fire for unrelated skills.

3 / 3

Total

10

/

12

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.

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
MapleTechLabs/maple
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.