performance-analyzer

To detect N+1 queries, you need static analysis that pinpoints inefficient database query patterns. This Skill analyzes your code and database queries to identify N+1 query anti-patterns and provides optimized code suggestions.

The best way to optimize database queries for missing indexes is through index optimization analysis. This Skill examines your queries and suggests adding database indexes for faster lookups, including impact estimations for the changes.

To identify inefficient synchronous operations within loops, you analyze code logic for algorithmic efficiency. This Skill detects synchronous operations inside loops and unpaginated data fetches, then suggests optimized code snippets.

Yes, you can analyze unpaginated data fetches for performance regressions. This Skill examines your code modifications to detect unpaginated fetches, inefficient algorithms, and API modifications, providing impact estimations for large file operations.

You do not need any specific dependencies to analyze code for performance bottlenecks. This Skill operates with no external dependencies and analyzes your code and database queries directly to resolve slow application performance.