clickhouse-io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

1.21x

Quality

31%

Does it follow best practices?

Impact

100%

1.21x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./skills/clickhouse-io/SKILL.md

Evaluation results

100%

IoT Sensor Analytics Platform — Table Schema Design

Table schema design

Criteria

Without context

With context

MergeTree base engine

100%

ReplacingMergeTree for dedup

100%

Time-based partition key

100%

index_granularity setting

100%

Indexed columns ordered first

100%

LowCardinality for repeated strings

100%

Enum for categorical data

100%

Smallest numeric types

100%

No SELECT * in queries

100%

Avoid FINAL keyword

100%

No excessive JOINs

100%

E-Commerce Analytics Dashboard — Query Library

Query optimization patterns

Criteria

Without context

With context

No SELECT *

100%

Indexed columns filtered first

100%

quantile() for percentiles

100%

toStartOfDay for daily bucketing

100%

Window function for running total

100%

system.query_log usage

100%

query_log type filter

100%

query_log duration field

100%

uniq() for distinct count

100%

54%

Ad Platform Event Pipeline — Ingestion and Real-Time Aggregations

Bulk ingestion and materialized views

Criteria

Without context

With context

clickhouse npm package

100%

Batch insert in TypeScript

100%

No per-row insert loop

100%

AggregatingMergeTree for stats table

100%

AggregateFunction column types

100%

Materialized view with State combinators

100%

Merge combinators in query

100%

Time-based partition on events table

100%

toStartOfHour for time bucketing

100%

No SELECT * in queries

100%

Repository: ysyecust/everything-claude-code
Commit: 79cc4e3

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

IoT Sensor Analytics Platform — Table Schema Design E-Commerce Analytics Dashboard — Query Library Ad Platform Event Pipeline — Ingestion and Real-Time Aggregations

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.