optimizing-sql-queries

What problem does it solve?

This skill empowers Claude to analyze SQL queries, identify performance bottlenecks, and suggest optimizations such as index creation or query rewriting. It leverages the sql-query-optimizer plugin to provide actionable recommendations for improving database performance and efficiency.

Core Features & Use Cases

• Query Analysis: Analyze SQL structure and execution plans to pinpoint inefficiencies.
• Index Recommendations: Suggest optimal indexes to speed up slow queries.
• Query Rewrites: Propose alternative, more efficient query formulations.
• Use Case: Optimize a slow SELECT query by identifying missing indexes and suggesting a more efficient query structure.

Quick Start

User request: "Optimize this SQL query: SELECT * FROM orders WHERE customer_id = 123 AND order_date < '2023-01-01';"

The skill will:

1. Analyze the provided SQL query.
2. Suggest creating an index on customer_id and order_date columns to improve query performance.