performance-optimizer

Profile software systems and resolve performance bottlenecks with targeted optimizations.

24|3|Updated Nov 25, 2025
One-click install
npx skills add https://github.com/nguyenthienthanh/aura-frog --skill performance-optimizer-nguyenthienthanh
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: performance-optimizer
Source: https://github.com/nguyenthienthanh/aura-frog/tree/main/aura-frog/skills/performance-optimizer
Command: npx skills add https://github.com/nguyenthienthanh/aura-frog --skill performance-optimizer-nguyenthienthanh

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Slow applications lead to poor user experience, increased operational costs, and lost revenue. This Skill provides a structured, expert-guided approach to identify, analyze, and resolve performance bottlenecks across frontend, backend, and database layers, ensuring optimal application speed.

Core Features & Use Cases

  • Comprehensive Profiling Strategy: Guides the use of tools like Lighthouse (frontend), APM (backend), and EXPLAIN (database) to pinpoint performance issues.
  • Frontend Optimization: Offers techniques such as lazy loading, code splitting, debouncing, and memoization to improve Core Web Vitals.
  • Backend & Database Optimization: Provides solutions for N+1 queries, missing indexes, unbounded queries, and effective caching strategies.
  • Use Case: When a user reports a slow page load, use this skill to profile the frontend with Lighthouse, identify the Largest Contentful Paint (LCP) bottleneck, and suggest lazy loading images and code splitting to improve speed.

Quick Start

Analyze the performance of the user dashboard page and suggest frontend optimizations

Frequently Asked Questions about performance-optimizer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I identify performance bottlenecks in my application?

Identify performance bottlenecks by profiling your application with tools like Lighthouse for frontend, APM for backend, and EXPLAIN for database queries. Measure baseline metrics such as LCP, response time, and query time before making changes to pinpoint where latency occurs across layers.

What's the best way to optimize frontend performance and Core Web Vitals?

Optimize frontend performance by implementing lazy loading, code splitting, debouncing, and memoization to improve Core Web Vitals metrics like LCP, FID/TTI, and CLS. Apply these techniques after profiling with Lighthouse to address identified bottlenecks.

How do I fix slow database queries and improve backend performance?

Improve backend performance by addressing N+1 queries, adding missing indexes, eliminating unbounded queries, and implementing effective caching strategies. Use database profiling tools like EXPLAIN to measure query time and validate improvements.

Why should I measure performance before optimizing?

Baseline measurement before optimization ensures you focus on the 80/20 rule, tackling actual bottlenecks rather than guessing. Tracking metrics before and after changes delivers measurable performance gains and prevents wasted effort on low-impact optimizations.

Can I use this approach across frontend, backend, and database layers?

Yes, this profiling-driven workflow applies across frontend, backend, database, and memory profiling in development, staging, and production environments. Use layer-specific tools—Lighthouse, APM, EXPLAIN—to measure and optimize each tier consistently.

What metrics should I track to measure performance improvements?

Track metrics including LCP, FID/TTI, and CLS for frontend; response time and throughput for backend; and query time for database layers. Metrics-driven tracking validates optimization effectiveness and guides prioritization across your tech stack.