Skill UI

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.

Enables regression modeling via the regression-analysis-tool plugin by analyzing datasets, choosing linear or polynomial fits, validating models, and reporting metrics so users can predict outcomes or explore variable relationships.

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.

This skill guides you through integrating PostHog's Customer Data Platform (CDP) features. It covers setting up webhooks to trigger real-time actions (e.g., syncing to CRM, sending notifications) when specific user events occur. Furthermore, it demonstrates how to query event data using the Events API and perform complex funnel analysis using HogQL, allowing for deep, custom insights into user behavior.

This skill builds and executes automated pipelines to clean, validate, and transform data for machine learning, covering ETL workflows, error handling, and quality reporting so Claude can deliver analysis-ready datasets.

This skill simulates the role of a quantitative analyst, providing comprehensive tools for building complex financial models, backtesting trading strategies, and analyzing market data. It covers advanced topics like portfolio optimization (Markowitz, Black-Litterman), calculating risk metrics (VaR, Sharpe ratio), and performing statistical arbitrage. Ideal for quantitative finance professionals needing rigorous data analysis, robust backtesting, and risk-adjusted performance evaluation.

Provides automated regression analysis guidance, best practices, code snippets, and validation for SQL, BI, visualization, and statistical workflows in data analytics projects.

Automated retention calculator guidance within data analytics workflows, assisting with SQL, visualization, BI, and statistical analysis to produce and validate production-ready outputs for retention insights.

This skill provides a comprehensive, expert guide to the entire reverse engineering lifecycle. It covers advanced techniques for binary analysis, including static analysis (disassembly, metadata extraction, control flow mapping) and dynamic analysis (API hooking, memory tracing). Mastery includes utilizing industry-leading tools such as IDA Pro, Ghidra, radare2, and specialized frameworks like pwntools and angr. The methodology is structured for secure research, CTF challenges, and vulnerability assessment, emphasizing best practices and ethical use.

Automates clustering workflows on supplied datasets with K-means, DBSCAN, or hierarchical algorithms, handling preprocessing, validation, metrics, and visualizations to expose groupings and anomalies.

An advanced skill for Scrum Masters that uses Python scripts to analyze raw sprint data exported from tools like Jira. It provides comprehensive insights including Monte Carlo velocity forecasting, a multi-dimensional team health score (0-100), and tracking of action items and recurring themes from retrospectives. Ideal for process improvement, sprint planning, and stakeholder reporting.

This skill provides systematic patterns and best practices for transforming slow database queries into high-performance operations. It covers techniques like proper indexing, query plan analysis (e.g., using EXPLAIN), schema design improvements, and resolving common issues like N+1 query problems. Use it to debug performance bottlenecks, reduce database load, and ensure scalable application backends.