Performance Review

Analyze Python functions for performance anti-patterns and generate a JSON report.

Updated Mar 3, 2026
One-click install
npx skills add https://github.com/StrategicMilk/Vetinari-Orchestrastor --skill performance-review-strategicmilk
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Performance Review
Source: https://github.com/StrategicMilk/Vetinari-Orchestrastor/tree/main/vetinari/skills/catalog/inspector/performance-review
Command: npx skills add https://github.com/StrategicMilk/Vetinari-Orchestrastor --skill performance-review-strategicmilk

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Performance Review identifies hidden performance anti‑patterns such as quadratic algorithms, N+1 queries, excessive memory use, and inefficient I/O before code reaches production, preventing costly runtime slow‑downs.

Core Features & Use Cases

  • Static complexity analysis – Detect O(n^2) loops, exponential recursion, and other costly patterns.
  • Database query inspection – Spot N+1 query patterns and suggest batch operations.
  • Memory and I/O checks – Find unbounded collections, unnecessary file loads, and sub‑optimal streaming.
  • Actionable report – Returns a graded report with severity, description, and concrete fixes.

Use case: During a code review of a new data‑processing pipeline, run the skill to surface performance hot‑spots and receive prioritized remediation suggestions.

Quick Start

Ask the inspector skill to perform a performance review on the file plan_generator.py.

Frequently Asked Questions about Performance Review

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

FAQPage Schema
How do I detect N+1 database queries in Python code?

You can detect N+1 database queries in Python code by running a static code review that analyzes function logic for iterative query calls, returning a JSON report with severity grades and batch operation suggestions.

What is static complexity analysis for finding quadratic loops?

Static complexity analysis is the process of examining source code without execution to detect costly algorithmic patterns like O(n^2) loops and exponential recursion. It surfaces performance hotspots to prevent runtime slow-downs.

Can I identify memory leaks and inefficient I/O during a code review?

Yes, you can identify memory leaks and inefficient I/O during a code review by scanning Python functions for unbounded collections, unnecessary file loads, and sub-optimal streaming. The analysis returns a graded report with concrete remediation suggestions.

Does the performance review tool work on any Python file?

The performance review tool works on any Python file by analyzing functions for performance anti-patterns like quadratic algorithms and excessive memory use. It requires no external dependencies to generate its JSON-formatted report.

What is the best way to find performance anti-patterns before production?

The best way to find performance anti-patterns before production is to run a static code review on your data-processing pipelines. This identifies hidden issues like N+1 queries and inefficient I/O, providing prioritized remediation suggestions.