optimization▌

Guides conversion rate optimization (CRO): increasing the percentage of visitors who complete desired actions. Higher conversion rates mean increased revenue, reduced CAC, and better ROI. Use this skill when optimizing funnels, running experiments, or reducing friction on high-traffic pages.

Profile and optimize Python code using cProfile, memory profilers, and performance best practices. \n \n Covers CPU profiling with cProfile, line-by-line profiling with line_profiler, memory tracking with memory_profiler, and production profiling with py-spy \n Includes 20+ optimization patterns: list comprehensions, generators, string concatenation, dictionary lookups, NumPy vectorization, caching, multiprocessing, and async I/O \n Provides database optimization techniques including batch opera

Diagnose and fix performance bottlenecks across React frontends and database backends. \n \n Covers frontend optimization: React.memo, useMemo, useCallback, lazy loading, code splitting, image optimization, and bundle analysis \n Includes backend strategies: N+1 query fixes, database indexing, Redis caching, and API compression \n Provides measurement tools and workflows using Lighthouse, Web Vitals, and webpack-bundle-analyzer \n Emphasizes profiling first, incremental improvements, and continu

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries. \n \n Covers EXPLAIN plan analysis with key metrics (Seq Scan, Index Scan, cost, rows, execution time) and five index types (B-Tree, Hash, GIN, GiST, BRIN) for different query patterns \n Includes five core optimization patterns: eliminating N+1 queries, cursor-based pagination, efficient aggregation, subquery transformation, and batch operations \n Provides advanced techniques like materialized v

Universal SQL performance optimization across MySQL, PostgreSQL, SQL Server, Oracle, and other databases. \n \n Covers query analysis, index strategy design, subquery optimization, and JOIN tuning with before/after examples for each technique \n Addresses common anti-patterns including SELECT *, function calls in WHERE clauses, inefficient pagination, and correlated subqueries \n Provides database-agnostic guidance on batch operations, temporary tables, covering indexes, and partial indexes \n I

Optimizes agent context setup for improved output quality during coding sessions.

Optimize web performance through Core Web Vitals, modern browser APIs (View Transitions, Speculation Rules), and framework-specific techniques.

Identify cost savings across Azure subscriptions through resource analysis, utilization metrics, and actionable optimization recommendations. \n \n Discovers orphaned resources (unattached disks, unused NICs, idle gateways) and over-provisioned services using Azure Quick Review \n Queries actual costs from Azure Cost Management API and utilization data from Azure Monitor to support rightsizing recommendations \n Generates prioritized optimization reports with estimated savings, implementation co

This comprehensive skill provides complete ASO capabilities for successfully launching and optimizing mobile applications on the Apple App Store and Google Play Store.

Memoization, code splitting, and virtualization patterns for optimizing React application performance. \n \n Covers four core optimization techniques: memoization (React.memo, useMemo, useCallback), code splitting with lazy/Suspense, virtualization for large lists, and state management strategies to minimize render cascades \n Includes React 18+ concurrent features (useTransition, useDeferredValue) for improved responsiveness and perceived performance \n Provides profiling workflow using React D