indexes - Database Index Analysis and Optimization
Analyze database queries and recommend missing indexes with performance impact analysis
Tags
Updated: 2026-02-12Capabilities
Typical Inputs
Typical Outputs
What this skill does
- scan codebase for queries
- analyze query performance
- identify missing indexes
- generate documentation
- create performance metrics
Inputs
- codebase
- database queries
- PostgreSQL environment
- scope arguments
Outputs
- analysis documentation
- index recommendations
- performance metrics
- implementation plan
- monitoring setup
Requirements
- PostgreSQL database
- codebase access
- documentation directory structure