optimize-model
OfficialBoost ClickHouse query performance.
Software Engineering#benchmarking#data transformation#performance tuning#query analysis#sql optimization#clickhouse
Authorethpandaops
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill identifies and recommends high-impact performance improvements for ClickHouse transformation models, ensuring queries run faster and more efficiently without manual code edits.
Core Features & Use Cases
- Performance Analysis: Deeply analyzes transformation model queries using live ClickHouse evidence.
- Dependency Rendering: Visualizes and understands model dependencies.
- Schema Introspection: Examines table schemas for optimization opportunities.
- Benchmarking: Runs performance tests across different time windows to validate improvements.
- Recommendations: Provides actionable, evidence-based suggestions for query optimization.
- Use Case: A data engineer has a complex transformation model that is running slowly. They use this Skill to pinpoint the exact bottlenecks, receive specific optimization recommendations (e.g., rewriting a join, adjusting data types), and see benchmark results proving the improvement.
Quick Start
Use the optimize-model skill to analyze the performance of the 'models/transformations/fct_block.sql' model.
Dependency Matrix
Required Modules
jq
Components
scriptsreferences
💻 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: optimize-model Download link: https://github.com/ethpandaops/xatu-cbt/archive/main.zip#optimize-model 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.