Skill UI

DeepTools is a comprehensive command-line toolkit for processing and analyzing high-throughput sequencing data. It supports workflows for ChIP-seq, RNA-seq, ATAC-seq, and other NGS experiments. Core capabilities include converting BAM files to normalized coverage tracks (bigWig), performing quality control (QC), sample correlation analysis, and generating publication-quality visualizations, such as heatmaps and profile plots across genomic regions.

Gtars is a high-performance toolkit written in Rust with Python bindings, designed for comprehensive analysis of genomic interval data. It provides specialized modules for overlap detection, generating coverage tracks (WIG/BigWig), tokenization for Machine Learning models, and detailed fragment analysis in single-cell genomics. Use it for robust bioinformatics pipelines and computational genomics research.

Vaex is a high-performance Python library designed for processing and visualizing enormous tabular datasets that exceed available RAM (gigabytes to terabytes). It excels at out-of-core DataFrame operations, lazy evaluation, fast statistical aggregation, and machine learning integration on massive datasets. Use it for analyzing large CSV, Parquet, or HDF5 files efficiently on a single machine, without memory constraints.

Builds a robust, automated workflow to export critical sales data—including forecasts, quota details, adjustments, and CRM totals—from Clari CRM to a designated data warehouse. The pipeline supports multiple targets like Snowflake, BigQuery, and PostgreSQL, ensuring that real-time revenue intelligence is available for advanced analytics and business reporting.

A comprehensive guide to setting up and securing API access for Clari. Learn how to generate API tokens, configure environment variables, and test connectivity to export critical revenue intelligence and forecast data to data warehouses like Snowflake or BigQuery. Includes steps for both standard Clari API and Copilot API integration.

This expert acts as a dedicated data analysis partner for Product Managers. It helps users explore data, write complex queries (e.g., SQL, BigQuery), analyze key metrics, and create structured dashboards. Use this tool when you need to derive actionable insights from complex datasets, compare user cohorts, or understand product performance trends to inform critical business decisions.

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 skill enforces an algorithm-first discipline, requiring the user to state the time and space complexity (Big-O), the intended data structure, and the core algorithm family before writing any complex code (loops, queries, recursion). It serves as a critical gatekeeper to prevent common performance pitfalls like O(n²) complexity, N+1 database queries, and brute-force implementation errors, significantly improving code robustness and efficiency.

Aria functions as a System Architect, responsible for establishing the definitive structural foundation of the entire system. She designs comprehensive blueprints covering the data model (schema, relationships, constraints), API contract specifications (endpoints, auth, pagination), modular file structure, and selection of core architectural design patterns. Her output ensures that no code is written without a rigorously defined, approved architectural plan, minimizing ambiguity and technical debt.

This skill guides you through a comprehensive, multi-phase interview to capture every necessary detail of a new project idea. It is designed to run BEFORE any code is written, forcing detailed specification gathering across purpose, features, data models, and technical constraints. The output is a clean, self-contained prompt.md file, ensuring subsequent development is based on solid, unambiguous requirements and preventing costly mistakes.

This skill converts vague business questions or monitoring needs into a complete, structured, and implementation-ready dashboard specification. It guides users to define key metrics (KPIs), chart types, axes, filters, and optimal layout, providing data engineers and BI developers with all necessary details to build the dashboard without ambiguity.

This skill is a comprehensive tool for managing and understanding SQL queries. It can explain complex SQL in plain English for non-technical stakeholders, optimize slow queries by identifying performance bottlenecks, generate functional SQL code from natural language prompts, and produce detailed query documentation and data dictionaries. Supports major dialects including PostgreSQL, MySQL, and BigQuery.