skills.rest
gaebalai
gaebalaiCOMMUNITY
Explore all skills by this author →
Website𝕏@gaebalaiGitHub

db-query-review

Analyze application code and SQL queries for database performance issues.

2|Updated Feb 25, 2026
Search Tags:#code review#performance#query optimization#database#sql#n+1 problem
One-click install
npx skills add https://github.com/gaebalai/claude-code-kit-ko --skill db-query-review
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-query-review
Source: https://github.com/gaebalai/claude-code-kit-ko/tree/main/.claude/skills/db-query-review
Command: npx skills add https://github.com/gaebalai/claude-code-kit-ko --skill db-query-review

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

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.

Frequently Asked Questions about db-query-review

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I detect N+1 query problems in my application code?▼

To detect N+1 query problems, this Skill performs static code analysis on your data access layer to pinpoint loops that trigger excessive database queries, identifying the exact queries causing performance issues without executing them.

What causes full table scans in SQL and how can I analyze them?▼

Full table scans in SQL are caused by inefficient aggregation and poor JOIN patterns. This Skill analyzes your application code to identify these performance bottlenecks and provides concrete refactoring suggestions to optimize the queries.

Can I optimize database query performance without executing the actual queries?▼

Yes, you can optimize database query performance without execution by using static code analysis. This Skill examines your SQL queries and application code to find inefficient join patterns and provides specific improvement strategies safely.

What is the best way to find performance bottlenecks in my data access layer?▼

The best way to find performance bottlenecks in your data access layer is to run static analysis on the source directory. This Skill examines the code to detect inefficient aggregations, poor JOIN patterns, and N+1 problems, then suggests refactoring improvements.

Does this static code analysis tool require a live database connection to detect query issues?▼

No, this static code analysis tool does not require a live database connection. It operates by analyzing your application code and SQL queries directly to detect performance issues like N+1 problems and full table scans without executing actual queries.

Related Skills

Explore More Software Engineering Skills→
Archive228Archive228
746

sql-review

Reviews SQL and ORM queries for injection risks, missing indexes, and bottlenecks.

Community
Intermediate
UnicornUnicorn

query-optimization-agent

Analyze SQL queries and produce rewritten SQL, index recommendations, and execution plan comparisons.

Official
Intermediate
jeremylongshorejeremylongshore
2.6k

analyzing-query-performance

Analyze EXPLAIN plans and query metrics to identify database bottlenecks.

Community
Intermediate
zcacereszcaceres
7

quality-perf-review

Analyze full-stack codebases to identify and remediate performance bottlenecks.

Community
Advanced