skills.rest
Gabeujin
GabeujinCOMMUNITY
Explore all skills by this author →
GitHub

sql-optimization

Analyzes SQL execution plans and refactors queries for improved performance across MySQL, PostgreSQL, SQL Server, and Oracle.

1|Updated Feb 23, 2026
Search Tags:#performance#indexing#database#optimization#sql#query tuning
One-click install
npx skills add https://github.com/Gabeujin/workspace-init-mcp --skill sql-optimization-gabeujin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-optimization
Source: https://github.com/Gabeujin/workspace-init-mcp/tree/main/awesome/skills/sql-optimization
Command: npx skills add https://github.com/Gabeujin/workspace-init-mcp --skill sql-optimization-gabeujin

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses slow-performing SQL queries and inefficient database structures that hinder application speed and scalability.

Core Features & Use Cases

  • Query Analysis: Identifies bottlenecks in SQL queries.
  • Indexing Strategies: Recommends optimal index creation and maintenance.
  • Performance Tuning: Provides techniques for optimizing JOINs, subqueries, and aggregations.
  • Use Case: A web application's user dashboard is loading slowly due to complex database queries. This Skill analyzes the queries, suggests better indexing, and rewrites inefficient parts to drastically improve load times.

Quick Start

Use the sql-optimization skill to analyze and improve the performance of the provided SQL query.

Frequently Asked Questions about sql-optimization

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

FAQPage Schema
How do I optimize slow SQL queries and improve database performance?▼

To optimize slow SQL queries, this Skill analyzes execution plans, refactors inefficient JOINs and subqueries, and recommends optimal indexing strategies to resolve bottlenecks and improve application load times.

Does this SQL query tuning approach work with PostgreSQL and MySQL?▼

Yes, SQL query tuning applies across various SQL dialects including PostgreSQL, MySQL, SQL Server, and Oracle, analyzing execution plans and suggesting indexing improvements specific to each database environment.

What is the best way to analyze an execution plan for database indexing strategies?▼

The best way to analyze an execution plan for database indexing is to evaluate query bottlenecks, identify missing or inefficient indexes, and refactor aggregations to ensure peak database performance and scalability.

How can I refactor complex SQL JOINs and subqueries for better efficiency?▼

You can refactor complex SQL JOINs and subqueries for better efficiency by applying performance tuning techniques that restructure the query logic and align it with optimal database indexing strategies.

Why does my web application user dashboard load slowly despite correct SQL syntax?▼

Your web application dashboard loads slowly because correct SQL syntax does not guarantee efficiency; complex database queries require execution plan analysis and query tuning to eliminate underlying performance bottlenecks.

Related Skills

Explore More Software Engineering Skills→
gaebalaigaebalai
2

db-index-suggest

Analyzes SQL queries, slow query logs, and execution plans to suggest database index improvements.

Community
Advanced
alexander-danilenkoalexander-danilenko
14

sql-pro

Optimize slow SQL queries and schemas with EXPLAIN plan analysis and index recommendations.

Community
Advanced
codeApe-7codeApe-7
17

sql-pro

Analyze SQL execution plans and suggest indexing strategies.

Community
Advanced
williamzujkowskiwilliamzujkowski
17

database-advanced-optimization

Optimize PostgreSQL, MongoDB, and Redis performance with indexing and query tuning.

Community
Advanced