Skill UI

This guide provides advanced patterns and best practices for optimizing Apache Spark jobs. It covers critical areas like effective partitioning, memory tuning, minimizing data skew, and optimizing different types of joins (broadcast, bucket). Use this when troubleshooting slow, large-scale data processing workflows or needing to scale Spark pipelines efficiently and reliably.

This comprehensive guide provides advanced techniques to diagnose and significantly boost ClickHouse query performance. It covers analyzing slow queries using system tables, optimizing ORDER BY keys, implementing data skipping indexes (Bloom, Set, MinMax), utilizing projections for pre-aggregation, and fine-tuning server settings and materialized views. Essential for high-volume OLAP environments.

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.

A dedicated skill for performing manual data synchronization and knowledge recall with OpenViking. It allows users to explicitly trigger chat transcript syncing from OpenClaw sessions and perform targeted memory searches via command line, without disrupting normal conversation flow or occupying the standard context engine slot.

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.