Menü
Analyze database queries and recommend missing indexes with performance impact analysis
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
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
Basierend auf der SOC-Berufsklassifikation
| 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