-
Database
Add the indexes my queries actually need
Reads your real queries, finds the lookups doing full collection scans, and adds the right indexes.
Free Prompt
What This Does / How This Helps
Reads your real query code, finds which lookups are scanning entire tables, and adds indexes matched to how the app actually queries. Missing indexes are invisible in development. With fifty rows in the database everything is instant, so the app ships, real data arrives, and page loads climb from 50ms to five seconds as every query reads the whole table. The user_id index alone fixes the most common case: every 'show me my stuff' query scanning everyone else's rows to find yours. You get a per-query justification for each index, compound indexes ordered correctly where queries filter on multiple fields, and before/after query plans where the database supports them.
Want to skip doing this by hand?
Fortivibe audits your app for all of the areas these prompts cover (and more).