query-optimize

Fix N+1 query problems by analyzing your ORM code to detect inefficient findMany calls within loops and replacing them with eager loading. This Skill detects these patterns in ORMs like Prisma, TypeORM, and SQLAlchemy to improve performance.

Optimize slow SQL queries by performing query plan analysis to identify execution bottlenecks in PostgreSQL and MySQL. This Skill analyzes your database queries and recommends missing indexes to significantly improve application performance.

Yes, this database optimization tool works with MongoDB and SQLite, alongside PostgreSQL and MySQL. It provides specific query plan analysis and index recommendations for both SQL and NoSQL databases to resolve performance issues.

Yes, you can analyze Mongoose and Django ORM queries for missing indexes. This Skill supports ORMs including Mongoose, Django ORM, Prisma, TypeORM, Sequelize, and SQLAlchemy, detecting N+1 patterns and suggesting appropriate indexes.

The best way to detect missing database indexes is to analyze your query execution plans and query patterns. This process identifies missing indexes based on query analysis and recommends specific indexes to add for improved database performance.

Analyze database query execution plans by examining how SQL and NoSQL queries execute under the hood. This Skill provides query plan analysis to pinpoint performance bottlenecks and recommends indexes or query rewrites to resolve them.