How does it detect missing indexes?

It analyzes columns used in WHERE, JOIN, and ORDER BY clauses to identify where indexes are necessary to prevent slow sequential scans.

Which ORMs does this skill support?

The skill is designed to work with major ORMs including SQLAlchemy (Python), Django ORM (Python), and Eloquent (PHP/Laravel).

Can this skill fix N+1 queries automatically?

It identifies N+1 patterns and provides the specific code fix, such as suggesting selectinload for SQLAlchemy or prefetch_related for Django.

Does it help with database schema design?

No, this skill focuses specifically on code-level query patterns and performance rather than initial schema architecture or migrations.

Database Query Reviewer

Name: Database Query Reviewer
Author: petrogurcak

bypetrogurcak

0•

データベース管理

Analyzes database interactions and ORM code to identify performance bottlenecks, N+1 query patterns, and transaction risks.

The Database Review skill enables Claude to perform deep audits of database-related code, specifically focusing on the intersection of application logic and data persistence. It identifies common pitfalls like N+1 query patterns across various ORMs including SQLAlchemy, Django, and Eloquent, suggests missing indexes based on query filters, and ensures robust transaction handling for data integrity. This skill is indispensable for developers preparing to scale, debugging slow response times, or performing thorough code reviews to ensure production-grade database efficiency.

主な機能

01Verification of transaction atomicity and rollback handling

020 GitHub stars

03Connection pooling and lifecycle management optimization

04Detection of N+1 query patterns with specific eager loading fixes

05Query pattern analysis for pagination, batching, and SELECT usage

06Intelligent index auditing for WHERE, JOIN, and ORDER BY clauses

ユースケース

01Pre-deployment performance auditing for new database features

02Identifying scalability bottlenecks in high-traffic application code

03Optimizing slow-performing endpoints and complex data retrieval logic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add petrogurcak/skills database-review

For use in Claude.ai and ChatGPT

Download Skill