skills.rest
lamb92009
lamb92009COMMUNITY
Explore all skills by this author →
GitHub

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

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
kensauruskensaurus
8

database-optimization

Profile slow queries and optimize indexes in PostgreSQL, Prisma, and Supabase.

Community
Advanced
M-Abdullah07M-Abdullah07
1

sql-optimization-patterns

Identify and implement SQL optimization patterns for slow queries.

Community
Advanced
armanzeroeightarmanzeroeight
29

query-optimizer

Analyze SQL execution plans and rewrite queries for better performance.

Community
Advanced