phy-db-index-advisor

Static analysis tool that reads your ORM query patterns and predicts which database columns are missing indexes — before a slow query alert fires in production. Works by counting how often each column appears in .filter(), .where(), .order_by(), and JOIN conditions across your entire codebase, then cross-referencing model definitions to suppress columns already indexed.

Why This Exists

• 80% of production slow queries stem from missing indexes on columns used in WHERE clauses
• User.objects.filter(email=email) running 1,000× per minute causes full table scans
• Existing linters don't know your query patterns; EXPLAIN ANALYZE only catches issues after the fact
• This skill finds them before deployment

What It Detects