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 on Google BigQuery and returns a chart. The query is shown with every result, so you can check or edit it.

Is there a hosted Google BigQuery MCP server?

Yes, Dataki. Its remote MCP server reaches Google BigQuery through a read-only connection you set up once in Dataki: nothing to install, and no connection string in your assistant's config. Assistants can list sources, read the schema and what it means, 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 save the answer as a dashboard widget. Dataki queries Google BigQuery live, so there is no pipeline to build, no warehouse to sync and no copy of your data to maintain.

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 your assistant can read the schema and run read-only queries. It works with the results, while your credentials stay encrypted in Dataki and never reach the model.

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…

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

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.

list_sources · finds BigQuery · analytics
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

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

Live dashboards

Every answer can become a live dashboard.

Ask in plain English. Dataki writes the SQL, runs it on your database and charts the answer. Keep it as a dashboard with its own link, and your team sees current numbers every time they open it.

app.dataki.ai/dashboards/revenue-by-channel BigQuery · analytics

3 views · Updated just now

One click turns the answer into a dashboard:

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

Always current. The query runs again whenever the dashboard opens, so Friday's meeting sees Friday's numbers.

Share it: Send the link to anyone. Viewers are free on every plan.
Refine it: The SQL is always visible. Adjust it by hand or ask for a change.
Embed it: Put the same dashboard in your own product with two HTML tags.

Start free More on dashboards

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 on Google BigQuery and returns a chart. The query is shown with every result, so you can check or edit it.
Is there a hosted Google BigQuery MCP server?: Yes, Dataki. Its remote MCP server reaches Google BigQuery through a read-only connection you set up once in Dataki: nothing to install, and no connection string in your assistant's config. Assistants can list sources, read the schema and what it means, 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 save the answer as a dashboard widget. Dataki queries Google BigQuery live, so there is no pipeline to build, no warehouse to sync and no copy of your data to maintain.
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 your assistant can read the schema and run read-only queries. It works with the results, while your credentials stay encrypted in Dataki and never reach the model.

Product

Solutions

Resources