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.

주요 기능

Automatic interpretation of complex SQL EXPLAIN plans
Identification of performance bottlenecks such as sequential scans
Specific recommendations for new index creation and optimization
Analysis of join algorithms and resource utilization patterns
883 GitHub stars
Query rewrite suggestions to improve execution logic

사용 사례

Optimizing slow-running production queries to reduce server latency
Identifying missing indexes during the development of new database schemas
Troubleshooting high CPU or memory usage caused by inefficient data access

소개

주요 기능

Automatic interpretation of complex SQL EXPLAIN plans
Identification of performance bottlenecks such as sequential scans
Specific recommendations for new index creation and optimization
Analysis of join algorithms and resource utilization patterns
883 GitHub stars
Query rewrite suggestions to improve execution logic

사용 사례

Optimizing slow-running production queries to reduce server latency
Identifying missing indexes during the development of new database schemas
Troubleshooting high CPU or memory usage caused by inefficient data access