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.

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

017 GitHub stars

02Deep interpretation of EXPLAIN and EXPLAIN ANALYZE plans

03Query rewriting for improved execution efficiency

04Strategic index design and redundant index detection

05Database schema and partitioning strategy optimization

06PostgreSQL and MySQL specific system configuration tuning

Use Cases

01Identifying and fixing slow-running production queries

02Reducing database lock contention and resolving deadlocks

03Designing an efficient indexing strategy for new database schemas

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeffallan/claude-skills database-optimizer

For use in Claude.ai and ChatGPT

Download Skill