CtrlK
BlogDocsLog inGet started
Tessl Logo

clickhouse-io

ClickHouse 数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践。

60

Quality

68%

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 ./docs/ja-JP/skills/clickhouse-io/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

65%Weight 40%Scale 1-3

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 extensive executable ClickHouse code and clear recommended patterns, but it is a monolithic reference catalog that explains some already-known concepts, omits validation checkpoints on batch operations, and offloads no detail to reference files.

Suggestions

Add explicit validation/verification steps after batch inserts and CDC operations (e.g., verify row counts or run a reconciliation query) to lift workflow_clarity toward 3.

Trim the concept-explaining 概览 section and other basic explanatory prose to push conciseness toward 3.

Move the analytics-query catalog and/or data-pipeline patterns into separate reference files referenced one level deep from SKILL.md to improve progressive_disclosure.

DimensionReasoningScore

Conciseness

The body is mostly code-first and efficient, but it opens with a concept-explaining 概览 ("ClickHouse 是一个用于联机分析处理(OLAP)的列式数据库管理系统") that Claude already knows, and at ~425 lines it could be tightened, matching the 'mostly efficient but includes some unnecessary explanation' anchor.

2 / 3

Actionability

It provides extensive executable SQL and TypeScript — real CREATE TABLE statements, working queries using ClickHouse-specific functions (quantile, uniq, sumMerge), and copy-paste insertion code with explicit ✅/❌ recommended-vs-anti examples, fully meeting the 'executable and copy-paste ready' anchor.

3 / 3

Workflow Clarity

Content is well-sequenced by topic with clear ✅/❌ guidance, but batch operations (bulk insert, CDC) and the data pipeline lack explicit validation/verification checkpoints or feedback loops, so workflow clarity is capped at 2 per the destructive/batch-operations rule.

2 / 3

Progressive Disclosure

Everything is inline in a single ~425-line monolithic file with no bundle files; sections are well-organized, but content that could be split out (the analytics query catalog, data pipeline patterns) stays inline, matching the 'content that should be separate is inline' anchor rather than the well-signaled multi-file 3.

2 / 3

Total

9

/

12

Passed

Description

72%Weight 40%Scale 1-3

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 clearly niched to ClickHouse analytics with strong natural trigger terms and low conflict risk, but it lists topic areas rather than concrete actions and lacks an explicit 'Use when' trigger clause, capping both specificity and completeness at 2.

Suggestions

Add an explicit 'Use when...' clause (e.g., 'Use when working with ClickHouse, optimizing analytical queries, or designing schemas for high-performance analytics') to raise completeness from 2 to 3.

Reframe the topic list as concrete actions (e.g., 'Design ClickHouse schemas, optimize queries, build materialized views, and run analytics') to push specificity toward 3.

DimensionReasoningScore

Specificity

The description names a concrete domain and several specific areas ("数据库模式、查询优化、分析" and "数据工程最佳实践"), but these are topic areas rather than the multiple concrete invoke-able actions required for a 3, matching the 'names domain and some actions' anchor.

2 / 3

Completeness

It answers 'what' (schema, query optimization, analytics, data-engineering best practices) but provides no explicit 'Use when...' trigger clause, so the 'when' is only implied and is capped at 2 per the guidelines.

2 / 3

Trigger Term Quality

It covers natural terms a user would actually say — "ClickHouse", "查询优化" (query optimization), "分析" (analytics), and "数据工程" (data engineering) — giving good coverage of the natural vocabulary for this niche.

3 / 3

Distinctiveness Conflict Risk

The ClickHouse-specific framing creates a clear, narrow niche with distinct triggers that are unlikely to fire for or conflict with other 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
xu-xiang/everything-claude-code-zh
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.