Data & AI

Comprehensive PostgreSQL configuration and usage analysis for Rails applications. Use when Claude Code needs to analyze a Rails codebase for database performance issues, optimization opportunities, or best practice violations. Detects N+1 queries, missing indexes, suboptimal database configurations, anti-patterns, and provides actionable recommendations. Ideal for performance audits, optimization tasks, or when users ask to "analyze the database", "check for N+1 queries", "optimize PostgreSQL", "review database performance", or "suggest database improvements".

Analyzes writing-ecosystem traces to fix style.yaml, template.yaml, and tools.yaml based on quality issues found in production runs.

Comprehensive expertise for working with Microsoft's GenAIScript framework - a JavaScript/TypeScript-based system for building automatable LLM prompts and AI workflows. Use when creating, debugging, or optimizing GenAIScript scripts, implementing prompts-as-code, working with tools and agents, processing files (PDF, CSV, DOCX), defining schemas, or building AI automation workflows.

Master data science and machine learning with Python, TensorFlow, PyTorch, and MLOps. Learn to build predictive models, deep learning systems, and production ML pipelines.

전체 SEMO 패키지 통합 품질 감사. Use when (1) 전체 패키지 품질 점검, (2) Agent/Skill/Command 표준 준수 검토, (3) 비효율적 구조 탐지, (4) 정기 감사 수행.

Configure FastAPI for Vercel deployment.Bundled Resources: Includes 'vercel.json', CORSMiddleware, Python logging, Pydantic models, and personalization endpoints.

Build MCP (Model Context Protocol) servers for CasareRPA integrations using Python FastMCP. Covers server structure, tool design, error handling, and RPA-specific patterns. See references/ for detailed guides. Use when: creating MCP servers, tool design, error handling, RPA-specific patterns, FastMCP, Context logging, lifespan hooks.

Diagnose and solve common beginner programming mistakes in Flask or Sinatra development with detailed explanations

OPA resource governance policies enforcing CPU/memory limits, ResourceQuota compliance, LimitRange validation, and storage constraints.

Systematically diagnoses and fixes failures through hypothesis-driven investigation. Auto-activates when user reports something broken, failing, erroring, not working, crashed, or buggy. Spawns debugger agent for binary search isolation and minimal reproduction.

Use when creating or editing skills, before deployment, to verify they work under pressure and resist rationalization - applies RED-GREEN-REFACTOR cycle to process documentation by running baseline without skill, writing to address failures, iterating to close loopholes

Discover and analyze lien positions from AcclaimWeb and RealTDM to detect HOA foreclosures and senior mortgage survival

Automated release coordination and deployment with swarm orchestration for seamless version management, testing, and deployment across multiple packages. Use for release pipelines, version coordination, deployment orchestration, and release documentation.

Follow consistent project structure, version control practices, environment configuration, code review processes, and development conventions across the entire application. Use this skill when organizing project files and directories, when writing commit messages or creating pull requests, when managing environment variables and configuration, when participating in code reviews, when defining testing requirements, when using feature flags, when maintaining changelogs, when documenting setup instructions, or when establishing consistent development practices across the team.

Use when creating or developing, before writing code or implementation plans - refines rough ideas into fully-formed designs through collaborative questioning, alternative exploration, and incremental validation. Don't use during clear 'mechanical' processes

Use when writing Rails tests - enforces fixtures-only, integration-style controller tests, Current context setup, simple naming, and Minitest syntax

Process large documents (200+ pages) with structure preservation, intelligent parsing, and memory-efficient handling. Use when working with complex formatted documents, multi-level hierarchies, or when you need to extract structured data from large files like PDFs, DOCX, or text files.

Extract and analyze security controls from OSCAL catalogs, profiles, and SSPs. Use this skill to get detailed information about control hierarchies, statements, parameters, and implementation status for compliance analysis.

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. Provides intelligent header detection and semantic column mapping for robust data import.

Analyze training patterns, performance, and physiological data using advanced computational models.AUTO-ACTIVATES when user asks about:- Training status/progress ("How am I doing?", "How's my training?")- Load/overtraining ("Am I overtraining?", "Is my load too high?")- Performance questions ("Why did I fade?", "What's limiting me?")- Specific run analysis ("Why was my HR high?", "What happened yesterday?")- Race readiness ("Am I ready?", "Will I make my goal?")- Physiological zones ("What are my zones?", "What's my threshold?")- Recovery/freshness ("Should I run today?", "Am I recovered?")- Patterns/causation ("What's causing...", "What predicts my best runs?")PROACTIVELY WARNS when detecting:- ACWR > 1.3 (load spike)- TSB < -25 (fatigue accumulation)- Correlation shifts (relationship changes)- Form breakpoints earlier than usual- Recovery decline between intervals