performance-audit_skill

Overview

This skill provides a comprehensive performance audit service to identify bottlenecks, optimization opportunities, and scalability issues across your codebase and architecture. It delivers prioritized, actionable findings with code-level recommendations and expected improvement estimates. The output is a structured audit report you can use to drive immediate fixes and longer-term optimization roadmaps.

How this skill works

The auditor statically analyzes code patterns, database queries, resource usage, concurrency, memory behavior, frontend assets, and infrastructure configuration. It identifies hotspots like N+1 queries, blocking operations, unbounded memory growth, inefficient loops, and missing indexes. For each finding it provides exact locations, before/after code examples, impact severity, and estimated performance gains. The skill also formulates a prioritized remediation plan and measurement checklist to validate improvements.

When to use it

• Investigating slow page loads, high latency API responses, or increased error rates
• Before major releases to validate performance of new features
• When scaling capacity and needing to find horizontal/vertical bottlenecks
• During refactors to prevent regressions or introduce caching and batching
• To establish observability, performance budgets, and SLO-driven alerts

Best practices

• Measure before and after every change; collect baseline metrics with profiling tools
• Prioritize fixes by user-facing impact and implementation cost
• Prefer cache-aside and short TTLs with explicit invalidation where data changes frequently
• Batch and eager-load database access to eliminate N+1 patterns
• Avoid blocking the main event loop; offload CPU work to workers or background jobs
• Instrument critical paths with metrics, logs, and distributed traces

Example use cases

• Audit a web service to locate DB queries missing indexes and provide exact file/line references
• Analyze a React or Vue app to reduce bundle size, identify render hotspots, and suggest code splitting
• Find connection pool leaks and thread-safety issues in backend services and provide fixes with expected throughput improvements
• Produce a remediation roadmap that lists quick wins (compression, caching) and long-term changes (sharding, streaming SSR) with estimated gains
• Validate memory leaks in long-running processes and recommend object pooling, eviction policies, or GC tuning