Skills
Navigate
skills/clickhouse/agent-skills/clickhouse-best-practices/Runlayer

clickhouse-best-practices

Pass

Audited by Runlayer on Feb 26, 2026

Risk Level: LOW
Scan Summary
Max Score
73%
Files
34
Flagged
8
Chunks
41
Flagged Files (8)
clickhouse-best-practices/AGENTS.mdLOW
72.8%

Tool passed security scan

Malicious tool definition detected

clickhouse-best-practices/rules/query-mv-incremental.mdLOW
71.7%

Malicious tool definition detected

hour DateTime, events AggregateFunction(count), unique_users AggregateFunction(uniq, UInt64) ) ENGINE = AggregatingMergeTree() ORDER BY (event_type, hour); -- Create materialized view to populate incrementally CREATE MATERIALIZED VIEW events_hourly_mv TO events_hourly AS SELECT event_type, toStartOfHour(timestamp) as hour, countState() as events, uniqState(user_id) as unique_users FROM events GROUP BY event_type, hour; -- Query the pre-aggregated data SELECT event_type, hour, countMerge(events)

clickhouse-best-practices/rules/schema-partition-lifecycle.mdLOW
67.5%

Tool passed security scan

clickhouse-best-practices/rules/insert-mutation-avoid-update.mdLOW
61.2%

Tool passed security scan

clickhouse-best-practices/rules/query-mv-refreshable.mdLOW
56.8%

Tool passed security scan

clickhouse-best-practices/rules/insert-mutation-avoid-delete.mdLOW
56.5%

Tool passed security scan

clickhouse-best-practices/rules/query-index-skipping-indices.mdLOW
54.3%

Tool passed security scan

clickhouse-best-practices/rules/query-join-consider-alternatives.mdLOW
50.8%

Tool passed security scan

Passed Files (26)Click to expand
clickhouse-best-practices/SKILL.mdOK
48.8%

Tool passed security scan

clickhouse-best-practices/rules/insert-optimize-avoid-final.mdOK
48.6%

Tool passed security scan

clickhouse-best-practices/rules/_sections.mdOK
42.5%

Tool passed security scan

clickhouse-best-practices/rules/schema-partition-low-cardinality.mdOK
36.3%

Tool passed security scan

clickhouse-best-practices/rules/schema-partition-query-tradeoffs.mdOK
34.4%

Tool passed security scan

clickhouse-best-practices/rules/schema-pk-cardinality-order.mdOK
31.1%

Tool passed security scan

clickhouse-best-practices/rules/schema-pk-plan-before-creation.mdOK
30.6%

Tool passed security scan

clickhouse-best-practices/rules/schema-json-when-to-use.mdOK
28.4%

Tool passed security scan

clickhouse-best-practices/rules/insert-async-small-batches.mdOK
28.2%

Tool passed security scan

clickhouse-best-practices/rules/query-join-filter-before.mdOK
26.8%

Tool passed security scan

clickhouse-best-practices/rules/query-join-choose-algorithm.mdOK
26.7%

Tool passed security scan

clickhouse-best-practices/rules/schema-partition-start-without.mdOK
25.0%

Tool passed security scan

clickhouse-best-practices/rules/schema-pk-prioritize-filters.mdOK
24.8%

Tool passed security scan

clickhouse-best-practices/metadata.jsonOK
24.2%

Tool passed security scan

clickhouse-best-practices/rules/insert-batch-size.mdOK
20.1%

Tool passed security scan

clickhouse-best-practices/rules/query-join-null-handling.mdOK
20.0%

Tool passed security scan

clickhouse-best-practices/rules/schema-pk-filter-on-orderby.mdOK
18.4%

Tool passed security scan

clickhouse-best-practices/rules/schema-types-enum.mdOK
17.4%

Tool passed security scan

clickhouse-best-practices/README.mdOK
15.8%

Tool passed security scan

clickhouse-best-practices/rules/schema-types-native-types.mdOK
13.7%

Tool passed security scan

clickhouse-best-practices/rules/schema-types-minimize-bitwidth.mdOK
12.7%

Tool passed security scan

clickhouse-best-practices/rules/insert-format-native.mdOK
10.9%

Tool passed security scan

clickhouse-best-practices/rules/schema-types-lowcardinality.mdOK
8.2%

Tool passed security scan

clickhouse-best-practices/rules/query-join-use-any.mdOK
7.6%

Tool passed security scan

clickhouse-best-practices/rules/schema-types-avoid-nullable.mdOK
3.9%

Tool passed security scan

clickhouse-best-practices/rules/_template.mdOK
0.8%

Tool passed security scan

Audit Metadata
Max File Score
73%
Classification
KNOWN_SERVER_ALL_UNKNOWN
Files Scanned
34
Files Flagged
8
Chunks Analyzed
41
Analyzed
Feb 26, 2026, 05:16 PM
Security Audit — runlayer — clickhouse-best-practices