Does it support composite indexes?

Yes, the skill can analyze multiple filtering and sorting criteria within your query to recommend multi-column composite indexes that significantly speed up complex search patterns.

Should I provide an execution plan (EXPLAIN output)?

While not mandatory, providing the output of an EXPLAIN statement allows the skill to provide much more accurate and context-aware recommendations tailored to your specific database engine.

How does the SQL Query Optimizer help with database performance?

It analyzes your SQL queries to identify bottlenecks, suggests specific indexes to speed up lookups, and proposes query rewrites to reduce overall execution time and resource consumption.

Is this skill specific to a certain SQL dialect?

It provides general SQL optimization best practices that are applicable to most major relational databases including PostgreSQL, MySQL, SQL Server, and SQLite.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Optimizes SQL queries by identifying performance bottlenecks and suggesting strategic indexing and query rewrites.

About

The SQL Query Optimizer skill empowers Claude to act as a virtual Database Administrator, analyzing database queries to improve execution speed and resource efficiency. By reviewing query structures and execution plans, it provides actionable recommendations for creating missing indexes, eliminating redundant operations, and refactoring complex logic into high-performance SQL. This skill is essential for developers looking to scale applications, reduce database load, and resolve latency issues in data-driven environments.

Key Features

Execution plan (EXPLAIN) analysis and interpretation
Smart indexing recommendations for improved lookup speeds
SQL query refactoring and rewriting suggestions
3 GitHub stars
Composite index strategy generation for complex filters
Automated bottleneck identification in SQL queries

Use Cases

Refactoring legacy SQL code to follow modern performance best practices
Accelerating slow-running production queries in web applications
Designing efficient indexing strategies for new database schemas

About

Key Features

Execution plan (EXPLAIN) analysis and interpretation
Smart indexing recommendations for improved lookup speeds
SQL query refactoring and rewriting suggestions
3 GitHub stars
Composite index strategy generation for complex filters
Automated bottleneck identification in SQL queries

Use Cases

Refactoring legacy SQL code to follow modern performance best practices
Accelerating slow-running production queries in web applications
Designing efficient indexing strategies for new database schemas