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

•

데이터베이스 관리

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

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.

주요 기능

01Actionable query rewriting and optimization suggestions

02Detection of bottlenecks like full table scans and temporary files

03Database resource utilization and configuration advice

04Automated EXPLAIN plan interpretation and analysis

05Identification of missing or inefficient indexes

063 GitHub stars

사용 사례

01Proactive index optimization during the software development lifecycle

02Reducing database CPU load and memory consumption through tuning

03Debugging slow-running production queries with complex joins

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection query-performance-analyzer

For use in Claude.ai and ChatGPT

Download Skill