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.