skills.rest
nashirabbash
nashirabbashCOMMUNITY
Explore all skills by this author →
GitHub

sql-optimization

Analyze SQL execution plans and recommend indexing strategies for query optimization.

Updated Mar 30, 2026
Search Tags:#performance#indexing#optimization#sql#cross-database#execution-plan
One-click install
npx skills add https://github.com/nashirabbash/autorepychatbot --skill sql-optimization-nashirabbash
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-optimization
Source: https://github.com/nashirabbash/autorepychatbot/tree/main/.agents/skills/sql-optimization
Command: npx skills add https://github.com/nashirabbash/autorepychatbot --skill sql-optimization-nashirabbash

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Identify and resolve inefficiencies in SQL queries by guiding tuning, indexing strategies, and performance monitoring across multiple database platforms.

Core Features & Use Cases

  • Execution plan analysis to identify bottlenecks and suggest concrete improvements
  • Indexing strategy design and pagination optimization for cross-database compatibility
  • Batch operation guidance and performance monitoring to maintain throughput in production environments

Quick Start

Analyze a sample slow query and generate recommended indexing and rewrite strategies to improve performance.

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 in production databases?▼

To optimize slow SQL queries, you need execution plan analysis to identify bottlenecks, index design strategies, and query tuning. This applies to complex production queries across MySQL, PostgreSQL, SQL Server, and Oracle systems.

What is the best way to design indexing strategies for cross-database compatibility?▼

Designing indexing strategies for cross-database compatibility requires analyzing execution plans and applying pagination optimization. It ensures queries perform efficiently across major databases like MySQL, PostgreSQL, SQL Server, and Oracle.

How do I analyze an execution plan to identify SQL performance bottlenecks?▼

Analyzing an execution plan identifies SQL performance bottlenecks by revealing how databases process queries. It guides concrete improvements like query rewrites and index design to resolve inefficiencies in complex production environments.

Can I use this approach for batch operations and pagination optimization?▼

Yes, batch operation guidance and pagination optimization maintain throughput in production environments. These techniques apply to complex queries across MySQL, PostgreSQL, SQL Server, and Oracle, ensuring cross-database compatibility.

Why does SQL query tuning require performance monitoring across multiple platforms?▼

SQL query tuning requires performance monitoring because maintaining throughput in production environments demands continuous tracking. Monitoring identifies inefficiencies and validates that indexing and rewrite strategies work across different database platforms.

Related Skills

Explore More Software Engineering Skills→
EanLeeEanLee

sql-optimization-patterns

Analyze EXPLAIN output and implement indexing strategies for SQL query optimization.

Community
Advanced
samuelmukotisamuelmukoti

serving-llms-vllm

Deploy LLMs with vLLM using PagedAttention and continuous batching.

Community
Advanced
kk20300113-pngkk20300113-png

postgres-patterns

Provide PostgreSQL reference patterns for query optimization, schema design, and security configuration.

Community
Intermediate
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced