clickhouse-query-optimization
OfficialAccelerate ClickHouse queries
Authorobsessiondb
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses slow-performing ClickHouse queries, excessive memory usage, and inefficient data retrieval, enabling users to achieve significantly faster query execution and reduced resource consumption.
Core Features & Use Cases
- Query Speed Optimization: Implements over 20 rules to make queries 10-100x faster.
- Memory Reduction: Helps reduce memory usage by up to 90%.
- Efficient Data Access: Eliminates full table scans and optimizes JOINs.
- Use Case: A user is experiencing a query that takes several minutes to return results. They can use this Skill to analyze the query, identify bottlenecks like inefficient JOINs or missing indexes, and receive actionable advice to optimize it for sub-second performance.
Quick Start
Optimize the following ClickHouse query for better performance.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: clickhouse-query-optimization Download link: https://github.com/obsessiondb/clickhouse-skills/archive/main.zip#clickhouse-query-optimization Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.