Search Skills

Analyzes git changes, groups into atomic commits, and generates conventional commit messages for clean version history.

Intelligently merges multiple CSV/Excel files with column matching, deduplication, and conflict resolution to consolidate diverse data sources.

Optimizes LLM cost and latency via caching, model selection, batching, and prompt optimization, delivering cost breakdowns and performance recommendations.

Provides universal patterns for detecting common security vulnerabilities (e.g., hardcoded secrets, SQL injection) across programming languages.

Scans files for secrets (tokens, keys) without revealing content, redacts them in-place, and determines publish gate status for secure publishing workflows.

Expert guidance for SQLite database operations using better-sqlite3 Node.js driver, covering setup, queries, transactions, migrations, and TypeScript integration.

Automates downloading audio and video from multiple websites with format selection, subtitles, and playlist support.

Analyzes log files for error detection, issue investigation, and application behavior through filtering and pattern matching.

Analyzes binary files for malicious content, extracts technical details, and provides threat assessment to determine file safety.

Core NumPy operations for array creation, dtype management, shape manipulation, and memory-efficient data views.

Efficiently extracts specific fields from JSON files using jq, reducing data processing overhead by avoiding full file reads.

Analyzes video content using Google's Gemini API, providing descriptions, transcriptions, timestamp references, and YouTube URL processing for extended video understanding.

Starts and tracks long-running background processes like servers or watchers, ensuring managed execution and monitoring.

Converts legacy setup.py/setup.cfg to pyproject.toml for uv compatibility, with proper dependency groups for development and testing workflows.

Optimizes SQL and NoSQL query performance by analyzing execution plans, suggesting indexes, and rewriting queries for databases including PostgreSQL and MongoDB.

Deploys machine learning models to production using Flask, FastAPI, Docker, and cloud platforms (AWS, GCP, Azure).

Optimizes LLM deployment infrastructure with serving frameworks, quantization, and batching for low-latency inference.

Comprehensive guide to Python async/await patterns, best practices, and anti-patterns for efficient asynchronous code development.

Ensures code correctness by requiring verification commands and output confirmation before claiming completion, fixing, or passing status in development workflows.

Extracts specific XML elements from documents while preserving full structure, using Python and optional xmllint formatting.

Expert guidance for regression analysis, statistical modeling, and outlier detection in Python using statsmodels, scikit-learn, and PyOD.

Supports R data analysis, visualization, and statistical workflows using tidyverse, ggplot2, and reproducible research practices with R scripts and Quarto documents.

Provides foundational statistical, probability, and linear algebra tools essential for data science applications and analysis.

Automates interaction with terminal-based tools (e.g., git, vim) in tmux sessions using send-keys, enhancing terminal workflow efficiency.