home/categories/sql-databases/obsessiondb-clickhouse-skills-skills-clickhouse-query-optimization-skill-md
sql-databasesdatabases

clickhouse-query-optimization

20+ optimization rules for ClickHouse queries. Load when writing queries, debugging slow queries, fixing memory errors, or optimizing JOINs. Achieves 10-100x faster queries, 90% less memory usage.

obsessiondb
maintainer
obsessiondb
Updated 2/3/2026
Stars
13
Forks
0
quick start

Installation and usage

20+ optimization rules for ClickHouse queries. Load when writing queries, debugging slow queries, fixing memory errors, or optimizing JOINs. Achieves 10-100x faster queries, 90% less memory usage.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use clickhouse-query-optimization