awesome-claude-code-toolkit/plugins/database-optimizer/commands/analyze-query.md at main - awesome-claude-code-toolkit - WEVAL Git

yanis/awesome-claude-code-toolkit

Files

Rohit Ghumare c3f43d8b61 Expand toolkit to 135 agents, 120 plugins, 796 total files

- Add 60 new agents across all 10 categories (75 -> 135)
- Add 95 new plugins with command files (25 -> 120)
- Update all agents to use model: opus
- Update README with complete plugin/agent tables
- Update marketplace.json with all 120 plugins

2026-02-04 21:08:28 +00:00

637 B

Raw Permalink Blame History

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

Steps

Identify the slow or problematic query:
Run EXPLAIN (or EXPLAIN ANALYZE) on the query:
Analyze common performance issues:
Check for lock contention:
Suggest optimizations:
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.