Ask your database in plain English

Even with a point-and-click query builder, some questions are faster to just say: “shipped orders over $500 this year, newest first.” DataStudio’s built-in AI assistant turns that sentence into a real MongoDB query — and drops it straight into your query editor, ready to run.

Type the question, get the query

Open the assistant, type /query followed by what you want — find all active customers in NC created this year, sorted by name — and it generates the matching filter, projection, and sort. The result lands directly in the Query and Sort boxes, scoped to the collection you’re viewing, so the field names match your real schema. Review it, hit Run, done.

It also handles aggregations: ask for total revenue by payment method and it writes the pipeline.

Your data never leaves the browser

The part that matters most: the model runs on-device. DataStudio uses your browser’s built-in AI (Gemini Nano) — so your prompts, your schema, and your results are processed locally. Nothing is shipped to a third-party API, nothing is logged on someone else’s server. You get natural-language querying without sending your database structure or contents to the cloud.

Who it’s for

Anyone who knows what they want but not the exact MongoDB syntax — analysts, support, ops — plus engineers who’d rather describe a query than hand-write a $match/$group. It meets you where you are: a starting point you can read, tweak, and run.

Try it on your own data

The AI assistant is built into DataStudio — no setup, no API keys.

Start your free 30-day trial → — no credit card required. Or browse the full DataStudio walkthrough on our YouTube channel.