Menu
Analyze database queries and recommend missing indexes with performance impact analysis
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Analyze recent changes and add test coverage for HEAD commit
Write failing unit tests for feature requirements (TDD style)
Deep analysis mode - thorough multi-phase investigation with expert consultation
Analyze test coverage gaps and report findings
Analyze service capacity, load patterns, and scaling requirements
Code review mode - comprehensive review with security, performance, and maintainability focus
Based on SOC occupation classification
| name | indexes |
| description | Analyze database queries and recommend missing indexes with performance impact analysis |
Current Time: !date
PostgreSQL: !psql --version
Scope: $ARGUMENTS (or entire codebase if not specified)
Scan whole codebase and tell me what indexes are missing.
Create comprehensive database analysis documentation at:
docs/tasks/backend/DD-MM-YYYY/<semantic-db-id>/Documentation Structure:
README.md - Database analysis overview and objectivesquery-analysis.md - Detailed query performance analysisindex-recommendations.md - Missing indexes and impact analysisperformance-metrics.md - Before/after performance comparisonsimplementation-plan.md - Index creation strategy and migration planmonitoring-setup.md - Performance monitoring and alertingSemantic Database Task ID Examples:
user-query-optimizationorder-performance-indexessearch-query-accelerationrelationship-index-analysisslow-query-investigationPlease analyze all database queries, identify missing indexes, and document recommendations according to the standards above.
$ARGUMENTS