Analyze ClickHouse transformation model queries and recommend performance improvements.
npx skills add https://github.com/ethpandaops/xatu-cbt --skill optimize-model
Please help me install this Agent Skill. Skill: optimize-model Source: https://github.com/ethpandaops/xatu-cbt/tree/main/.claude/skills/optimize-model Command: npx skills add https://github.com/ethpandaops/xatu-cbt --skill optimize-model
This Skill identifies and recommends high-impact performance improvements for ClickHouse transformation models, ensuring queries run faster and more efficiently without manual code edits.
Use the optimize-model skill to analyze the performance of the 'models/transformations/fct_block.sql' model.
High-intent search queries and answers about installing and using this skill.
To optimize slow ClickHouse transformation model queries, you can analyze live performance metrics and schema introspection to identify bottlenecks. This approach provides actionable recommendations like rewriting joins or adjusting data types to improve SQL query efficiency.
ClickHouse schema introspection for query performance tuning is the process of examining table schemas to identify optimization opportunities. It analyzes data types and structures to recommend high-impact SQL improvements without requiring manual code edits.
To benchmark ClickHouse SQL query performance across different time windows, you run performance tests that validate improvements using live ClickHouse evidence. This benchmarking process measures execution times to prove the impact of applied query optimization recommendations.
Yes, you need Bash and Python to run ClickHouse query analysis, along with jq and HTTP access to ClickHouse. These dependencies are required to execute the scripts that analyze performance metrics and generate optimization recommendations.
The best way to visualize ClickHouse model dependencies for SQL optimization is by using a tool that renders dependency graphs alongside schema analysis. This helps you understand transformation model structures to pinpoint performance bottlenecks accurately.
Your ClickHouse transformation model may run slowly due to suboptimal joins, inefficient data types, or poor schema design rather than syntax errors. Analyzing live performance metrics and schema introspection can pinpoint these exact bottlenecks for targeted query optimization.
go-againMount an HTTP handler to add a browser-based admin GUI for LiteORM databases.
patricio0312revAnalyze SQL EXPLAIN plans and propose indexes and rewrites to optimize slow queries.
ShunmeiChoProvide ClickHouse database design, query optimization, and data ingestion patterns.
chmonitorAnalyze slow ClickHouse queries and generate ranked optimization recommendations.
