suggest_mongo_index
Generates MongoDB createIndex commands for fields flagged by collection scans. Includes compound, text, and explain query variants.
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 |