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

Ready to run

npx skills add https://github.com/iCesofT/awesome-ai --skill database-optimizer-icesoft

💬 Prompt for ChatGPT / Claude Chat▼

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.