Back to Prompts
Coding Assistant

Audit My Database for Missing Indexes

For a full health check on an app that's been running a while From the Database Indexing AI Coding Building Block.

Prompt 
My [app] has grown and I want to make sure I'm not missing important database indexes.

Review my models/schema and:
- List every column that appears in WHERE, ORDER BY, or JOIN clauses
- Identify which of those columns are missing indexes
- Recommend composite (multi-column) indexes for queries that filter on multiple fields at once
- Flag any indexes I already have that might be unnecessary or redundant
- Prioritize the fixes by biggest performance impact

My stack: [your language and framework here]
Here are my models/schema: [paste your models or schema file]

I'm learning, so explain each part simply.
1 views 0 copies