Indexes you can see, measure and trust
Create, hide and drop indexes, see how often each one is used, and run Index Review to find unused, duplicate and missing indexes.
Index Review flags redundant indexes and the ones your queries are missing.
What you can do with it
Every key type
Create indexes with all key types and options, and drop the ones you no longer need.
Hide before you drop
Hide and unhide indexes to test the impact safely.
Usage statistics
See $indexStats usage for each index.
Live build progress
Follow index builds as they run, per shard through mongos, with the shard key and the index that backs it.
Index Review
Finds missing, duplicate, prefix-redundant, unused and oversized indexes, plus partial and TTL opportunities and collections with too many indexes.
Optional AI commentary
On connections that allow AI, add advice from your own provider to the review.
Atlas Search indexes
Manage Atlas Search and Vector Search indexes on Atlas or Atlas Local deployments.
COLLSCAN badge
The collection tab warns about collection scans and in-memory sorts with a queryPlanner explain that does not run the query.
Related features
Your next query deserves a better IDE.
Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.