skills.rest
dev-gios
dev-giosCOMMUNITY
Explore all skills by this author →
GitHub

qa-performance

Analyze code changes for performance anti-patterns like algorithmic complexity and database query efficiency.

1|Updated Mar 3, 2026
Search Tags:#code quality#performance#optimization#profiling#memory leaks#N+1 queries#algorithmic complexity
One-click install
npx skills add https://github.com/dev-gios/agent-teams-qa --skill qa-performance
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: qa-performance
Source: https://github.com/dev-gios/agent-teams-qa/tree/main/skills/qa-performance
Command: npx skills add https://github.com/dev-gios/agent-teams-qa --skill qa-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill identifies and helps resolve performance bottlenecks in code, ensuring applications run faster and consume fewer resources.

Core Features & Use Cases

  • Algorithmic Complexity Analysis: Detects inefficient algorithms like O(n^2) loops.
  • Database Query Optimization: Flags N+1 query patterns and inefficient SQL.
  • Memory Leak Detection: Identifies unreleased resources and memory leaks.
  • Frontend/Backend Performance: Analyzes rendering, bundle size, concurrency, and caching.
  • Use Case: A developer commits code that introduces a slow database query. This Skill analyzes the change, identifies the N+1 pattern, and suggests an optimized query with eager loading.

Quick Start

Use the qa-performance skill to analyze the code changes for performance anti-patterns.

Frequently Asked Questions about qa-performance

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

FAQPage Schema
How do I detect N+1 query patterns and inefficient SQL in my code changes?▼

To detect N+1 query patterns and inefficient SQL, analyze your code changes for database query efficiency. This process flags performance anti-patterns and suggests optimized queries with eager loading to resolve bottlenecks.

What is the best way to identify algorithmic complexity like O(n^2) loops in my application?▼

Identifying algorithmic complexity like O(n^2) loops requires analyzing your code changes for performance anti-patterns. This detects inefficient algorithms across various programming paradigms to ensure applications run faster.

How can I find memory leaks and unreleased resources in my backend code?▼

Finding memory leaks and unreleased resources involves analyzing code for performance anti-patterns. This identifies memory management issues and provides actionable insights for optimization to reduce resource consumption.

Does performance profiling for frontend bottlenecks cover rendering and bundle size analysis?▼

Performance profiling for frontend bottlenecks covers rendering and bundle size analysis. It evaluates frontend and backend specific performance anti-patterns, including concurrency and caching, to provide actionable optimization insights.

How do I analyze code for performance anti-patterns using project context and dismissed patterns?▼

Analyze code for performance anti-patterns by utilizing project context, dismissed patterns, and detail levels. This evaluates algorithmic complexity and database query efficiency to deliver actionable insights for optimization.

Related Skills

Explore More Software Engineering Skills→
devs6186devs6186

benchmark

Measure page load performance and detect regressions against baselines.

Community
Advanced
gofhirgofhir
2

go-benchmarking

Benchmark and profile Go code using the standard testing framework and pprof.

Official
Intermediate
KrismithReddy12KrismithReddy12

health

Calculate a weighted 0-10 code quality score from linters and test runners.

Community
Advanced
gdurandvadasgdurandvadas
2

standards-go-performance

Profile Go services with pprof and trace to resolve performance bottlenecks.

Community
Advanced