MongoDB query compiled from plain English against the ecommerce sample schema, then verified by running it.
{
"type": "aggregation",
"collection": "orders",
"pipeline": [
{},
{},
{}
]
}$lookup — joins the products collection on productIds → _id.$match — filters on status, totalCents.$project — returns only customerId, productIds, totalCents, status, placedAt, products.totalCents stores money as an integer number of cents, so 5000 here means $50.00. Comparing against 50 instead is a common off-by-100 bug.Write this in plain English instead. Mask Databases compiles the sentence above into exactly this query at build time — no AI at runtime, and you can read the output in a diff.
Try it in the playground → No signup, runs in your browser.