Analyze query performance with EXPLAIN plan interpretation, bottleneck identification, and optimization recommendations
Installation
npx claude-plugins install @jeremylongshore/claude-code-plugins-plus/query-performance-analyzer
Contents
Folders: agents, skills
Files: LICENSE, README.md
Documentation
Analyze query performance with EXPLAIN plan interpretation and optimization recommendations.
Installation
/plugin install query-performance-analyzer@claude-code-plugins-plus
Usage
The performance agent activates when discussing query performance, EXPLAIN plans, or optimization.
Features
- EXPLAIN Plan Analysis: Interpret execution plans
- Bottleneck Detection: Identify performance issues
- Index Recommendations: Suggest optimal indexes
- Metrics Interpretation: Understand performance metrics
- Cost Estimation: Predict query performance
Example
Paste your EXPLAIN output or slow query, and receive detailed analysis with specific optimization recommendations.
License
MIT
Included Skills
This plugin includes 1 skill definition:
analyzing-query-performance
|
View skill definition
Query Performance Analyzer
This skill provides automated assistance for query performance analyzer 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