skills.rest
PAISHU-AI
PAISHU-AICOMMUNITY
Explore all skills by this author →
GitHub

performance

Diagnose and improve software performance across frontend, backend, database, and network aspects.

Updated Aug 27, 2026
Search Tags:#performance optimization#database optimization#frontend optimization#performance diagnostics#backend optimization
One-click install
npx skills add https://github.com/PAISHU-AI/PAI-zong-NB --skill performance-paishu-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: performance
Source: https://github.com/PAISHU-AI/PAI-zong-NB/tree/main/skills/12-performance
Command: npx skills add https://github.com/PAISHU-AI/PAI-zong-NB --skill performance-paishu-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps diagnose and improve performance across various aspects of software, including frontend, backend, database, build, memory, CPU, and network, addressing issues like slow pages, APIs, SQL, large bundles, rendering delays, and resource spikes.

Core Features & Use Cases

  • Performance Diagnostics: Identify bottlenecks in performance such as network, rendering, CPU, memory, database, locks, queueing, cache, or external dependencies.
  • Frontend Optimization: Focus on LCP, INP, CLS, TTFB, bundle size, render blocking resources, hydration, and excessive re-rendering.
  • Backend Optimization: Address P95/P99 latency, throughput, timeout, retry behavior, connection pools, serialization, and queue depth.
  • Database Optimization: Utilize EXPLAIN plans, index usage, sort/hash cost, lock waits, and N+1 queries analysis.
  • Use Case: For instance, if a web application is experiencing slow response times, use this Skill to pinpoint the cause and optimize it.

Quick Start

Use the performance skill to diagnose and optimize the performance of your web application by following the provided workflow.

Frequently Asked Questions about performance

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

FAQPage Schema
How do I diagnose slow API response times and identify backend performance bottlenecks?▼

To diagnose slow API response times, this skill analyzes backend performance bottlenecks by evaluating P95/P99 latency, throughput, timeout behavior, connection pools, and queue depth to pinpoint causes.

What is the best way to optimize frontend rendering delays and reduce large bundle sizes?▼

Optimizing frontend rendering delays involves addressing LCP, INP, CLS, TTFB, bundle size, render blocking resources, and hydration to improve overall web application responsiveness.

How do I use EXPLAIN plans to fix database performance issues and N+1 queries?▼

You can fix database performance issues by analyzing EXPLAIN plans, evaluating index usage and sort/hash costs, checking lock waits, and resolving N+1 queries for better throughput.

What performance diagnostics should I run for high CPU usage and memory spikes?▼

For high CPU usage and memory spikes, performance diagnostics identify bottlenecks across CPU, memory, network, locks, and cache to establish symptoms and isolate root causes.

Can I optimize performance across my entire software stack or only specific layers?▼

You can optimize performance across the entire software stack, as this skill handles frontend, backend, database, build, memory, CPU, and network aspects to find the smallest change for maximum impact.

Related Skills

Explore More Software Engineering Skills→
dhofheinzdhofheinz
9

Performance Optimization Skill

Route performance optimization tasks across database, backend, frontend, and infrastructure layers.

Community
Advanced
chicongstchicongst
2

performance-review

Analyze slow endpoints and identify bottlenecks to reduce p99 latency.

Community
Advanced
fsollafsolla

performance-optimization

Enforce a measure-identify-fix-verify workflow for frontend and backend performance.

Community
Advanced
kunallimayekunallimaye

perf-core

Profile software performance with perf, valgrind, strace, and hyperfine.

Community
Intermediate