Menu
Analyze database queries and recommend missing indexes with performance impact analysis
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Basé sur la classification professionnelle SOC
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
| 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