القائمة
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