Does it recommend query rewrites?

Absolutely. If a query is structured inefficiently, the skill will suggest alternative syntax or logic, such as replacing subqueries with joins or optimizing WHERE clauses.

Which databases does this skill support?

The skill is designed to interpret standard EXPLAIN plan structures and execution metrics common in major SQL databases like PostgreSQL, MySQL, and MariaDB.

What information do I need to provide for the best results?

For the most accurate analysis, you should provide both the original SQL query and the full output of the EXPLAIN (or EXPLAIN ANALYZE) command.

Can this skill help with missing indexes?

Yes, it specifically identifies columns used in filters and joins that lack appropriate indexing and suggests the best index types to implement.

Is it safe to use with my database?

The skill only analyzes the metadata and execution plans you provide; it does not connect to or execute commands directly on your production database.

Database Query Performance Analyzer

Name: Database Query Performance Analyzer
Author: jeremylongshore

byjeremylongshore

•

883

•

数据库管理

Analyzes and optimizes database query performance by interpreting EXPLAIN plans and identifying execution bottlenecks.

This skill empowers Claude to act as a database performance expert by analyzing query metrics and EXPLAIN plans to pinpoint inefficiencies like full table scans, missing indexes, or suboptimal join operations. It provides actionable recommendations for rewriting queries, implementing indexing strategies, and adjusting database configurations to significantly improve execution speed and resource utilization within your application's data layer.

主要功能

01Automatic interpretation of complex SQL EXPLAIN plans

02Identification of performance bottlenecks such as sequential scans

03Specific recommendations for new index creation and optimization

04Analysis of join algorithms and resource utilization patterns

05883 GitHub stars

06Query rewrite suggestions to improve execution logic

使用场景

01Optimizing slow-running production queries to reduce server latency

02Identifying missing indexes during the development of new database schemas

03Troubleshooting high CPU or memory usage caused by inefficient data access

主要功能

01Automatic interpretation of complex SQL EXPLAIN plans

02Identification of performance bottlenecks such as sequential scans

03Specific recommendations for new index creation and optimization

04Analysis of join algorithms and resource utilization patterns

05883 GitHub stars

06Query rewrite suggestions to improve execution logic

使用场景

01Optimizing slow-running production queries to reduce server latency

02Identifying missing indexes during the development of new database schemas

03Troubleshooting high CPU or memory usage caused by inefficient data access