database-query-optimizer

What problem does it solve?

This Skill identifies and resolves common database performance bottlenecks, such as slow queries, N+1 problems, and missing indexes, ensuring your applications run faster and more efficiently.

Core Features & Use Cases

• N+1 Query Detection & Fixes: Automatically find and eliminate inefficient N+1 query patterns using eager loading (JOINs) in ORMs like SQLAlchemy or Prisma.
• Index Suggestions: Analyze query plans and recommend optimal database indexes to speed up WHERE, ORDER BY, and JOIN clauses.
• Use Case: Analyze a slow API endpoint that fetches users and their associated posts, then optimize the query to fetch all data in a single database hit, or interpret EXPLAIN ANALYZE output to pinpoint performance issues.

Quick Start

Analyze the following SQLAlchemy query for N+1 problems and suggest eager loading: users = db.query(User).all(); for user in users: print(user.posts).