performance-optimizer

Identifies and fixes performance bottlenecks in code, databases, and APIs with before-and-after measurement.

Updated Jan 4, 2026
One-click install
npx skills add https://github.com/quinc-dev/qt2026 --skill performance-optimizer-quinc-dev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: performance-optimizer
Source: https://github.com/quinc-dev/qt2026/tree/main/.agents/skills/performance-optimizer
Command: npx skills add https://github.com/quinc-dev/qt2026 --skill performance-optimizer-quinc-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Slow applications, laggy pages, and sluggish APIs frustrate users, but optimizing without data wastes effort. This Skill provides a structured measure-optimize-verify workflow so every performance fix is targeted at the real bottleneck and its impact is quantified. ## Core Features & Use Cases - Bottleneck Profiling: Guides use of Chrome DevTools, Node.js --prof, and SQL EXPLAIN ANALYZE to locate slow code paths. - Database Optimization: Fixes N+1 queries, missing indexes, SELECT * over-fetching, and missing pagination. - API and Frontend Fixes: Applies caching, parallel async operations, payload trimming, memoization, code splitting, and image optimization. - Use Case: A user reports the dashboard takes 5 seconds to load. The Skill profiles the page, finds an N+1 database query, rewrites it with a JOIN, and measures the improvement from 2341ms to 23ms. ## Quick Start Use @performance-optimizer to find and fix the bottlenecks slowing down my user dashboard, measuring performance before and after each change.

Frequently Asked Questions about performance-optimizer

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

FAQPage Schema
How do I find performance bottlenecks in my application?▼

Profile first before optimizing. Use Chrome DevTools Performance tab for frontend long tasks, node --prof for Node.js execution profiling, and EXPLAIN ANALYZE for slow database queries. Fix the slowest component first for the biggest impact.

How to fix N+1 database queries in JavaScript?▼

Replace per-record queries inside loops with a single query using a JOIN or ORM populate call. For example, use db.users.find().populate('posts') instead of fetching posts for each user individually, reducing N+1 queries to one.

What are quick wins for improving website performance?▼

High-impact quick wins include adding database indexes, enabling gzip compression, caching expensive operations, lazy loading images and components, using a CDN, minifying assets, paginating large datasets, and converting images to WebP.

How do I detect and fix memory leaks in React?▼

Memory leaks often come from event listeners or subscriptions not cleaned up in useEffect. Always return a cleanup function, such as removing the scroll listener, so resources are released when the component unmounts.

When should I not optimize code performance?▼

Avoid premature optimization and micro-optimizations that save milliseconds on an already fast path. Optimize only when measurements show a real bottleneck, and never sacrifice code readability for negligible speed gains.