Does this skill require direct database access?

No, it works by analyzing the text of the EXPLAIN plans and queries you provide within the Claude interface, keeping your database credentials secure.

Can it help with complex query rewriting?

Absolutely. It can suggest alternative query structures, such as using CTEs or specific join types, to help the database engine execute the task more efficiently.

How do I use the Query Performance Optimizer?

Simply provide your SQL query or its EXPLAIN plan to Claude. The skill will automatically activate to analyze the data and provide optimization suggestions.

Which databases are supported by this skill?

The skill is designed to work with standard SQL EXPLAIN plan outputs, making it highly effective for databases like PostgreSQL, MySQL, and MariaDB.

Can it suggest specific indexes to create?

Yes, it identifies columns used in WHERE clauses and JOIN conditions that are currently unindexed and suggests specific indexing strategies to improve speed.

Database Query Performance Optimizer

Name: Database Query Performance Optimizer
Author: intent-solutions-io

byintent-solutions-io

データベース管理

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks.

概要

This skill transforms Claude into a database performance expert capable of interpreting complex EXPLAIN plans and query metrics to boost application speed. By identifying inefficiencies such as full table scans or suboptimal join operations, it provides actionable recommendations for indexing, query rewriting, and configuration adjustments to ensure database resource utilization is maximized and latency is minimized.

主な機能

Interprets complex EXPLAIN plans to identify hidden performance bottlenecks.
Provides specific SQL query rewriting recommendations for better execution paths.
Identifies missing indexes and suggests optimal indexing strategies for specific queries.
0 GitHub stars
Detects inefficient join operations and unnecessary full table scans.
Analyzes query metrics to improve overall database resource utilization and speed.

ユースケース

Troubleshooting high database CPU usage and resource contention issues.
Optimizing slow-running production SQL queries with high latency.
Interpreting and visualizing EXPLAIN plans for complex database schemas.

概要

主な機能

Interprets complex EXPLAIN plans to identify hidden performance bottlenecks.
Provides specific SQL query rewriting recommendations for better execution paths.
Identifies missing indexes and suggests optimal indexing strategies for specific queries.
0 GitHub stars
Detects inefficient join operations and unnecessary full table scans.
Analyzes query metrics to improve overall database resource utilization and speed.

ユースケース

Troubleshooting high database CPU usage and resource contention issues.
Optimizing slow-running production SQL queries with high latency.
Interpreting and visualizing EXPLAIN plans for complex database schemas.