Mongo Query GPT-MongoDB query assistance

Example

To find all documents where 'status' is 'active': ```json { status: 'active' } ```

Scenario

A developer needs to retrieve all active users from the 'users' collection. Mongo Query GPT provides the exact query to be used in the `find` method.

Example

To group documents by 'category' and calculate the total 'sales' for each category: ```json [ { $group: { _id: '$category', totalSales: { $sum: '$sales' } } } ] ```

Scenario

A business analyst needs to generate a report on total sales per category. Mongo Query GPT offers the aggregation pipeline necessary for this task.

Example

To create an index on the 'username' field: ```json { username: 1 } ```

Scenario

A database administrator wants to improve query performance for username searches. Mongo Query GPT provides the command to create the index.