MongoDB AI Query Generator — plain English to MQL.

Generated MongoDB query

db.orders.aggregate([
  {
    $match: {
      createdAt: {
        $gte: new Date(new Date().getFullYear(), new Date().getMonth(), 1)
      }
    }
  },
  {
    $group: {
      _id: "$customerId",
      totalSpent: { $sum: "$amount" }
    }
  },
  { $sort: { totalSpent: -1 } },
  { $limit: 10 }
])

Groups orders by customer, sums their spending this month, and returns the top 10 sorted by amount descending.

Generated MongoDB query

db.orders.countDocuments({
  createdAt: {
    $gte: new Date(Date.now() - 7 * 24 * 60 * 60 * 1000)
  }
})

Uses countDocuments with a date filter to count orders in the last 168 hours.

Generated MongoDB query

db.users.aggregate([
  {
    $lookup: {
      from: "orders",
      localField: "_id",
      foreignField: "userId",
      as: "orders"
    }
  },
  { $match: { orders: { $size: 0 } } },
  { $project: { email: 1, createdAt: 1 } }
])

Joins the users collection with orders, then filters for users who have zero associated orders.

Generated MongoDB query

db.orders.aggregate([
  {
    $group: {
      _id: "$status",
      count: { $sum: 1 }
    }
  },
  { $sort: { count: -1 } }
])

Groups every order document by its status field and counts how many fall into each category.

Generated MongoDB query

db.orders.aggregate([
  { $unwind: "$items" },
  {
    $group: {
      _id: "$items.productId",
      totalRevenue: { $sum: { $multiply: ["$items.price", "$items.quantity"] } }
    }
  },
  { $sort: { totalRevenue: -1 } },
  { $limit: 5 }
])

Unwinds line items, multiplies price by quantity, groups by product, and returns the top 5.

Generated MongoDB query

db.users.find({
  createdAt: { $gte: new Date(Date.now() - 30 * 24 * 60 * 60 * 1000) },
  emailVerified: false
})

A simple find query combining a date range filter with a boolean field check.

Generated MongoDB query

db.products.distinct("category")

Returns a deduplicated array of every unique category value in the products collection.

Generated MongoDB query

db.orders.aggregate([
  {
    $match: {
      createdAt: { $gte: new Date(Date.now() - 30 * 24 * 60 * 60 * 1000) }
    }
  },
  {
    $group: {
      _id: "$userId",
      orderCount: { $sum: 1 }
    }
  },
  { $match: { orderCount: { $gt: 3 } } }
])

Filters recent orders, groups by user, counts each user's orders, then filters for those with more than 3.