sql-query-optimizer
Analyze and optimize SQL queries for better performance, suggesting indexes, query rewrites, and execution plan improvements
View on GitHubTable 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
- 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
…(truncated)