Google BigQuery logo

Dataki for Google BigQuery

Ask Google BigQuery in plain English

Ask BigQuery questions in plain English. Dataki writes GoogleSQL, runs it in your own project with a read-only service account and charts the answer — in the browser or from Claude, ChatGPT or Cursor.

Connects directly A read-only service account in your project.

Connect Google BigQuery Read the setup guide
app.dataki.ai / chat BigQuery · analytics

Which acquisition channels drove the most revenue this quarter?

Reading the schema, writing the query…
SQL 700 ms · 840 MB scanned 
SELECT channel, SUM(amount) AS revenue
FROM   analytics.orders
WHERE  DATE(created_at) >= DATE_TRUNC(CURRENT_DATE(), QUARTER)
GROUP BY channel ORDER BY revenue DESC
Revenue by channel Q3 · 5 rows
Organic searchPaid searchPartner referralEmailPaid social $0$100k$200k$300k$400k

Organic search drove $386k this quarter, 39% of all revenue.

01Questions

What people ask Google BigQuery

Each one becomes a query against Google BigQuery, 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.

  • Which acquisition channels brought in the most revenue this quarter?
  • Which products had the highest return rate last quarter?
  • What is the 30-day retention of users who signed up in August?
  • Which products were most often bought together last month?

02From your assistant

Ask Google BigQuery from Claude, ChatGPT or Cursor

Dataki runs a hosted MCP server. Add it to your assistant once and it can read your Google BigQuery schema and run read-only queries through Dataki. The assistant gets the rows back; the Google BigQuery credentials stay encrypted in Dataki and never reach the model.

Setup for your assistant:

Claude · dataki (MCP) BigQuery · analytics

From the analytics dataset, chart revenue by channel for the last four quarters and save it to a dashboard.

  1. list_sources · finds BigQuery · analytics
  2. get_data_context · reads the tables and what the columns mean
  3. query · runs the SQL read-only, returns the rows
  4. render_ui · draws the chart from those rows, in the chat
server URL streamable http
https://dataki.ai/api/mcp

03Setting it up

Connecting Google BigQuery

A read-only service account in your project. The setup guide covers it step by step.

Setup
About 5 minutes.
Access
A service account named Dataki, with BigQuery Data Viewer and BigQuery Job User on the project. It reads tables and runs queries; neither role can change your data.
Cost
Queries are billed to your project at BigQuery's own prices. The first 1 TiB of queries each month is free.
What it reads
The tables and views of the datasets you ask about, nested fields and descriptions included.
Read the Google BigQuery guide Open Dataki

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.

app.dataki.ai / chat

Which channels actually brought in revenue last quarter?

Queried bigquery · payments · 1.2 GB scanned 
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
Email
$151,200
Paid social
$96,700
Direct
$61,300

One click later, that chart is a dashboard of its own:

app.dataki.ai/d/revenue-by-channel

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.
Start free See how it works

Using Dataki with Google BigQuery

Can I query Google BigQuery in plain English instead of writing SQL?
Yes. Dataki reads your Google BigQuery schema, turns a plain-English question into a query, runs it against Google BigQuery and returns a chart. The generated query is shown with every result, so you can verify or edit it.
Is there a hosted Google BigQuery MCP server?
Dataki is one. Its remote MCP server reaches Google BigQuery through a read-only connection you set up once in Dataki, so nothing is installed on your machine and no connection string goes into an assistant's config. It offers tools to list sources, read the schema and its documented meaning, run read-only SQL, draw charts in the conversation and save dashboards. Every query is logged with the key that ran it.
How do I build a dashboard from Google BigQuery data without an ETL pipeline?
Connect Google BigQuery to Dataki with a read-only connection, ask your question, and keep the answer as a dashboard widget. Dataki queries Google BigQuery directly at read time, so there is no pipeline to build, no warehouse to sync into and no copy of your data to keep current.
Can Claude, ChatGPT or Cursor query my Google BigQuery data?
Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect Google BigQuery 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.