Dataki for MongoDB
Ask MongoDB in plain English
Dataki has no MongoDB connector yet. Export a collection to CSV and upload it, or copy it into BigQuery with Google's Dataflow template, and ask about it in plain English.
Through a file or BigQuery A CSV export, or a copy in BigQuery. The guide takes about 5 minutes.
How many orders did each country place last month?
The United States placed 4,218 orders in August, more than Germany and the UK together.
01Questions
What people ask MongoDB
Each one becomes a query against the MongoDB data, run read-only, with the SQL shown beside the chart so anyone who reads SQL can check it. Anything worth keeping goes on a dashboard that refreshes on its own.
- How many orders did each country place last month?
- Which users have the most documents in the events collection?
- What is the average basket size by month?
- Which records are missing an email address?
02From your assistant
Ask MongoDB from Claude, ChatGPT or Cursor
Dataki runs a hosted MCP server. Add it to your assistant once and it can read the MongoDB data in BigQuery and run read-only queries through Dataki. The assistant gets the rows back; the credentials stay encrypted in Dataki and never reach the model.
Setup for your assistant:
Using the orders export I uploaded to Dataki, chart orders by country for last month.
- list_sources · finds orders.csv
- get_data_context · reads the tables and what the columns mean
- query · runs the SQL read-only, returns the rows
- render_ui · draws the chart from those rows, in the chat
https://dataki.ai/api/mcp 03Setting it up
Getting MongoDB data to Dataki
A CSV export, or a copy in BigQuery. The setup guide covers it step by step.
- Setup
- Five minutes for a CSV export. About 20 for a BigQuery copy.
- Cost
- An upload is free. A Dataflow job is billed by Google for the time it runs.
- Freshness
- As fresh as your last export or job run.
- Best for
- A CSV for one question now. BigQuery for dashboards that should keep working.
The answer is still there tomorrow.
Ask in plain language. Dataki writes the SQL, runs it against your warehouse and draws the chart. Anything worth keeping becomes a dashboard with a link — not a message that scrolls away.
Which channels actually brought in revenue last quarter?
SELECT channel,
SUM(amount) AS revenue
FROM payments
WHERE created_at >= DATE_TRUNC(CURRENT_DATE(), QUARTER)
GROUP BY channel
ORDER BY revenue DESC Revenue by channel
Q3 · 5 rows
- Organic search
- $412,900
- Partner referral
- $268,400
- $151,200
- Paid social
- $96,700
- Direct
- $61,300
One click later, that chart is a dashboard of its own:
Live, not a screenshot. It re-runs the query on a schedule, so the number your team reads on Friday is Friday's number.
- Share the link with anyone. Viewers are free on every plan.
- Edit the SQL by hand whenever the model gets the logic almost right.
- Drop the same dashboard into your own product with one line of HTML.
Using Dataki with MongoDB
- Can I query MongoDB in plain English?
- Yes, through a copy. Dataki has no MongoDB connector, so export a collection to CSV and upload it, or copy it into BigQuery with Google's Dataflow template. Dataki then turns a plain-English question into SQL against that copy and returns a chart, with the query shown.
- How fresh is MongoDB data in Dataki?
- As fresh as the last export or copy. An uploaded CSV is a snapshot, and a BigQuery copy refreshes each time the Dataflow job runs. For a continuous copy, Google's Datastream replicates MongoDB into BigQuery too.
- Can Claude, ChatGPT or Cursor query my MongoDB data?
- Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect MongoDB to Dataki, add that URL as a connector in Claude or ChatGPT (or in Cursor, VS Code or Claude Code with a Dataki key), and the assistant can read the schema and run read-only queries. It gets the rows back; the credentials stay encrypted in Dataki and are never handed to the model.