Skill UI

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 guide provides a comprehensive methodology for load testing and capacity planning within Snowflake data warehouses. It covers optimizing query performance by adjusting warehouse sizes (Scale UP), simulating high concurrency using multi-threading (Scale OUT), and configuring advanced scaling policies (Standard, Economy, Maximized). Users can benchmark critical queries using SQL and simulate real-world user traffic using Python, ensuring robust and cost-efficient production environments.

A comprehensive guide detailing the process of migrating data warehouses to Snowflake from major sources like Amazon Redshift, Google BigQuery, or on-premise databases. This resource covers critical steps including schema conversion (handling dialect differences like STRUCT/ARRAY to VARIANT), robust data transfer methods (S3/Cloud Storage, Python/Pandas), data validation techniques (checksums, row counts), and essential SQL syntax translation patterns.

This utility evaluates complex arithmetic expressions using arbitrary-precision decimal mathematics. It is specifically designed for scientific, financial, or engineering calculations where standard floating-point arithmetic causes unacceptable rounding errors (e.g., 0.1 + 0.2). Supports addition, subtraction, multiplication, division, exponents, and parentheses.

A comprehensive skill for creating, editing, and analyzing complex spreadsheets (.xlsx, .csv, etc.). This skill excels in financial modeling, ensuring all calculations are managed via dynamic Excel formulas rather than hardcoded values. It supports data analysis using pandas, rigorous formatting standards, and complex formula integrity checks, making it ideal for financial reporting and data visualization.

This skill provides comprehensive tools and methodologies for working with the Brain Imaging Data Structure (BIDS) standard. It is essential for organizing, validating, querying, and converting complex multi-modal neuroscience and biomedical datasets (including MRI, EEG, MEG, PET, etc.). Use this when setting up BIDS-compliant directory structures, ensuring data integrity before publication, or converting raw DICOM scans into standardized formats.

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.

The official skill collection for Longbridge Securities, offering over 125 agent skills. It provides comprehensive financial analysis across multiple markets (HK, US, A-share, SG), including real-time quotes, advanced charting, company fundamentals, portfolio management, and options analysis. Supports trilingual interaction (Simplified/Traditional Chinese/English), making it an essential resource for global investors and financial analysts.

This skill processes raw weekly CRM export files (CSV) to generate a clean, structured regional sales summary. It automatically removes duplicate records, calculates the total revenue for each defined region, and outputs the results as a standardized JSON object. Ideal for automating reporting pipelines or preparing data for dashboards.

This meta-skill is designed for complex decision analysis when a user provides or references structured documents such as contracts, quotes, spreadsheets, or notices. Instead of simple summarization, it extracts key evidence, identifies risks (e.g., renewal risk, payment terms), and structures the output into decision-ready formats, such as 'sign/reject/negotiate' recommendations, evidence tables, or required next actions. It supports input from PDF, DOCX, and XLSX formats.

This utility reads structured JSON data from multiple search engines (multi-search-engine JSON) provided via standard input. It processes this academic data and converts it into a minimal, standardized BibTeX format, primarily generating @misc{} entries. This feature is ideal for automating the creation of a bibliography or reference list for scholarly papers, enhancing research workflow efficiency.

A comprehensive guide and set of tools for embedding dynamic Python visualizations (using matplotlib and seaborn) into Power BI reports. It details the structured workflow, including script injection, data handling (dataset DataFrame), and mandatory best practices for generating static PNG output. Ideal for advanced data analysis and complex reporting.