indexes - Database Query Optimization and Missing Index Analysis
Analyzes database queries and recommends missing indexes with performance impact assessment
Tags
Updated: 2026-02-12Capabilities
Typical Inputs
Typical Outputs
What this skill does
- scan codebase for SQL queries
- analyze query performance patterns
- identify missing index candidates
- generate performance impact reports
- create database documentation
Inputs
- codebase directory
- SQL query patterns
- database schema information
- performance requirements
Outputs
- index recommendations document
- query analysis reports
- performance metrics comparison
- implementation plan
- monitoring setup guide
Requirements
- PostgreSQL database
- codebase access
- database query logs
- sufficient disk space