database-optimizer

Analyze EXPLAIN ANALYZE output to optimize PostgreSQL and MySQL queries.

1|Updated Mar 11, 2026

Search Tags:#performance #indexing #database #postgresql #optimization #mysql #query tuning

Ready to run

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

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses performance bottlenecks in PostgreSQL and MySQL databases, helping to identify and resolve issues that cause slow queries and poor application responsiveness.

Core Features & Use Cases

Query Analysis: Analyzes EXPLAIN ANALYZE output to pinpoint inefficient query execution plans.
Index Optimization: Recommends and generates optimal B-tree, covering, and partial indexes.
Configuration Tuning: Provides guidance on tuning key database parameters for improved performance.
Use Case: When your application experiences slow load times due to database queries, this Skill can analyze the problematic queries, suggest missing indexes, and provide the SQL to create them, significantly speeding up data retrieval.

Quick Start

Use the database-optimizer skill to analyze the provided slow query log and suggest index 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 PostgreSQL and MySQL queries using execution plans?▼

To optimize slow queries, you must analyze the `EXPLAIN ANALYZE` output to pinpoint inefficient execution plans, identify missing indexes, and tune database configurations to resolve performance bottlenecks.

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

Designing indexes for database performance optimization involves generating optimal B-tree, covering, and partial indexes based on query analysis, significantly speeding up data retrieval for slow queries.

Can I tune database configuration parameters to improve application responsiveness?▼

Yes, you can tune key database configuration parameters to improve application responsiveness, addressing suboptimal database performance by resolving underlying system-level bottlenecks in PostgreSQL and MySQL.

Does query tuning work for both PostgreSQL and MySQL systems?▼

Yes, query tuning works for both PostgreSQL and MySQL systems by analyzing SQL query execution, identifying missing indexes, and providing configuration tuning guidance tailored to each platform's internals.

Why does my database experience poor performance despite having indexes?▼

Your database experiences poor performance despite having indexes when queries use inefficient execution plans or suboptimal configurations, requiring deeper query analysis to design optimal covering or partial indexes.

When do I need to analyze slow query logs for database optimization?▼

You need to analyze slow query logs for database optimization when your application experiences slow load times, allowing you to identify problematic queries and generate the SQL to create missing indexes.