Does this skill perform the changes automatically?

It provides the necessary SQL scripts and configuration changes. Following its 'Must Do' constraints, these should be reviewed and tested in a non-production environment first.

Which database systems does this skill support?

While it offers general SQL optimization principles applicable to most RDBMS, it features specialized expertise and reference guides specifically for PostgreSQL and MySQL.

Can it help with slow queries without an EXPLAIN plan?

Yes, it can suggest general improvements based on query structure, but it is designed to prioritize EXPLAIN and EXPLAIN ANALYZE data for precise, evidence-based tuning.

How does it handle the trade-off between read and write performance?

The skill explicitly monitors the impact of new indexes on write performance to ensure that read optimizations do not inadvertently degrade data insertion or update speeds.

Database Optimizer

Name: Database Optimizer
Author: Jeffallan

byJeffallan

•

Database Management

Optimizes database performance through query tuning, strategic indexing, and execution plan analysis for PostgreSQL and MySQL.

About

The Database Optimizer skill transforms Claude into a senior performance engineer capable of diagnosing and resolving complex database bottlenecks. It provides specialized guidance on interpreting EXPLAIN ANALYZE output, designing covering indexes, and tuning system-level configurations to achieve sub-100ms response times. Whether you are dealing with slow-running queries, high lock contention, or scaling issues, this skill ensures your database layer remains performant and scalable using industry-proven best practices and automated analysis patterns.

Key Features

7 GitHub stars
Deep interpretation of EXPLAIN and EXPLAIN ANALYZE plans
Query rewriting for improved execution efficiency
Strategic index design and redundant index detection
Database schema and partitioning strategy optimization
PostgreSQL and MySQL specific system configuration tuning

Use Cases

Identifying and fixing slow-running production queries
Reducing database lock contention and resolving deadlocks
Designing an efficient indexing strategy for new database schemas

About

Key Features

7 GitHub stars
Deep interpretation of EXPLAIN and EXPLAIN ANALYZE plans
Query rewriting for improved execution efficiency
Strategic index design and redundant index detection
Database schema and partitioning strategy optimization
PostgreSQL and MySQL specific system configuration tuning

Use Cases

Identifying and fixing slow-running production queries
Reducing database lock contention and resolving deadlocks
Designing an efficient indexing strategy for new database schemas