query-performance-analyzer

Analyze query performance with EXPLAIN plan interpretation, bottleneck identification, and optimization recommendations

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

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

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:

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

…(truncated)

Source

View on GitHub

Tags: database performancequeryoptimizationexplaindatabase