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

database-optimizer

Optimize PostgreSQL and MySQL queries with EXPLAIN ANALYZE and index tuning.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Optimizes database queries to improve overall performance.

Core Features & Use Cases

  • Analyze Performance: Capture baseline metrics and run EXPLAIN ANALYZE before changes.
  • Index Design & Query Rewrites: Create and apply index strategies and rewrite queries for better plans.
  • Configuration Tuning & Partitioning: Tune parameters and partitioning strategies to reduce contention and improve throughput.

Quick Start

Run EXPLAIN ANALYZE on a slow query, then iteratively apply index changes and config tuning to observe performance improvements.

Frequently Asked Questions about database-optimizer

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

FAQPage Schema
How do I optimize slow database queries in PostgreSQL and MySQL?▼

To optimize slow database queries, you should capture baseline metrics and run EXPLAIN ANALYZE to analyze execution plans. Then iteratively apply index design, query rewrites, and configuration tuning to validate performance improvements.

How do I use EXPLAIN ANALYZE to improve query performance?▼

EXPLAIN ANALYZE improves query performance by capturing baseline metrics and exposing the execution plan. You run it before changes to identify bottlenecks, then apply index strategies and query rewrites to observe validated improvements.

When do I need database partitioning and configuration tuning?▼

You need database partitioning and configuration tuning to reduce lock contention and improve throughput. These strategies optimize performance by restructuring data distribution and adjusting system parameters for high-concurrency workloads.

Can I use this approach to resolve lock contention in MySQL?▼

Yes, this approach resolves lock contention in MySQL by tuning configuration parameters and applying partitioning strategies. It analyzes contention scenarios to reduce bottlenecks and improve overall transaction throughput.

What is the best way to design indexes for query optimization?▼

The best way to design indexes for query optimization is to analyze execution plans with EXPLAIN ANALYZE, then create targeted index strategies. This ensures the database uses efficient query plans and validates improvements with metrics.

Related Skills

Explore More Software Engineering Skills→
rabbicserabbicse

database-optimizer

Optimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.

Community
Advanced
scanadyscanady

tech-database-optimizer

Analyze PostgreSQL and MySQL EXPLAIN ANALYZE outputs to diagnose database bottlenecks.

Community
Advanced
shalevaminshalevamin

database-optimizer

Analyze execution plans and optimize PostgreSQL and MySQL database performance.

Community
Advanced
7a336e6e7a336e6e
1

Optimizing Performance

Diagnose PostgreSQL bottlenecks via EXPLAIN ANALYZE and optimize indexing.

Community
Advanced