performance

Profile production workloads to identify and eliminate performance bottlenecks.

Updated Jan 23, 2026
One-click install
npx skills add https://github.com/jnPiyush/AI-Squad --skill performance-jnpiyush
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: performance
Source: https://github.com/jnPiyush/AI-Squad/tree/main/ai_squad/skills/performance
Command: npx skills add https://github.com/jnPiyush/AI-Squad --skill performance-jnpiyush

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams systematically improve the performance of software systems by identifying bottlenecks and applying proven optimization strategies across code, data access, and infrastructure.

Core Features & Use Cases

  • Profiling-first approach to locate hotspots in production or staging environments.
  • Optimizations across Async/Await patterns, caching, memory usage, and database access to reduce latency and increase throughput.
  • Use cases: speeding up API endpoints, reducing DB load, or shrinking memory footprint in long-running services.

Quick Start

Start by profiling a running service to pinpoint the top bottlenecks, then implement targeted optimizations and re-profile to verify gains. Steps: run a profiler on the service, identify hot methods, apply async/await where appropriate, add caching or indexing, and re-test under representative load.

Frequently Asked Questions about performance

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

FAQPage Schema
How do I identify performance bottlenecks in a microservices architecture?

Identify performance bottlenecks by running a profiler on your running service to pinpoint hot methods in production or staging. This profiling-first approach locates hotspots across API latency, database queries, and memory usage before applying targeted optimizations.

What's the best way to reduce API latency and database load in web apps?

Reduce API latency and database load by applying targeted optimizations such as async/await patterns, caching, and database indexing. Implement these after profiling to locate hotspots, then re-test under representative load to verify throughput gains.

Can I use async/await and caching to optimize memory usage in background jobs?

Yes, you can optimize memory usage in background jobs by applying async/await patterns and caching. Profiling the long-running service first helps pinpoint memory hotspots so you can apply targeted optimizations and shrink the memory footprint effectively.

How do I measure and verify performance improvements in production workloads?

Measure performance improvements in production workloads by re-profiling the service after applying optimizations and re-testing under representative load. Careful measurement quantifies improvements across API latency, database queries, and memory usage to verify gains.

When should I profile my application to optimize database queries and throughput?

Profile your application when you need to systematically improve performance by locating hotspots in database access and query latency. Profiling first ensures you apply targeted optimizations like indexing and caching where they deliver measurable throughput improvements.

Does this performance optimization approach work for both web apps and microservices?

Yes, this performance optimization approach works across microservices, web apps, and background jobs. It systematically targets production workloads including API latency, database queries, and memory usage by applying profiling, async/await patterns, caching, and indexing strategies.