optimizing-sql-queries

Featured

This skill analyzes and optimizes SQL queries for improved performance. It identifies potential bottlenecks, suggests optimal indexes, and proposes query rewrites. Use this when the user mentions "optimize SQL query", "improve SQL performance", "SQL query optimization", "slow SQL query", or asks for help with "SQL indexing". The skill helps enhance database efficiency by analyzing query structure, recommending indexes, and reviewing execution plans.

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 93/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

## Overview 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. ## How It Works 1. **Query Input**: The user provides an SQL query to be optimized. 2. **Analysis**: The plugin analyzes the query structure, potential indexing issues, and execution plan (if available). 3. **Recommendations**: The plugin generates optimization suggestions, including index recommendations and query rewrites. ## When to Use This Skill This skill activates when you need to: - Optimize a slow-running SQL query. - Identify missing or unused indexes in a database. - Improve the performance of a database application. ## Examples ### Example 1: Optimizing a Slow Query 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. ### Example 2: Finding Indexing Opportunities User request: "I need help optimizing a query that filters on product_category and price. Can you suggest any indexes?" The skill will: 1. Analyze a hypothetical query based on the user's description. 2. Recommend a composite index on (product_category, price) to speed up filtering. ## Best Practices - *...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Featured

analyzing-database-indexes

This skill uses the database-index-advisor plugin to analyze query patterns and recommend optimal database indexes. It identifies missing indexes to improve query performance and unused indexes that can be removed to save storage and improve write performance. Use this skill when the user asks to "analyze database indexes", "optimize slow queries", "find missing indexes", "remove unused indexes", or requests help with "database index optimization". The plugin analyzes database workloads, detects potential indexing issues, and provides actionable recommendations for indexing strategies.

2,926 Updated yesterday
jeremylongshore
AI & Automation Featured

analyzing-query-performance

This skill enables Claude to analyze and optimize database query performance. It activates when the user discusses query performance issues, provides an EXPLAIN plan, or asks for optimization recommendations. The skill leverages the query-performance-analyzer plugin to interpret EXPLAIN plans, identify performance bottlenecks (e.g., slow queries, missing indexes), and suggest specific optimization strategies. It is useful for improving database query execution speed and resource utilization.

2,926 Updated yesterday
jeremylongshore
API & Backend Listed

optimizing-sql

Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server. Use when debugging slow queries, analyzing execution plans, or improving database performance.

533 Updated 11 months ago
ancoleman