skills.rest
Szantoi
SzantoiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-optimization

Analyze SQL execution plans and optimize indexing across MySQL, PostgreSQL, SQL Server, and Oracle.

Updated Apr 25, 2026
Search Tags:#indexing#database#performance optimization#sql#execution plans
One-click install
npx skills add https://github.com/Szantoi/spaceos-modules-cabinet --skill sql-optimization-szantoi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-optimization
Source: https://github.com/Szantoi/spaceos-modules-cabinet/tree/main/.claude/skills/sql-optimization
Command: npx skills add https://github.com/Szantoi/spaceos-modules-cabinet --skill sql-optimization-szantoi

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides expert-level SQL optimization advice and execution plan analysis for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle).

Core Features & Use Cases

  • Query Performance Analysis: Analyze and optimize query execution plans, including pagination and batch operations.
  • Index Strategy Optimization: Offers indexing strategies for improved performance and composite indexing recommendations.
  • Subquery Optimization: Recommends window functions over correlated subqueries for better performance.
  • Database-Agnostic Optimization: Provides batch operations and temporary table usage for efficient database operations.

Quick Start

Optimize the performance of your SQL queries using the sql-optimization skill.

Frequently Asked Questions about sql-optimization

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

FAQPage Schema
How do I optimize SQL query performance using execution plans?▼

Optimize SQL query performance by analyzing execution plans to identify bottlenecks, optimizing indexing strategies, and applying best practices for joins, subqueries, and aggregations across MySQL, PostgreSQL, SQL Server, and Oracle.

What is the best way to optimize indexing for database queries?▼

The best way to optimize indexing is by analyzing execution plans and applying composite indexing strategies tailored to your queries, which drastically improves database performance and data retrieval speed.

Can I use this for SQL optimization across different database platforms?▼

Yes, database-agnostic SQL optimization is fully supported. You can analyze execution plans and apply performance tuning across MySQL, PostgreSQL, SQL Server, and Oracle databases.

Why should I use window functions over correlated subqueries?▼

Use window functions over correlated subqueries to optimize SQL performance because window functions process data more efficiently, reducing the computational overhead associated with row-by-row correlated subquery execution.

How do I handle batch operations and pagination in SQL efficiently?▼

Handle batch operations and pagination efficiently by analyzing execution plans and utilizing temporary tables, which streamlines large-scale database operations and reduces memory consumption during performance optimization.

Do I need to know SQL syntax to optimize database queries?▼

Yes, you need existing knowledge of SQL syntax and database management principles to effectively optimize database queries, as the process requires interpreting execution plans and applying indexing strategies.

Related Skills

Explore More Software Engineering Skills→
htlin222htlin222
77

sql

Develop and optimize SQL queries, design schemas, and advise on indexing strategies.

Community
Advanced
slantviewslantview
1

performance-optimizer

Profiles CPU, memory, and I/O bottlenecks and implements algorithmic and caching optimizations.

Community
Advanced
voidrotvoidrot

postgres-patterns

Analyze and optimize PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies.

Community
Advanced
bianhaifeng789-huebianhaifeng789-hue

query-optimize

Optimize slow PostgreSQL, MySQL, and SQLite queries with plan analysis and rewrites.

Community
Intermediate