Dataki for Firebase
Ask Firebase in plain English
Ask Firebase Analytics and Crashlytics questions in plain English. Firebase's free BigQuery export puts active users, releases and crashes one question away.
Through BigQuery Firebase's BigQuery export. The guide takes about 5 minutes.
Which release crashed on the most devices this week?
4.12.0 crashed on 1,284 devices this week, nearly four times the release before it.
01Questions
What people ask Firebase
Each one becomes a query against the Firebase 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.
- Which release crashed on the most devices this week?
- How many daily active users did each app version have?
- What share of users on Android 14 hit a fatal crash?
- How many users opened the app each day since the last release?
02From your assistant
Ask Firebase from Claude, ChatGPT or Cursor
Dataki runs a hosted MCP server. Add it to your assistant once and it can read the Firebase 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:
From the Crashlytics export, which issues affected the most users in the latest release?
- list_sources · finds BigQuery · firebase_crashlytics
- 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 Firebase data to Dataki
Firebase's BigQuery export. The setup guide covers it step by step.
- Setup
- About 5 minutes. Analytics arrives within 24 hours; the first Crashlytics and Performance export can take up to 48.
- Cost
- Linking is free and works on the Spark plan, inside the BigQuery sandbox. Blaze adds full BigQuery and Crashlytics streaming.
- History
- From the day you link. Earlier data is not available for export.
- You need
- Owner or Firebase Admin on the project. Turning on Analytics export also needs Editor on the linked GA property.
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.
3 views · Updated just now
One click turns the answer into a dashboard:
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.
Using Dataki with Firebase
- Can I query Firebase in plain English instead of writing SQL?
- Yes. Dataki works with Firebase through its BigQuery dataset (Firebase's BigQuery export). Ask in plain English and Dataki writes the SQL against that dataset, runs it and returns a chart. The query is shown with every result, so you can check or edit it.
- How do I build a dashboard from Firebase data without an ETL pipeline?
- Follow the Firebase setup guide once and your data lands in BigQuery automatically, with no pipeline to maintain. Connect that dataset to Dataki, ask your question and save the answer as a dashboard widget. Dataki queries the dataset live, so the dashboard is always as fresh as the export.
- Can Claude, ChatGPT or Cursor query my Firebase data?
- Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect Firebase 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.