Current Workflow Pain Points:
To debug or work on a query (e.g. this query: db.collection("user").find({name: "bob"}).sort({date: -1})), I currently need to perform multiple steps:
1. Locate and select the relevant collection (which opens a new tab).
2. Enter {name: "bob"} in the query field manually.
3. Open the "Options" dropdown to find the sort field.
4. Enter {date: -1} in the sort field.
5. Click "Find" to execute the query.
This process is cumbersome and time-consuming for frequent query modifications or debugging.
Proposed Solution:
Add a real-time, free-text query interface aimed at advanced users would significantly improve the experience. This feature could:
* Automatically re-run the query upon any modifications, streamlining the trial-and-error debugging process.
* Support additional functions like .distinct() or other MongoDB operations without requiring cumbersome conversions from .find() to .aggregate() queries.
While using the MongoDB shell is a potential workaround, it lacks user-friendliness for live query editing and experimentation. A more intuitive interface would greatly enhance productivity and flexibility.
Similar / Related feature requests:
* https://feedback.mongodb.com/forums/924283/suggestions/40604416
* https://feedback.mongodb.com/forums/924283/suggestions/44996128