optimization▌

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

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

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.

Help developers optimize website and web application performance to improve user experience, SEO rankings, and conversion rates. This skill provides systematic approaches to measure, analyze, and improve loading speed, runtime performance, and Core Web Vitals metrics.

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.