Performance Optimization Skill

Performance optimization across layers involves analyzing bottlenecks in database queries, API response times, and frontend bundle sizes, then applying targeted improvements. This skill automates that analysis and routes specific operations to each layer—database tuning, backend caching, bundle reduction—then validates gains with benchmarks.

Yes. The skill analyzes database query performance and frontend bundle size using tools like lighthouse, webpack-bundle-analyzer, and vite-bundle-visualizer. It identifies bottlenecks across layers and applies layer-specific optimizations, then measures improvements through load tests and rendering benchmarks.

Start by analyzing your application across all layers to establish a baseline. The skill runs benchmarks using k6 for load testing and lighthouse for rendering metrics, then applies optimizations and re-measures to detect gains and prevent regressions.

You'll need Node.js, npm, k6 for load testing, lighthouse for rendering audits, and bundle analyzers: webpack-bundle-analyzer, vite-bundle-visualizer, and rollup-plugin-visualizer. For databases, psql or mysql; bc for calculations. These enable analysis and optimization across infrastructure, backend, and frontend.

Yes. The skill targets optimization across all four layers: database, backend, frontend, and infrastructure. It provides layer-specific operations for infrastructure scaling and backend API tuning alongside database query optimization and frontend bundle reduction.

The skill runs benchmarking and load tests after each optimization phase using k6 and lighthouse. These workload benchmarks validate that improvements persist and catch regressions, ensuring optimizations remain effective over time.