Agent skill · data analytics · daffy0208
Performance Optimizer
Optimize application performance and scalability. Use when investigating slow applications, scaling bottlenecks, or improving response times. Covers profiling, caching, database optimization, and frontend performance.
Why this skill is useful
Provides specific profiling techniques and optimization strategies for both frontend and backend performance that the AI wouldn't reliably generate on its own.
What it needs
Requires 0x, chrome, lighthouse installed locally. About 8k tokens when loaded. Last updated 2025-12-25. 33 stars on the source repository.
What this skill does
Performance Optimizer Make applications fast, scalable, and cost-efficient. Core Principle Measure first, optimize second. Don't guess at bottlenecks—profile, measure, then fix the slowest parts. Performance Budget Web Vitals (Target Metrics) --- Phase 1: Profiling & Measurement Goal: Identify actual bottlenecks, not perceived ones Frontend Profiling Chrome DevTools: React DevTools Profiler: Backend Profiling Node.js Profiling: Python Profiling: Database Profiling PostgreSQL: MongoDB: --- Phase 2: Database Optimization Add Strategic Indexes Eliminate N+1 Queries Query Optimization Connection Pooling --- Phase 3: Caching Strategy Multi-Layer Caching Redis Caching HTTP Caching Headers CDN Configuration --- Phase 4: Frontend Optimization Code Splitting & Lazy Loading Image Optimization Bundle Size Optimization React Performance --- Phase 5: Backend Optimization Async Background Processing API Response Optimization Rate Limiting --- Phase 6: Monitoring & Alerting Application Performance Monitoring (APM) Tools: Sentry: Error tracking + performance New Relic: Full-stack APM Datadog: Infrastructure + APM Vercel Analytics: Next.js optimized Custom Monitoring: Performance Dashboards --- Optimization Checklist Frontend ✅ [ ] Lighthouse score > 90 [ ] LCP < 2.5s [ ] FID < 100ms [ ] CLS < 0.1 [ ] Bundle size < 200KB (initial) [ ] Images optimized (WebP, lazy loading) [ ] Code splitting implemented [ ] Critical CSS inlined Backend ✅ [ ] P95 response time < 500ms [ ] Database queries indexed [ ] N+1 queries eliminated [ ] Connection pooling enabled [ ] Background jobs async [ ] Rate limiting configured [ ] API responses compressed Database ✅ [ ] Slow query log enabled [ ] All queries < 100ms (P95) [ ] Indexes on foreign keys [ ] Indexes on WHERE/ORDER BY columns [ ] Query explain plans reviewed [ ] Connection pool sized correctly Caching ✅ [ ] Redis/Memcached configured [ ] CDN for static assets [ ] HTTP cache headers set [ ] Cache hit ratio > 80% [ ] Cache invalidation strategy …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills daffy0208/performance-optimizer