altinity-expert-clickhouse-reporting

Official

Diagnose and optimize ClickHouse query performance.

AuthorAltinity
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Diagnosing and correlating ClickHouse SELECT query performance issues across workloads to reduce latency and improve throughput.

Core Features & Use Cases

  • Identify slow queries, frequent offenders, and their patterns from system.query_log and checks.sql outputs.
  • Suggest index usage improvements, MV/Materialized View considerations, and query rewrites to reduce latency.
  • Use during cluster health audits, routine performance troubleshooting, and post-deploy performance verification.

Quick Start

Run the checks.sql file and review the results to pinpoint top offenders and bottlenecks.

Dependency Matrix

Required Modules

None required

Components

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: altinity-expert-clickhouse-reporting
Download link: https://github.com/Altinity/Skills/archive/main.zip#altinity-expert-clickhouse-reporting

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.