db-query-review
CommunityOptimize database queries for peak performance.
Authorgaebalai
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill identifies and helps resolve common database query performance issues, such as N+1 problems, full table scans, and inefficient joins, to ensure your application runs smoothly and efficiently.
Core Features & Use Cases
- N+1 Problem Detection: Pinpoints loops that trigger excessive database queries.
- Performance Bottleneck Analysis: Identifies full table scans, inefficient aggregations, and poor JOIN patterns.
- Improvement Recommendations: Provides concrete SQL or code suggestions for optimization.
- Use Case: You suspect your application is slow due to database load. Run this Skill on your data access layer code to get a report detailing specific queries that are causing performance issues and how to fix them.
Quick Start
Analyze the SQL queries and application code in the 'src/data' directory for performance bottlenecks.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: db-query-review Download link: https://github.com/gaebalai/claude-code-kit-ko/archive/main.zip#db-query-review Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.