Validates CloudFormation templates for syntax, security, and best practices. Use when validating CloudFormation templates, checking for security issues, or ensuring compliance with best practices.
Analyzes cyclomatic and cognitive complexity, identifies overly complex functions. Use when assessing code complexity or identifying functions that need simplification.
Provides refactoring recommendations and step-by-step improvement plans. Use when planning refactoring, improving code structure, or reducing technical debt.
Holistic data engineering guidance combining ETL pipelines, data quality, and data architecture. Use when building data pipelines, designing data warehouses, or coordinating data engineering practices.
Implement data quality checks, validation rules, and monitoring. Use when ensuring data quality, validating data pipelines, or implementing data governance.
Design ETL/ELT pipelines with proper orchestration, error handling, and monitoring. Use when building data pipelines, designing data workflows, or implementing data transformations.
Strategic guidance for database schema design, indexing strategies, and query optimization. Use when designing databases, choosing database types, or making architectural decisions for data storage.
Optimize SQL queries for performance with indexing strategies, query rewriting, and execution plan analysis. Use when queries are slow, optimizing database performance, or analyzing query execution.
Design database schemas with proper normalization, relationships, constraints, and indexes. Use when creating database tables, modeling data relationships, or designing database structure.
Designs dbt data modeling strategies, testing approaches, and documentation standards. Use when designing dbt projects, organizing data models, or planning data transformation workflows.
Creates dbt models with proper layering (staging, marts), incremental strategies, and documentation. Use when creating dbt models, organizing data transformations, or implementing incremental models.
Generates dbt tests including schema tests, data quality tests, and freshness checks. Use when adding tests to dbt models or implementing data quality validation.
Strategic code review agent specializing in review standards, issue prioritization, and quality assessment. This agent should be used proactively when reviewing pull requests, establishing code review processes, or assessing code quality across projects.
Strategic debugging agent specializing in root cause analysis, debugging strategy, and investigation planning. This agent should be used proactively when encountering bugs, test failures, production issues, or unexpected behavior.
Strategic refactoring agent specializing in code improvement decisions, architectural enhancements, and technical debt management. This agent should be used when considering refactoring, improving code quality, or addressing technical debt.
Provides practical guidance for conducting thorough code reviews that identify issues early, promote knowledge sharing, and deliver constructive feedback. This skill should be used when reviewing pull requests, establishing team review standards, or mentoring developers on effective review practices.
Holistic DevOps guidance combining CI/CD pipelines, infrastructure automation, monitoring, and deployment strategies. Use when building deployment pipelines, automating infrastructure, or coordinating DevOps practices.