suggest_mongo_index
Generate exact MongoDB createIndex commands when a collection scan is flagged or a query filters an unindexed field, with compound/text variants and an explain query to verify.
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 |