Skill UI

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 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.

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.

This guide provides comprehensive instructions on managing performance and concurrency within Snowflake. It covers key concepts like warehouse sizing, multi-cluster configuration, and detecting query queuing issues. Users learn how to right-size resources and implement application-level rate limiting to prevent throttling and optimize data warehouse throughput for complex analytics workloads.

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.

A comprehensive guide to authoring, optimizing, and validating Power Query M expressions used within semantic model partitions. This resource covers crucial topics such as maintaining query folding for performance, applying early filtering and column pruning, and leveraging the Power Query API for robust data validation and debugging.