AI Database Copilot for Software Developers & Engineers.

db.users.aggregate([
  {
    $match: {
      createdAt: {
        $gte: new Date(Date.now() - 7 * 24 * 60 * 60 * 1000)
      }
    }
  },
  {
    $lookup: {
      from: "orders",
      localField: "_id",
      foreignField: "userId",
      as: "userOrders"
    }
  },
  {
    $match: {
      userOrders: { $size: 0 }
    }
  },
  {
    $project: {
      _id: 1,
      email: 1,
      createdAt: 1
    }
  }
])

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

const params = {
  TableName: "Orders",
  KeyConditionExpression: "#pk = :pk AND #sk >= :thirtyDaysAgo",
  ExpressionAttributeNames: {
    "#pk": "customerId",
    "#sk": "orderDate"
  },
  ExpressionAttributeValues: {
    ":pk": "customer-123",
    ":thirtyDaysAgo": new Date(Date.now() - 30 * 86400000).toISOString()
  }
};
await docClient.send(new QueryCommand(params));

const snapshot = await db.collection("tickets")
  .where("status", "==", "pending")
  .count()
  .get();

console.log("Pending tickets:", snapshot.data().count);