nw-query-optimization
SQL and NoSQL query optimization techniques, indexing strategies, execution plan analysis, JOIN algorithms, cardinality estimation, and database-specific query patterns
SQL and NoSQL query optimization techniques, indexing strategies, execution plan analysis, JOIN algorithms, cardinality estimation, and database-specific query patterns
Dispatches a single roadmap step to a specialized agent for TDD execution. Use when implementing a specific step from a roadmap.json plan.
CI/CD pipeline design methodology, deployment strategies, GitHub Actions patterns, and branch/release strategies. Load when designing pipelines or deployment workflows.
Step-by-step workflow for converting bloated command files to lean declarative definitions
DELIVER wave orchestration workflow -- 9 phases from baseline to finalization. Load when user invokes *deliver command. Covers state tracking, smart skip logic, retry, resume, and quality gate enforcement.
4-phase discovery workflow with decision gates, phase transitions, success metrics, and state tracking
Deprecated: chain status placeholder; use orbiter_chains for lists.
Comprehensive architecture patterns, methodologies, quality frameworks, and evaluation methods for solution architects. Load when designing system architecture or selecting patterns.
Critique dimensions, severity framework, verdict decision matrix, and review output format for documentation assessment reviews
Architecture quality critique dimensions for peer review. Load when invoking solution-architect-reviewer or performing self-review of architecture documents.
Architecture quality critique dimensions for peer review. Load when performing architecture document reviews.
Reviewer critique dimensions for peer review - implementation bias detection, test quality validation, completeness checks, and priority validation
Documentation collapse anti-patterns - detection rules, bad examples, and remediation strategies for type-mixing violations
Gathers knowledge from web and files, cross-references across multiple sources, and produces cited research documents. Use when investigating technologies, patterns, or decisions that need evidence backing.
Creates evidence-based documentation following DIVIO/Diataxis principles. Use when writing tutorials, how-to guides, reference docs, or explanations.
Review dimensions and bug patterns for journey artifact reviews
Requirements quality critique dimensions for peer review - confirmation bias detection, completeness validation, clarity checks, testability assessment, and priority validation
Critique dimensions and scoring for research document reviews