Skill UI

A comprehensive guide detailing optimization techniques for Databricks environments. It covers optimal cluster sizing for various workloads (ETL, ML, Streaming), advanced Spark configurations (AQE, memory management), and deep data optimization strategies for Delta Lake, including Z-Ordering and Liquid Clustering. It also provides methods for query plan analysis and join optimization.

An expert guide for performing complex data analysis, cleaning, and transformation using pandas DataFrames. This skill covers advanced techniques such as vectorized operations, efficient merging, time series resampling, group-by aggregations, and memory optimization, ensuring production-grade code and robust data validation.

This skill proactively detects and reports comprehensive system resources, including CPU cores, GPU types (NVIDIA, AMD, Apple Silicon), available memory, and disk space. It generates a detailed JSON report with strategic, context-aware recommendations for optimizing scientific computing workflows, such as recommending parallel processing libraries (Dask, joblib), out-of-core methods (Zarr), or appropriate GPU acceleration backends (Metal, ROCm). Use this before any large-scale data analysis, model training, or computationally intensive simulation to make informed architectural decisions.

Latch is a robust Python framework designed for building, deploying, and managing complex, scalable bioinformatics workflows as serverless pipelines. It supports integrating multiple analysis tools (like Nextflow/Snakemake) and handles cloud data management (LatchFile/LatchDir) and detailed resource configuration (GPU, CPU, memory). Ideal for running large-scale analyses such as RNA-seq, AlphaFold, and single-cell analysis in a reproducible, production-ready environment.

This meta-skill automates the entire process of transforming raw Excel data into structured business insights. It reads the raw data, performs advanced trend and anomaly analysis, writes the resulting findings to a dedicated 'Insights' sheet, and persists key performance indicators (KPIs) to long-term memory. Ideal for comprehensive business reviews and data-driven decision-making.

A comprehensive skill designed to fetch raw market data (Open, High, Low, Close, Volume) for a given symbol. It normalizes the time series data into relative OHLCV vectors, converts these vectors into 64-dimension embeddings, and stores them in a memory store. Crucially, it indexes the resulting vectors using the HNSW algorithm, enabling fast and precise nearest-neighbor search for pattern detection and similarity analysis in financial time series.