/analyze-query

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

BOOST

rohitg00@rohitg00

GitHub

From plugin

rohitg00-claude-code-toolkit

2.8k199 skills138 agents199 commands

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

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 ↗

Stats

Python JavaScript React CSS Kubernetes AWS Git GitHub CI/CD Anthropic MCP Flutter

2,827

Stars

1,095

Forks

Quiet

Maintenance

JavaScript

Language

Apache-2.0

License

6mo ago

Last commit

9mo ago

Created

Repo: rohitg00/awesome-claude-code-toolkit

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.

2.8k40 skills138 agents

Get the whole plugin

Stars on GitHub