Does it work with standard ClickHouse EXPLAIN commands?

Yes, it specifically leverages 'EXPLAIN indexes', 'EXPLAIN actions', and 'EXPLAIN PIPELINE' to give a comprehensive view of the execution engine's behavior.

Can it identify memory-intensive queries?

Yes, it inspects system.query_log metrics to detect peak memory usage and suggests improvements for memory-heavy operations like large JOINs or aggregations.

How does this skill improve ClickHouse performance?

It provides a structured workflow to analyze your schema, execution plans, and runtime logs, suggesting specific optimizations like PREWHERE usage and partition pruning.

Is this skill suitable for ClickHouse beginners?

Absolutely. It follows a best-practice checklist that helps users understand ClickHouse's unique architecture, including LowCardinality strings and columnar storage benefits.

What kind of actionable advice does the skill provide?

The skill generates a structured report identifying bottlenecks and providing numbered SQL changes, such as moving filters to PREWHERE or avoiding SELECT *.

ClickHouse Query Analyzer

Name: ClickHouse Query Analyzer
Author: rahmatrdn

byrahmatrdn

•

Gestión de Bases de Datos

Analyzes and optimizes ClickHouse database queries to improve performance, reduce resource consumption, and resolve execution bottlenecks.

The ClickHouse Query Analyzer skill provides a systematic framework for diagnosing and accelerating SQL performance within ClickHouse environments. By guiding users through a multi-step workflow—including physical schema assessment, detailed EXPLAIN plan analysis, and runtime resource auditing via system logs—it identifies critical inefficiencies such as sub-optimal sorting keys or missing partition filters. This skill is particularly valuable for developers and data engineers looking to minimize I/O overhead, reduce memory pressure during complex joins, and implement high-performance patterns like PREWHERE and function pushdown.

Características Principales

01Automated identification of I/O and memory bottlenecks

024 GitHub stars

03Detailed EXPLAIN plan interpretation for index and pipeline visibility

04Deep schema auditing for partition and sorting key alignment

05Runtime performance auditing using system.query_log metrics

06Actionable SQL refactoring recommendations for columnar storage

Casos de Uso

01Optimizing data layout and indexing to reduce cloud infrastructure costs

02Refactoring inefficient SQL patterns to improve dashboard concurrency and speed

03Troubleshooting slow analytical queries in high-scale production clusters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rahmatrdn/go-ch-manager query-analyzer

For use in Claude.ai and ChatGPT

Download Skill