mao-sovereign-architect

Analyze and optimize database queries: EXPLAIN ANALYZE plan reading, index strategies (B-tree, GIN, GiST, partial, composite), N+1 detection in ORM code, connection pooling, and query plan regression testing.

Design and implement real-time data synchronization: WebSocket vs SSE vs long polling decision, Supabase Realtime, Firebase RTDB, optimistic updates, conflict resolution, and connection resilience patterns.

Plans release trains, semantic versioning strategy, changelog generation, and release coordination. Trigger: "release plan", "versioning strategy", "changelog", "release train", "shipping schedule".

Automated tech stack, framework, and entry point detection from repository structure. Trigger: "scan repo", "detect stack", "what technologies", "analyze repository".

Designs resilience patterns including circuit breakers, retries, bulkheads, timeouts, and chaos engineering practices. Trigger: "resilience design", "circuit breaker", "fault tolerance", "chaos engineering", "bulkhead pattern", "retry strategy".

Implement production-grade responsive design: breakpoint strategy, fluid typography with clamp(), container queries, responsive images with srcset/sizes, and cross-device testing methodology. Use when user asks to "make responsive", "implement responsive design", or "fix layout on mobile".

Identifies, assesses, and manages technical and project risks with mitigation strategies, monitoring plans, and contingency protocols. Trigger: "risk analysis", "risk register", "mitigation plan".

Severity times likelihood risk matrix generation with mitigation priorities. Trigger: "score risks", "risk matrix", "risk assessment", "severity analysis".

Designs proof-of-concept roadmaps with sprint breakdowns, prerequisites, gates, team composition, budget, and risk registers. Trigger: "PoC plan", "proof of concept", "sprint breakdown".

Designs undo plans for each deployment phase, including data migration reversibility and feature flag fallbacks. Trigger: "rollback plan", "undo strategy", "how to revert", "migration reversibility".

Systematic root cause tracing from symptoms through causal chains to actual causes. Trigger: "root cause analysis", "why is this failing", "trace the cause", "5 whys".

Generate Angular 18+ project with Signals, standalone components, SSR, testing. Use when user asks to "scaffold an Angular app".

Generate REST API with Express/Fastify, OpenAPI spec, validation, tests. Use when user asks to "scaffold a REST API".

Scaffold a production-parity Docker development environment: multi-service Compose, volume mounts, networking, health checks, dev containers, and secrets management. Eliminates "works on my machine" at the infrastructure layer.

Scaffold a production-ready Firebase project: Firestore data modeling, Security Rules, Cloud Functions v2, emulator suite, hosting config, and CI/CD. Covers auth flows, subcollection design, and multi-environment strategy.

Scaffold a production monorepo: Nx vs Turborepo decision, workspace structure, shared packages, CI matrix builds, versioning strategy (fixed vs. independent), and dependency graph visualization.

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

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

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

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