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
- Query Analysis: Identify performance bottlenecks
- Index Recommendations: Suggest optimal indexes
- Query Rewriting: Provide optimized alternatives
- Execution Plan Review: Analyze EXPLAIN output
- Best Practices: Follow SQL optimization patterns
Example
Paste your slow query and get optimization suggestions with expected performance improvements.
Requirements
- SQL queries (PostgreSQL, MySQL, SQLite compatible)
- Access to EXPLAIN output (optional but helpful)
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:
- Required credentials and permissions for the operations
- Understanding of the system architecture and dependencies
- Backup of critical data before making structural changes
- Access to relevant documentation and configuration files
- Monitoring tools configured for observability
- Development or staging environment available for testing
Instructions
Step 1: Assess Current State
- Review current configuration, setup, and baseline metrics
- Identify specific requirements, goals, and constraints
- Document existing patterns, issues, and pain points
- Analyze dependencies and integration points
- Validate all prerequisites are met before proceeding
Step 2: Design Solution
- Define optimal approach based on best practices
- Create detailed implementation plan with clear steps
- Identify potential risks and mitigation strategies
- Document expected outcomes and success criteria
- Review plan with team or stakeholders if needed
Step 3: Implement Changes
- Execute implementation in non-production environment first
- Verify changes work as expected with thorough testing
- Monitor for any issues, errors, or performance impacts
- Document all changes, decisions, and configurations
- Prepare rollback plan and recovery procedures
Step 4: Validate Implementation
- Run comprehensive tests to verify all