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.

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.

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.

Test strategy architecture, automation infrastructure, quality gates, quality metrics dashboards, and shift-left quality practices. Trigger: "quality engineering", "quality gates", "quality metrics", "automation architecture", "shift-left quality".

Test strategy architecture, automation infrastructure, quality gates, quality metrics dashboards, and shift-left quality practices. Trigger: "quality engineering", "quality gates", "quality metrics", "automation architecture", "shift-left quality".

Design and implement Progressive Web App architecture: service worker caching strategies, offline patterns, Web Push notifications, install prompt UX, background sync, and Workbox configuration for production.

Design and implement Progressive Web App architecture: service worker caching strategies, offline patterns, Web Push notifications, install prompt UX, background sync, and Workbox configuration for production.

N+1 query detection, bottleneck identification, and resource usage analysis. Trigger: "profile performance", "find bottlenecks", "N+1 queries", "resource usage".

N+1 query detection, bottleneck identification, and resource usage analysis. Trigger: "profile performance", "find bottlenecks", "N+1 queries", "resource usage".

Load testing design, capacity planning, bottleneck analysis, caching strategies, and SLA engineering. Trigger: "performance engineering", "load testing", "capacity planning", "bottleneck", "caching", "SLA", "latency".

Load testing design, capacity planning, bottleneck analysis, caching strategies, and SLA engineering. Trigger: "performance engineering", "load testing", "capacity planning", "bottleneck", "caching", "SLA", "latency".

Defines Core Web Vitals targets, latency budgets, bundle size limits, and performance regression gates. Trigger: "performance budget", "core web vitals", "bundle size", "latency budget", "performance targets".

Defines Core Web Vitals targets, latency budgets, bundle size limits, and performance regression gates. Trigger: "performance budget", "core web vitals", "bundle size", "latency budget", "performance targets".

Profiling-based identification of hot paths, resource constraints, and throughput limiters. Trigger: "find bottlenecks", "hot paths", "performance profiling", "throughput limits".

Profiling-based identification of hot paths, resource constraints, and throughput limiters. Trigger: "find bottlenecks", "hot paths", "performance profiling", "throughput limits".

Engineers quality formatting with ghost menus, progressive disclosure, and excellence standards for technical artifacts. Trigger: "format output", "ghost menu", "progressive disclosure", "output quality", "excellence standards".

Engineers quality formatting with ghost menus, progressive disclosure, and excellence standards for technical artifacts. Trigger: "format output", "ghost menu", "progressive disclosure", "output quality", "excellence standards".

Logging, metrics, and tracing completeness analysis across the system. Trigger: "observability gaps", "logging analysis", "metrics coverage", "tracing completeness".

Logging, metrics, and tracing completeness analysis across the system. Trigger: "observability gaps", "logging analysis", "metrics coverage", "tracing completeness".

Designs logging, metrics, and distributed tracing architectures using OpenTelemetry and observability platforms. Trigger: "observability design", "logging architecture", "metrics strategy", "distributed tracing", "OpenTelemetry".