ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
40
Quality
27%
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 ./.agent/skills/agent-clickhouse-io/SKILL.mdQuality
Discovery
32%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 identifies the ClickHouse domain but relies heavily on broad category terms rather than specific capabilities. The complete absence of a 'Use when...' clause significantly weakens its utility for skill selection. While 'ClickHouse' provides some distinctiveness, the generic analytics and data engineering language creates potential overlap with other database skills.
Suggestions
Add an explicit 'Use when...' clause with trigger terms like 'ClickHouse', 'columnar database', 'OLAP queries', 'MergeTree engine', or 'analytical workloads'
Replace broad categories with specific actions: 'Configure MergeTree table engines, write efficient aggregation queries, optimize JOIN performance, design materialized views'
Include common user phrases and file/technology references: '.clickhouse', 'CH queries', 'columnar storage', 'real-time analytics'
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | Names the domain (ClickHouse database) and mentions some actions like 'query optimization, analytics, and data engineering best practices' but these are broad categories rather than concrete specific actions like 'write aggregation queries' or 'configure table engines'. | 2 / 3 |
Completeness | Describes what the skill covers (ClickHouse patterns, optimization, analytics) but completely lacks a 'Use when...' clause or any explicit trigger guidance for when Claude should select this skill. | 1 / 3 |
Trigger Term Quality | Includes 'ClickHouse' which is a strong trigger term, plus 'query optimization', 'analytics', and 'data engineering'. However, missing common variations users might say like 'OLAP', 'columnar database', 'MergeTree', 'analytical queries', or file extensions. | 2 / 3 |
Distinctiveness Conflict Risk | 'ClickHouse' is distinctive, but 'query optimization', 'analytics', and 'data engineering best practices' are generic terms that could overlap with PostgreSQL, MySQL, or general database skills. | 2 / 3 |
Total | 7 / 12 Passed |
Implementation
22%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This skill is essentially a table of contents with minimal actionable content in the main file. The overview explains concepts Claude already knows, and the 21 sub-skill links lack organization or context about when each applies. The inconsistent naming of sub-skills (some numbered, some not) suggests structural issues.
Suggestions
Add at least one quick-start code example showing a basic ClickHouse query pattern directly in the main skill file
Organize the 21 sub-skills into logical categories (e.g., 'Table Engines', 'Query Patterns', 'Data Ingestion', 'Analytics') with brief descriptions of when to use each
Remove the overview section explaining what ClickHouse is - Claude knows this; replace with a decision tree or guidance on which sub-skill to consult for common tasks
Fix inconsistent sub-skill naming (items 17-21 have numbered prefixes that conflict with the list numbering)
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The overview section explains what ClickHouse is and lists basic features that Claude already knows. However, the file is relatively short and the bulk is navigation links, which is appropriate. | 2 / 3 |
Actionability | The skill contains no executable code, commands, or concrete examples. It's entirely a table of contents with links to sub-skills, providing no actionable guidance in the main file itself. | 1 / 3 |
Workflow Clarity | There is no workflow, sequence, or process described. The numbered sub-skills appear to be topics rather than steps, and items 17-21 have inconsistent naming suggesting organizational issues. | 1 / 3 |
Progressive Disclosure | The file does use sub-skills for detailed content, but the organization is poor: 21 links with no categorization, inconsistent naming (items 17-21 have numbered prefixes), and no clear guidance on when to use which sub-skill. | 2 / 3 |
Total | 6 / 12 Passed |
Validation
90%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 10 / 11 Passed
Validation for skill structure
| Criteria | Description | Result |
|---|---|---|
frontmatter_unknown_keys | Unknown frontmatter key(s) found; consider removing or moving to metadata | Warning |
Total | 10 / 11 Passed | |
3395991
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.