/analyze-query

Analyze database queries for performance issues using EXPLAIN plans and query patterns.

rohitg00@rohitg00

GitHub

From plugin

rohitg00-claude-code-toolkit

2.5k199 skills138 agents199 commands

Install

$ npx -y skills add rohitg00/awesome-claude-code-toolkit --agent claude-code

How it fires

How this command gets triggered: by you, by Claude, or both.

Fires itselfClaude auto-loads it when your prompt matches the work.
You can call itInvoke it directly when you want it.
Slash command/analyze-query

Context preview

What this command does when you run it.

Analyze database queries for performance issues using EXPLAIN plans and query patterns.

Command definition

analyze-query.md

Analyze database queries for performance issues using EXPLAIN plans and query patterns.

Steps

1. Identify the slow or problematic query: 2. Run EXPLAIN (or EXPLAIN ANALYZE) on the query: 3. Analyze common performance issues: 4. Check for lock contention: 5. Suggest optimizations: 6. Estimate improvement from each suggestion.

Format

Query: <simplified query>
Current Time: <execution time>
Issues Found:
  - <issue>: <impact>

Rules

Always use EXPLAIN ANALYZE for real execution statistics.
Consider the query frequency when prioritizing optimizations.
Test optimizations on a staging environment first.

Read it on GitHub ↗

Ships withrohitg00-claude-code-toolkit

The most comprehensive toolkit for Claude Code -- 135 agents, 35 curated skills (+400,000 via SkillKit), 42 commands, 176+ plugins, 20 hooks, 15 rules, 7 templates, 15 MCP configs, 26 companion apps, 53 ecosystem entries, and more.

Get the whole plugin

Stats

Python JavaScript React CSS Kubernetes

+7 tags

AWS Git GitHub CI/CD Anthropic MCP Flutter

2,475

Stars

877

Forks

Maintained

Maintenance

JavaScript