perf-hotspot-detector
Detect and fix performance bottlenecks like N+1 queries, blocking I/O, and re-render storms via static analysis.
- Eliminate N+1 database queries in ORM-heavy backend code.
- Identify blocking synchronous I/O in Node.js or Python request paths.
- Reduce frontend bundle sizes by detecting un-shaken library imports.
$12
One-time purchase
Included in download
- Eliminate N+1 database queries in ORM-heavy backend code.
- Identify blocking synchronous I/O in Node.js or Python request paths.
- terminal automation included
- Includes example output and usage patterns
See it in action
Finding: N+1 query in orders/views.py
Severity: High
Why: Each order triggers a customer & items query. 50 orders = 301 total DB calls.
Fix:
// Before
orders = Order.objects.all()
// After
orders = Order.objects.select_related('customer').prefetch_related('items__product')perf-hotspot-detector
Detect and fix performance bottlenecks like N+1 queries, blocking I/O, and re-render storms via static analysis.
$12
One-time purchase
⚡ Also available via Agensi MCP — your AI agent can load this skill on demand via MCP. Learn more →
Included in download
- Eliminate N+1 database queries in ORM-heavy backend code.
- Identify blocking synchronous I/O in Node.js or Python request paths.
- terminal automation included
- Includes example output and usage patterns
- Instant install
See it in action
Finding: N+1 query in orders/views.py
Severity: High
Why: Each order triggers a customer & items query. 50 orders = 301 total DB calls.
Fix:
// Before
orders = Order.objects.all()
// After
orders = Order.objects.select_related('customer').prefetch_related('items__product')About This Skill
What it does
The Performance Hotspot Detector acts as a specialized static analysis layer for your AI agent, specifically designed to surface latent performance bugs before they hit production. It scans source code for high-impact patterns like N+1 queries, blocking I/O on main threads, un-memoized expensive renders, and unbounded memory allocations.
Why use this skill
Unlike generic prompting, this skill follows a rigorous architectural audit workflow. It doesn't just look for "bad code"; it evaluates severity based on execution context—prioritizing request handlers and render loops over cold paths like setup scripts. It provides developer-ready, before-and-after code transformations that respect your specific framework's idioms.
Supported stacks
- Backend: Node.js, Python (Django/FastAPI), Go, Java (Spring), Ruby on Rails.
- Frontend: React, Vue, Svelte.
- Databases: SQL-based ORMs (TypeORM, Prisma, SQLAlchemy, Django ORM).
The Output
You receive a structured Performance Audit report. Each finding includes a severity rating (High, Medium, Low), a detailed explanation of the hidden cost model, and a concrete code fix. It further identifies "Investigate" blocks where static analysis hits its limit, providing specific instrumentation commands (like EXPLAIN ANALYZE or Chrome DevTools steps) to verify the impact.
📖 Learn more: Best Frontend & Design Skills for Claude Code →
Use Cases
- Eliminate N+1 database queries in ORM-heavy backend code.
- Identify blocking synchronous I/O in Node.js or Python request paths.
- Reduce frontend bundle sizes by detecting un-shaken library imports.
- Audit React components for re-render storms and memoization breaks.
- Prevent memory leaks from unbounded caches or uncleaned subscriptions.
How to Install
mkdir -p ~/.claude/skills && curl -sL https://www.agensi.io/api/install/perf-hotspot-detector | tar xz -C ~/.claude/skills/Free skills install directly. Paid skills require purchase - use the download button above after buying.
Reviews
No reviews yet - be the first to share your experience.
Only users who have downloaded or purchased this skill can leave a review.
Early access skill
Be the first to review this skill.
Only users who have downloaded or purchased this skill can leave a review.
Frequently Asked Questions
Learn More About AI Agent Skills
Similar Skills
seo-optimizer
SEO optimizer and banned-word scanner for Chinese social media. Keyword optimization and advertising law compliance.
code-reviewer
Reviews your code for bugs, security vulnerabilities, logic errors, performance issues, and style violations. Organizes findings by severity and suggests fixes with code examples.
git-commit-writer
Writes conventional commit messages by analyzing your staged git changes. Detects commit type, scope, and breaking changes automatically.
readme-generator
Generates a complete, polished README.md by scanning your actual project structure, dependencies, and code.