Dispatcher skill for ClickHouse system-table operational queries. Use table-specific references for concrete SQL patterns.
61
53%
Does it follow best practices?
Impact
Pending
No eval scenarios have been run
Passed
No known issues
Optimize this skill with Tessl
npx tessl skill review --optimize ./resources/skills/clickhouse-system-queries/SKILL.mdQuality
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
| Dimension | Reasoning | Score |
|---|---|---|
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
| Dimension | Reasoning | Score |
|---|---|---|
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.
Validation — 9 / 11 Passed
Validation for skill structure
| Criteria | Description | Result |
|---|---|---|
metadata_version | 'metadata.version' is missing | Warning |
metadata_field | 'metadata' should map string keys to string values | Warning |
Total | 9 / 11 Passed | |
68a8440
Table of Contents
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.