query-analyzer
CommunityAnalyze and optimize ClickHouse queries.
Authorrahmatrdn
Version1.0.0
Installs0
System Documentation
What problem does it solve?
ClickHouse query workloads often suffer from inefficiencies due to missing insights into schema, plans, and runtime metrics. This skill helps explain and diagnose performance issues and guide optimizations.
Core Features & Use Cases
- Schema assessment: use SHOW CREATE TABLE and DESCRIBE TABLE to understand table structure and partitioning implications.
- Query plan analysis: leverage EXPLAIN (indexes=1), EXPLAIN actions=1, and EXPLAIN PIPELINE to reveal how a query will be executed.
- Runtime performance auditing: inspect system.query_log for read_rows vs result_rows, read_bytes, memory_usage, and query_duration_ms to pinpoint bottlenecks.
- Use Case: Optimize a slow report by identifying heavy scans, bad joins, or missing partition pruning and implementing targeted changes.
Quick Start
Provide a sample ClickHouse query to analyze and receive a detailed optimization plan.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 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: query-analyzer Download link: https://github.com/rahmatrdn/go-ch-manager/archive/main.zip#query-analyzer 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.