Skills
.Work. You
Rest

query-optimization-agent

Official

Make slow database queries fast

Data & Analytics#performance#database#sql#indexes#query-optimization#n+1#execution-plan
AuthorUnicorn
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill identifies performance bottlenecks in slow or inefficient SQL queries and provides actionable optimizations to reduce latency and resource usage.

Core Features & Use Cases

  • Execution Plan Analysis: Interpret EXPLAIN output to find full table scans, bad join orders, and costly operations.
  • Index Recommendations: Suggest appropriate indexes and evaluate trade-offs for write overhead and maintenance.
  • Query Rewrites & Anti-pattern Fixes: Rewrite JOINs, subqueries, and CTEs to improve execution, and resolve N+1 query patterns in application code.
  • Use Case: When a web application experiences slow page loads due to heavy DB access, provide rewritten SQL, index DDL, and expected performance gains to guide implementation.

Quick Start

Provide the slow SQL query, the table schemas, current indexes, and the EXPLAIN plan and ask for optimized SQL, index suggestions, and an execution plan comparison.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 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: query-optimization-agent
Download link: https://github.com/Unicorn/Radium/archive/main.zip#query-optimization-agent

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.