clickhouse-best-practices

✓Verified·Scanned 2/18/2026

This skill provides ClickHouse best-practices and 28 rules for schema design, query optimization, and insert strategies. It includes instructions that invoke npx add-skill ClickHouse/clickhouse-agent-skills and advises external web search referencing https://clickhouse.com/docs, enabling network access and running shell/CLI commands.

by clickhouse·v0.3.0·105.5 KB·492 installs

Scanned from main at 8c9f5a1 · Transparency log ↗

$ vett add clickhouse/agent-skills/clickhouse-best-practices

ClickHouse Best Practices

Agent skill providing comprehensive ClickHouse guidance for schema design, query optimization, and data ingestion.

Installation

npx add-skill ClickHouse/clickhouse-agent-skills

What's Included

28 atomic rules organized by prefix:

Prefix	Count	Coverage
`schema-pk-*`	4	PRIMARY KEY selection, cardinality ordering
`schema-types-*`	5	Data types, LowCardinality, Nullable
`schema-partition-*`	4	Partitioning strategy, lifecycle management
`schema-json-*`	1	JSON type usage
`query-join-*`	5	JOIN algorithms, filtering, alternatives
`query-index-*`	1	Data skipping indices
`query-mv-*`	2	Incremental and refreshable MVs
`insert-batch-*`	1	Batch sizing (10K-100K rows)
`insert-async-*`	2	Async inserts, data formats
`insert-mutation-*`	2	Mutation avoidance
`insert-optimize-*`	1	OPTIMIZE FINAL avoidance

Trigger Phrases

This skill activates when you:

"Create a table for..."
"Optimize this query..."
"Design a schema for..."
"Why is this query slow?"
"How should I insert data into..."
"Should I use UPDATE or..."

Files