Can it help with slow JOIN operations?

Yes, it identifies inefficient JOIN structures and recommends better indexing strategies or alternative query patterns to reduce execution time.

How does this skill optimize SQL queries?

It analyzes query structure and execution plans to suggest more efficient syntax, identifies missing indexes, and proposes refactoring for complex logic.

Should I apply the optimizations directly to production?

It is a best practice to test all suggested index creations and query rewrites in a staging environment to verify performance gains before production deployment.

Which databases is this skill compatible with?

While providing general SQL best practices, it is highly effective for common relational databases like PostgreSQL, MySQL, and SQL Server.

What information should I provide for the best results?

For the most accurate analysis, provide the full SQL query text and the output of the EXPLAIN command if available.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: intent-solutions-io

byintent-solutions-io

データベース管理

Analyzes and refines SQL queries to enhance database performance through index recommendations and structural rewrites.

概要

The SQL Query Optimizer skill empowers Claude to act as a database performance engineer, identifying latency issues and structural inefficiencies in SQL code. By analyzing query execution plans and schema structures, it provides actionable advice such as composite index suggestions, subquery refactoring, and performance-tuning strategies. This skill is essential for developers looking to scale applications, reduce database load, and ensure optimal response times for data-intensive operations.

主な機能

Database Efficiency Benchmarking
0 GitHub stars
Performance Bottleneck Identification
Execution Plan Analysis Support
SQL Query Refactoring & Rewriting
Automated Index Recommendations

ユースケース

Troubleshooting slow-running queries in production logs
Refactoring complex JOIN operations for improved execution speed
Optimizing database schema with missing or redundant indexes

概要

主な機能

Database Efficiency Benchmarking
0 GitHub stars
Performance Bottleneck Identification
Execution Plan Analysis Support
SQL Query Refactoring & Rewriting
Automated Index Recommendations

ユースケース

Troubleshooting slow-running queries in production logs
Refactoring complex JOIN operations for improved execution speed
Optimizing database schema with missing or redundant indexes