skills.rest
newkayak12
newkayak12COMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/newkayak12/claude-skills --skill database-optimizer-newkayak12
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
dieu-donneedieu-donnee

database-optimizer

Identify slow queries and validate index strategies with EXPLAIN ANALYZE across PostgreSQL and MySQL.

Community
Advanced
thechandanbhagatthechandanbhagat
8

sql

Write and optimize SQL queries for relational databases.

Community
Basic
interflownexinterflownex
2

cloud-sql-mysql-monitor

Analyze MySQL query metrics and resource utilization on Google Cloud SQL.

Community
Advanced
chatermchaterm
50

sql-optimization

Analyze SQL execution plans and optimize indexes for MySQL and PostgreSQL queries.

Community
Intermediate