database-optimizer

Analyze slow queries and execution plans to optimize PostgreSQL and MySQL performance.

Updated Feb 11, 2026

Search Tags:#indexing #database #postgresql #mysql #query-optimization #tuning #execution-plan

Ready to run

npx skills add https://github.com/lamb92009/claude-skills --skill database-optimizer-lamb92009

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/lamb92009/claude-skills/tree/main/database-optimizer
Command: npx skills add https://github.com/lamb92009/claude-skills --skill database-optimizer-lamb92009

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Slow queries, missing or misapplied indexes, and suboptimal configuration can bottleneck database performance. This Skill provides a structured approach to analyze, optimize, and validate improvements across major relational databases such as PostgreSQL and MySQL.

Core Features & Use Cases

Analyze slow queries and execution plans to identify bottlenecks.
Design and implement effective index strategies, including covering indexes and partitioning considerations.
Propose configuration tunings and query rewrites with measurable validation.

Quick Start

Run an EXPLAIN ANALYZE on the current slow query and propose concrete indexing and configuration changes.

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 PostgreSQL or MySQL queries using execution plans?▼

To optimize slow queries, run an EXPLAIN ANALYZE to review execution plans and index usage. This Skill analyzes bottlenecks, proposes query rewrites, and designs indexing strategies like covering indexes to improve PostgreSQL and MySQL performance.

What is the best way to design indexing strategies for production database workloads?▼

The best way to design indexing strategies is by analyzing execution plans to identify missing or misapplied indexes. This Skill proposes covering indexes and partitioning considerations tailored to production workloads in PostgreSQL and MySQL.

Why does my database configuration bottleneck query performance?▼

Database configuration bottlenecks occur when suboptimal settings limit throughput. This Skill analyzes slow queries and execution plans to propose configuration tunings that yield measurable validation results across production workloads.

Can I validate database query optimization changes before applying them to production?▼

You can validate query optimization changes by reviewing EXPLAIN ANALYZE outputs. This Skill ensures thorough execution plan reviews and safe changes to deliver measurable validation results for PostgreSQL and MySQL configurations.

Does this approach work for both PostgreSQL and MySQL query tuning?▼

Yes, this approach supports query tuning for both PostgreSQL and MySQL. It analyzes execution plans, designs indexing strategies, and proposes configuration tunings to optimize performance across major relational databases.