Can this skill automatically rewrite my SQL queries?

Yes, it can provide optimized versions of your queries and the necessary SQL commands to create missing indexes for you to review and apply.

Is it safe to use on production queries?

Yes, it only analyzes the query structure and execution plan; it does not execute data-modifying operations or access sensitive data values unless explicitly instructed.

Do I need to provide the database schema?

While providing the schema helps, the skill can often identify major bottlenecks just by analyzing the EXPLAIN plan and the query structure itself.

Which databases are supported by this skill?

This skill is designed to work with most relational databases that provide EXPLAIN output, including PostgreSQL, MySQL, MariaDB, and SQLite.

How does it help with high database CPU usage?

By identifying unindexed queries or inefficient scan types that force the database to work harder than necessary, it helps reduce overall resource consumption.

Database Query Performance Analyzer

Name: Database Query Performance Analyzer
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

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

About

This skill transforms Claude into a database performance expert capable of diagnosing slow-running SQL queries. By processing EXPLAIN output and query metrics, it pinpoints inefficiencies such as full table scans, suboptimal join algorithms, and missing indexes. It provides actionable recommendations to enhance execution speed and resource efficiency, making it an essential tool for developers looking to scale database-heavy applications or troubleshoot production latency issues.

Key Features

Actionable query rewriting and optimization suggestions
Detection of bottlenecks like full table scans and temporary files
Database resource utilization and configuration advice
Automated EXPLAIN plan interpretation and analysis
Identification of missing or inefficient indexes
3 GitHub stars

Use Cases

Proactive index optimization during the software development lifecycle
Reducing database CPU load and memory consumption through tuning
Debugging slow-running production queries with complex joins

About

Key Features

Actionable query rewriting and optimization suggestions
Detection of bottlenecks like full table scans and temporary files
Database resource utilization and configuration advice
Automated EXPLAIN plan interpretation and analysis
Identification of missing or inefficient indexes
3 GitHub stars

Use Cases

Proactive index optimization during the software development lifecycle
Reducing database CPU load and memory consumption through tuning
Debugging slow-running production queries with complex joins