Can this skill automatically apply changes to my database?

No, it provides specific optimization recommendations and rewritten queries which you can review and apply manually or via your migration tools.

How does the skill analyze database queries?

It utilizes the query-performance-analyzer plugin to interpret EXPLAIN plan output, identifying costly operations like sequential scans and nested loops.

Which databases are compatible with this skill?

The skill is designed to work with any database that provides EXPLAIN plan output, including PostgreSQL, MySQL, MariaDB, and SQL Server.

What information should I provide for the best results?

For the most accurate analysis, provide the full SQL query, the complete EXPLAIN plan, and ideally a summary of the relevant table schemas.

Query Performance Analyzer

Name: Query Performance Analyzer
Author: BbgnsurfTech

byBbgnsurfTech

•

데이터베이스 관리

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, helping developers diagnose and resolve slow-running SQL queries. By processing EXPLAIN plans and query metrics, it pinpoints inefficiencies such as full table scans, missing indexes, or suboptimal join operations, and provides actionable recommendations for query rewriting or database schema adjustments to improve resource utilization and execution speed.

주요 기능

Detection of inefficient join algorithms and execution paths
Automated EXPLAIN plan analysis and interpretation
Targeted indexing strategy recommendations
Query rewriting suggestions for improved execution efficiency
3 GitHub stars
Identification of performance bottlenecks like full table scans

사용 사례

Diagnosing slow-running production queries using database EXPLAIN plans
Identifying missing database indexes to improve search and retrieval speed
Optimizing complex SQL statements with multiple join and filter operations

소개

주요 기능

Detection of inefficient join algorithms and execution paths
Automated EXPLAIN plan analysis and interpretation
Targeted indexing strategy recommendations
Query rewriting suggestions for improved execution efficiency
3 GitHub stars
Identification of performance bottlenecks like full table scans

사용 사례

Diagnosing slow-running production queries using database EXPLAIN plans
Identifying missing database indexes to improve search and retrieval speed
Optimizing complex SQL statements with multiple join and filter operations