메뉴
Analyze database queries and recommend missing indexes with performance impact analysis
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
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