Plan and execute database schema migrations with up/down scripts, zero-downtime DDL patterns, seed data management, rollback procedures, and ORM vs raw SQL decision framework. Covers Postgres, MySQL, and SQLite.

Tree of Thought evaluation, multi-dimensional weighted scoring, trade-off analysis, and decision matrix generation for technical decisions. Trigger: "scenario analysis", "trade-off", "decision matrix", "weighted scoring", "tree of thought", "compare options".

Systematic scan across 10 friction categories affecting development velocity. Trigger: "detect friction", "what's slowing us down", "friction analysis", "velocity blockers".

Produces structured functional specifications including use cases, business rules, and complexity/risk matrices. Trigger: "write the spec", "functional requirements", "use case analysis".

Phased execution plans with dependencies, checkpoints, rollback strategies, and file change plans. Trigger: plan implementation, create phases, design rollback, file change plan.

Post-incident analysis, timeline reconstruction, contributing factor identification, and prevention recommendations. Trigger: analyze incident, post-mortem, outage review, incident timeline, blameless review.

Compute, network, storage topology, HA/DR design, IAM strategy, and landing zone architecture for production systems. Trigger: "infrastructure architecture", "landing zone", "HA/DR", "network topology", "compute", "IAM".

Horizontal/vertical scaling analysis, stateless/stateful assessment, and capacity planning. Trigger: "assess scalability", "can this scale", "scaling strategy", "capacity planning".

Docker, Kubernetes, IaC topology, and deployment architecture mapping. Trigger: "map infrastructure", "Docker analysis", "K8s topology", "IaC review".

Pre-processes raw inputs through error detection, intent amplification, and structured interpretation layers. Trigger: "analyze this input", "interpret requirements", "clarify intent".

Captures corrections, applies learnings across sessions, and prevents regression of past mistakes. Trigger: "lesson learned", "capture correction", "track mistake", "prevent regression", "apply learnings".

Generate Supabase project with auth, RLS policies, edge functions, type generation. Use when user asks to "scaffold a Supabase project".

Generate production-ready React project with TypeScript, Tailwind, testing, CI/CD. Use when user asks to "scaffold a React app".

Generate Next.js 15 App Router project with auth, database, API routes. Use when user asks to "scaffold a Next.js app".

Code quality index, change risk assessment, and maintainability scoring. Trigger: "score maintainability", "code quality index", "change risk", "maintainability".

Capability maturity evaluation using CMMI, DORA, and custom models for software engineering practices. Use when user asks to "assess maturity".

Generates C4, sequence, flow, and architecture diagrams in Mermaid syntax for technical documentation. Trigger: "diagram", "mermaid", "C4 diagram", "sequence diagram", "flowchart", "architecture diagram".

Decomposes monoliths into microservices using bounded contexts, DDD, and service boundary analysis. Trigger: "decompose microservices", "bounded contexts", "service boundaries", "DDD decomposition", "split monolith".

Plans system migrations using strangler fig, blue-green, data migration, and re-platforming strategies. Trigger: "plan migration", "strangler fig", "re-platform", "data migration", "legacy modernization".

Designs frontend and backend state management patterns, caching layers, and synchronization strategies. Trigger: "state management", "frontend state", "backend state", "state synchronization", "global state".