optimization▌

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

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

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

Context optimization extends the effective capacity of limited context windows through strategic compression, masking, caching, and partitioning. The goal is not to magically increase context windows but to make better use of available capacity. Effective optimization can double or triple effective context capacity without requiring larger models or longer contexts.

Context optimization extends the effective capacity of limited context windows through strategic compression, masking, caching, and partitioning. The goal is not to magically increase context windows but to make better use of available capacity. Effective optimization can double or triple effective context capacity without requiring larger models or longer contexts.

Optimizes application performance by identifying and fixing bottlenecks based on profiling data.

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