sql-query-optimizer

Analyze and optimize SQL queries for better performance, suggesting indexes, query rewrites, and execution plan improvements

View on GitHub
Author Jeremy Longshore
Namespace @jeremylongshore/claude-code-plugins-plus
Category database
Version 1.0.0
Stars 1,193
Downloads 3
self.md verified
Table of content

Analyze and optimize SQL queries for better performance, suggesting indexes, query rewrites, and execution plan improvements

Installation

npx claude-plugins install @jeremylongshore/claude-code-plugins-plus/sql-query-optimizer

Contents

Folders: commands, skills

Files: LICENSE, README.md

Documentation

Analyze and optimize SQL queries for better performance with index suggestions and query rewrites.

Installation

/plugin install sql-query-optimizer@claude-code-plugins-plus

Usage

/optimize-query

Features

Example

Paste your slow query and get optimization suggestions with expected performance improvements.

Requirements

License

MIT

Included Skills

This plugin includes 1 skill definition:

optimizing-sql-queries

|

View skill definition

Sql Query Optimizer

This skill provides automated assistance for sql query optimizer tasks.

Prerequisites

Before using this skill, ensure:

Instructions

Step 1: Assess Current State

  1. Review current configuration, setup, and baseline metrics
  2. Identify specific requirements, goals, and constraints
  3. Document existing patterns, issues, and pain points
  4. Analyze dependencies and integration points
  5. Validate all prerequisites are met before proceeding

Step 2: Design Solution

  1. Define optimal approach based on best practices
  2. Create detailed implementation plan with clear steps
  3. Identify potential risks and mitigation strategies
  4. Document expected outcomes and success criteria
  5. Review plan with team or stakeholders if needed

Step 3: Implement Changes

  1. Execute implementation in non-production environment first
  2. Verify changes work as expected with thorough testing
  3. Monitor for any issues, errors, or performance impacts
  4. Document all changes, decisions, and configurations
  5. Prepare rollback plan and recovery procedures

Step 4: Validate Implementation

  1. Run comprehensive tests to verify all

…(truncated)

Source

View on GitHub

Tags: database sqloptimizationperformancedatabasequery