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.

This advanced toolkit provides a comprehensive framework for in-depth financial analysis. It covers key functions including financial ratio analysis, Discounted Cash Flow (DCF) valuation, budget variance analysis, and rolling forecast construction. It is essential for strategic decision-making, investment analysis, and management reporting across various industries.

This tool generates comprehensive trading signals by analyzing multiple technical indicators (RSI, MACD, Bollinger Bands, etc.) across various assets. It combines indicators to produce composite BUY/SELL signals, complete with confidence scores and risk management levels. Use it when analyzing crypto or stock assets to identify high-potential trading entry or exit points.

This skill acts as an expert risk manager, providing comprehensive guidance on monitoring portfolio risk, calculating R-multiples, and optimizing position limits. It covers advanced quantitative finance topics such as Value at Risk (VaR), correlation analysis, and stress testing using Monte Carlo simulations. Use it for systematic risk assessment, developing hedging strategies (options/futures), and implementing rigorous risk controls in trading workflows.

This advanced workflow orchestrates complex, multi-node GPU clusters on Vast.ai. It is designed for large-scale distributed machine learning training, automatically handling spot instance preemption and resuming jobs from checkpoints. Furthermore, it provides comprehensive cost analysis by tracking billing history, allowing users to optimize GPU spending and manage cluster teardown efficiently.

This skill provides a systematic framework for managing Indicators of Compromise (IOCs) throughout their entire life cycle—from initial discovery and validation to enrichment, deployment, monitoring, and eventual retirement. It emphasizes implementing confidence decay functions, tracking hit rates, and managing false positives to maintain a high-quality, actionable threat intelligence database, thereby minimizing analyst fatigue and maximizing detection efficacy.

Orchestrate Segment customer-data actions through Rube MCP and Composio, covering event tracking, user identification, grouping, page views, batch dispatches, alias merges, and source management while always refreshing schema info first.

Provides comprehensive programmatic control over Apify's core data infrastructure, including Datasets, Key-Value Stores, and Request Queues. This skill allows users to perform CRUD operations on various storage types, manage data persistence, and orchestrate complex, multi-stage data pipelines (e.g., scrape -> transform -> export). Ideal for building robust, end-to-end web scraping and data processing automation workflows.

This guide details how to configure and manage resource constraints in ClickHouse, addressing server-side limits, user quotas, and connection management. Use it when encountering "too many simultaneous queries," optimizing resource usage, or implementing robust rate limiting strategies in applications connecting to ClickHouse. Covers SQL quota setup and client-side pooling techniques.

Provides a comprehensive checklist for deploying Hex data analytics integrations into production. It covers critical operational best practices, including API key management, rate limit handling, error resilience (circuit breakers, exponential backoff), and robust monitoring strategies. This guide ensures that data pipelines are deployed reliably, minimizing downtime and guaranteeing consistent, high-quality data reporting for go-live scenarios.

Master the creation of robust ELT (Extract, Load, Transform) data pipelines within Snowflake. This guide demonstrates advanced data orchestration using Snowflake Streams for Change Data Capture (CDC), Tasks for scheduled transformations and DAG management, and Dynamic Tables for declarative, auto-refreshing data models. Ideal for building sophisticated, scalable data warehousing solutions.

This guide identifies and provides solutions for common anti-patterns and mistakes when working with Snowflake. It covers best practices in SQL writing, warehouse resource management, data loading strategies (e.g., using MERGE), and access control setup. It is essential for auditing existing deployments, onboarding new users, or performing code reviews to ensure cost efficiency and data integrity.