Which database systems are supported?

The skill is designed to interpret standard EXPLAIN plan structures used by popular relational databases like PostgreSQL, MySQL, and MariaDB.

How do I use this skill with my database?

Provide Claude with your SQL query and its corresponding EXPLAIN plan output. The skill will then analyze the execution path and suggest improvements.

Can it help me identify missing indexes?

Yes, it specifically analyzes search predicates and join conditions to suggest columns that would benefit most from new indexes.

Does it automatically apply changes to my database?

No, it provides safe, actionable recommendations and optimized query snippets for you to review and implement manually.

What is the primary benefit of using this skill?

It reduces the manual effort required to profile queries, helping developers quickly solve performance regressions and improve application responsiveness.

Database Query Performance Analyzer

Name: Database Query Performance Analyzer
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Analyzes database EXPLAIN plans to identify performance bottlenecks and provide actionable SQL optimization recommendations.

This skill transforms Claude into a database performance expert capable of interpreting complex EXPLAIN plans and query execution metrics. It automatically identifies common performance issues such as full table scans, missing indexes, and inefficient join operations, providing developers with clear strategies for rewriting queries or adjusting schemas. By leveraging the query-performance-analyzer plugin, it helps reduce database latency and resource consumption, making it an essential tool for developers debugging slow production queries or refining data models during development.

Key Features

013 GitHub stars

02Actionable recommendations for SQL query rewriting

03Identification of inefficient join algorithms and execution paths

04Detection of missing indexes and redundant table scans

05Automated interpretation of complex SQL EXPLAIN plans

06Optimization strategies for database configuration and schema design

Use Cases

01Validating database indexing strategies during the schema design phase

02Identifying resource-intensive bottlenecks in complex analytical reporting queries

03Debugging and optimizing slow-running SQL queries in production

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection skill-adapter

For use in Claude.ai and ChatGPT

Download Skill