CtrlK
BlogDocsLog inGet started
Tessl Logo

clickhouse-system-queries

Dispatcher skill for ClickHouse system-table operational queries. Use table-specific references for concrete SQL patterns.

61

Quality

53%

Does it follow best practices?

Impact

Pending

No eval scenarios have been run

SecuritybySnyk

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./resources/skills/clickhouse-system-queries/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Discovery

22%

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

This description is too abstract and implementation-focused rather than user-facing. It fails to explain what concrete tasks the skill accomplishes and provides no clear triggers for when Claude should select it. The term 'dispatcher skill' is internal jargon that doesn't help with skill selection.

Suggestions

Replace 'dispatcher skill for operational queries' with specific actions like 'Query ClickHouse system tables to monitor query performance, check replication status, analyze table statistics, and diagnose cluster health'

Add an explicit 'Use when...' clause with natural trigger terms such as 'Use when users ask about ClickHouse performance, system metrics, query logs, or mention system.* tables'

Remove the implementation guidance ('Use table-specific references for concrete SQL patterns') which doesn't help with skill selection and replace with user-facing context

DimensionReasoningScore

Specificity

The description uses vague language like 'dispatcher skill' and 'operational queries' without listing any concrete actions. It doesn't specify what operations can be performed (e.g., query logs, monitor performance, check replication status).

1 / 3

Completeness

The 'what' is extremely vague ('dispatcher skill for queries') and there is no explicit 'when' clause. The phrase 'Use table-specific references' is guidance for implementation, not a trigger condition for when to use this skill.

1 / 3

Trigger Term Quality

Contains 'ClickHouse' and 'system-table' which are relevant technical terms users might mention, but lacks natural variations like 'system tables', 'monitoring', 'diagnostics', or specific table names users would reference.

2 / 3

Distinctiveness Conflict Risk

The ClickHouse + system-table combination provides some specificity, but 'operational queries' is broad enough to potentially conflict with other database monitoring or query skills. The dispatcher nature adds confusion about its role.

2 / 3

Total

6

/

12

Passed

Implementation

85%

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

This is a well-structured dispatcher skill that efficiently routes system table queries to appropriate references. The workflow is clear with good decision logic and guardrails. The main weakness is the lack of inline executable examples—the skill relies entirely on external references for concrete SQL patterns, which is appropriate for a dispatcher but reduces standalone actionability.

Suggestions

Add one minimal inline SQL example showing the Map access pattern (ProfileEvents['Name']) vs flattened column pattern to make the guidance immediately actionable

Include a brief example of what a 'chart-oriented' vs 'standard ranked search' query looks like to clarify the search_query_log vs execute_sql decision

DimensionReasoningScore

Conciseness

The skill is lean and efficient, assuming Claude's competence with ClickHouse and SQL. No unnecessary explanations of what system tables are or how ClickHouse works—every section provides actionable routing and constraints.

3 / 3

Actionability

Provides clear workflow steps and specific tool calls (skill_resource, execute_sql, search_query_log), but lacks concrete SQL examples or copy-paste ready code. The guidance is specific but relies heavily on external references for actual SQL patterns.

2 / 3

Workflow Clarity

Clear 4-step workflow with explicit decision points (when to use search_query_log vs execute_sql, when to load references). Guardrails section provides validation checkpoints and explicit constraints for error prevention.

3 / 3

Progressive Disclosure

Excellent structure as a dispatcher skill—provides overview and routing logic while clearly pointing to table-specific references (references/system-query-log.md) for detailed patterns. One-level-deep references are well-signaled.

3 / 3

Total

11

/

12

Passed

Validation

81%

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

Validation9 / 11 Passed

Validation for skill structure

CriteriaDescriptionResult

metadata_version

'metadata.version' is missing

Warning

metadata_field

'metadata' should map string keys to string values

Warning

Total

9

/

11

Passed

Repository
FrankChen021/datastoria
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.