suggest_mongo_index
Generate MongoDB createIndex commands with compound, text, and explain variants to eliminate collection scans and speed up queries on unindexed fields.
Instructions
Generates the exact db.collection.createIndex() command for a MongoDB field, plus compound and text index variants and an explain query to verify. Call this when a collection scan is flagged by the analyzer or when writing a query that filters on an unindexed field. Does not check whether the index already exists.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| field | Yes | Field name to index | |
| collection | Yes | MongoDB collection name |