Skill UI

This tool collects comprehensive diagnostic data from ClickHouse system tables. It gathers crucial metrics, query logs, merge statuses, and disk usage information. It is essential for troubleshooting performance bottlenecks, preparing detailed support tickets, or investigating complex database infrastructure issues.

A comprehensive guide for deep debugging complex Snowflake issues. This guide covers advanced techniques including detailed query profiling (spill analysis), diagnosing lock contention and transaction conflicts, analyzing metadata operations, and optimizing partition usage. Use it when standard troubleshooting fails to address slow queries or warehouse performance bottlenecks.

This skill helps diagnose performance bottlenecks, slow jobs, and expensive queries across various data platforms (Airflow, dbt, Databricks). It uses a tiered investigation approach, starting with broad discovery to pinpoint problematic jobs or queries, bridging to affected tables, and finally drilling down to identify root causes, latency trends, and change-related regressions.

A comprehensive methodology for accelerating large-scale data ingestion, ETL processes, backfilling, and data warehouse loading. It guides users in identifying and optimizing bottlenecks—such as source extraction, network transfer, and loading speed—while strictly ensuring data correctness and maintaining clear accounting checkpoints throughout the pipeline.