clickhouse-io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. Use when writing ClickHouse schemas or queries, or when an analytical query is too slow.

Quality

76%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./skills/clickhouse-io/SKILL.md

Quality

Content

65%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.

A rich, highly actionable pattern catalog with excellent executable examples, but it is a monolithic wall of inlined content with some over-explanation of basics and no validation checkpoints for its batch/destructive operations.

Suggestions

Remove or trim the Overview and Key Features sections that explain general column-store/OLAP concepts Claude already knows, keeping only ClickHouse-specific guidance.

Add validation/verification checkpoints to the batch and destructive workflows (e.g., confirm row counts after bulk insert, verify CDC payload schema before insert) so workflow clarity can exceed the batch-operation cap of 3.

Move the larger reference blocks (Common Analytics Queries, Data Pipeline Patterns) into separate files under references/ and link to them one level deep, turning SKILL.md into a lean overview.

Dimension	Reasoning	Score
Conciseness	The body is mostly efficient code patterns, but the Overview and Key Features sections explain concepts Claude already knows (e.g., 'column-oriented database management system', 'Data compression', 'Parallel query execution'), which is padding that could be trimmed.	3 / 5
Actionability	Fully executable, copy-paste-ready SQL and TypeScript examples with explicit PASS/FAIL contrast cover the common cases (MergeTree design, aggregations, bulk inserts, materialized views, monitoring).	5 / 5
Workflow Clarity	This is a pattern catalog rather than a sequenced workflow, and the batch/destructive operations (bulk insert, ETL pipeline, CDC) lack validation or verification checkpoints, capping workflow clarity at 3 per the batch-operations rule.	3 / 5
Progressive Disclosure	Sections are clearly headed, but the ~440-line SKILL.md is monolithic with no bundle files or one-level-deep references; large blocks (analytics queries, pipeline patterns) that could live in separate reference files are inlined.	3 / 5
	Total	14 / 20 Passed

Description

87%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.

A strong, third-person description that clearly states both capabilities and explicit activation triggers tied to a specific database. It is concise, concrete, and distinct, with only marginal room to expand trigger synonyms.

Dimension	Reasoning	Score
Specificity	Lists several concrete actions ('query optimization', 'analytics', 'data engineering best practices', 'writing ClickHouse schemas or queries') with only minor gaps in coverage, falling just short of the fully comprehensive 5 anchor.	4 / 5
Completeness	Explicitly answers both what ('ClickHouse database patterns, query optimization, analytics, and data engineering best practices') and when ('Use when writing ClickHouse schemas or queries, or when an analytical query is too slow') with concrete trigger phrases.	5 / 5
Trigger Term Quality	Good natural keyword coverage including 'ClickHouse schemas or queries' and 'analytical query is too slow' that a user would plausibly say, but misses synonyms or file/extension variants needed for the 5 anchor.	4 / 5
Distinctiveness Conflict Risk	ClickHouse is a specific niche with distinct triggers (schema design, slow analytical queries) and minimal overlap risk with other skills.	5 / 5
	Total	18 / 20 Passed

Validation

93%

Warnings & errors only

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

Validation — 15 / 16 Passed

Validation for skill structure

Criteria	Description	Result
metadata_version	'metadata.version' is missing	Warning

	Total	15 / 16 Passed

Repository: affaan-m/ECC
Path: skills/clickhouse-io/SKILL.md
Commit: 06c5e11

Reviewed: 3 days ago

Table of Contents

Discovery Implementation Validation

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.