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.
Quickly install clickhouse-query-optimization AI skill to your development environment via command line
Source: obsessiondb/clickhouse-plugin.
Search terms: query optimization, PREWHERE, JOIN, dictionary, EXPLAIN, performance, slow query, memory limit, timeout, full table scan, dictGet, query cache, DELETE, UPDATE, mutation, aggregation, GROUP BY, COUNT DISTINCT, uniq, querylog
The ORDER BY clause in table definition determines query performance. ClickHouse stores data sorted by these columns and uses a sparse primary index to skip irrelevant data.
Key insight: Always filter on the leftmost ORDER BY columns first for best performance.
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. Source: obsessiondb/clickhouse-plugin.
Stable fields and commands for AI/search citations.
npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-query-optimization20+ 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. Source: obsessiondb/clickhouse-plugin.
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-query-optimization Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
https://github.com/obsessiondb/clickhouse-plugin