skills.rest
iCesofT
iCesofTCOMMUNITY
Explore all skills by this author →
Website𝕏@fjahijadoGitHub

sql-optimization

Analyze execution plans and recommend indexing for SQL queries.

1|1|Updated Apr 16, 2026
Search Tags:#performance#optimization#sql#query#indexes#execution-plan
One-click install
npx skills add https://github.com/iCesofT/awesome-ai --skill sql-optimization-icesoft
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-optimization
Source: https://github.com/iCesofT/awesome-ai/tree/main/agents/skills/sql-optimization
Command: npx skills add https://github.com/iCesofT/awesome-ai --skill sql-optimization-icesoft

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Inefficient SQL queries across multiple database engines waste time and compute resources, leading to higher latency and costs.

Core Features & Use Cases

  • Execution plan analysis and guidance for MySQL, PostgreSQL, SQL Server, and Oracle.
  • Indexing and query rewrite recommendations to reduce I/O and improve throughput.
  • Real-world use cases including OLTP reports, batch ETL jobs, and analytics queries with measurable improvements.

Quick Start

Provide a tuning plan for the given slow SQL query on the specified database.

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 across different database engines?▼

To optimize slow SQL queries across MySQL, PostgreSQL, SQL Server, and Oracle, you analyze execution plans and apply indexing strategies or query rewrites. This reduces I/O and improves throughput for both OLTP and analytical workloads.

What is an execution plan and how does it help with SQL optimization?▼

An execution plan details how a database engine executes a query. Analyzing it identifies bottlenecks in ad-hoc queries or batch ETL jobs, guiding indexing strategies and query rewrites to deliver measurable performance improvements.

Does this SQL optimization approach work for both OLTP and analytical workloads?▼

Yes, this SQL optimization approach works for both OLTP and analytical workloads. It handles ad-hoc queries, batch jobs, and reporting across MySQL, PostgreSQL, SQL Server, and Oracle, providing cross-engine compatibility and concrete guidance.

How do I tune a slow SQL query using an execution plan?▼

To tune a slow SQL query, provide the query and specified database to generate a tuning plan. The process analyzes the execution plan and recommends indexing strategies and query rewrites to reduce latency and compute costs.

What is the best way to reduce I/O and improve throughput for batch ETL jobs?▼

The best way to reduce I/O and improve throughput for batch ETL jobs is applying indexing and query rewrite recommendations. Optimizing these SQL queries lowers latency and compute resource waste across database engines.

Related Skills

Explore More Software Engineering Skills→
DexploarerDexploarer
6

database-query-optimizer

Analyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.

Community
Advanced
irizqiirizqi

laravel-database-optimization

Optimize Laravel 13 database queries with eager loading and indexing strategies.

Community
Advanced
cenjiecenjie

database-query-optimization

Analyze EXPLAIN ANALYZE diagnostics and apply indexing to optimize database queries.

Community
Advanced
rahulgupta2018rahulgupta2018

database-expert

Design and optimize data schemas and query performance across database families.

Community
Advanced