Chat with your BigQuery data

AI to analyze BigQuery data with Claude and ChatGPT

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

BigQuery
You
What were total sales in Q3 from BigQuery?
BigQuery Sales
Q3 sales reached $847,500 across all regions, representing strong quarterly performance.
Via Kondado MCP
You
How much did revenue grow month over month?
BigQuery Growth
Revenue increased by +15.3% compared to last month, showing accelerated growth.
Via Kondado MCP
You
Which product category generated the most revenue?
BigQuery Products
Electronics led with $312,800 in sales, outperforming apparel by 2.4x this quarter.
Via Kondado MCP
You
How many active users did we have yesterday?
BigQuery Users
Yesterday recorded 45,892 active users with an average session duration of 4.2 minutes.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to Analyze BigQuery Data with Claude and ChatGPT

Chat with Claude, ChatGPT, or any MCP client to explore your BigQuery data using natural language. Ask about sales trends across quarters, calculate customer lifetime value from your data warehouse, or compare marketing spend efficiency without writing a single SQL query. The AI reads your replicated BigQuery tables and views to deliver instant analytical answers directly in your chat window.

Kondado exposes BigQuery data through an MCP server, enabling Claude, ChatGPT, and any MCP client to query 1 pipeline of tables and views via natural language chat. The same replicated data also powers ready dashboards in Power BI and Looker Studio.

Marketing analysts use this to investigate attribution models and campaign ROI stored in BigQuery, while finance teams query budget variance across cost centers and revenue recognition patterns. E-commerce managers check product margin trends and inventory turnover by asking simple questions, and operations teams monitor fulfillment metrics and supply chain KPIs. Every answer draws from your actual BigQuery warehouse, updated on a configurable schedule to ensure decisions rely on current information.

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your BigQuery data by Kondado in minutes.

View BigQuery dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your BigQuery data in natural language.

View MCP setup →

The pipeline listed below represents your complete BigQuery warehouse schema available for AI analysis.

The “Tabelas e Views” pipeline contains every table and view from your BigQuery database, unlocking insights across sales transactions, user behavior events, financial records, and operational logs through natural language chat. You can ask Claude to analyze revenue patterns from your transactions data, calculate cohort retention from user events, or summarize monthly expenses from your financial views. Because Kondado maps all available tables and views into this single comprehensive pipeline, you can cross-reference marketing campaign data with sales results, or combine inventory records with order fulfillment metrics for complete business intelligence without switching contexts. Your BigQuery data refreshes on a configurable schedule, ensuring every question in chat references the latest warehouse updates and maintains analytical accuracy.

How to connect BigQuery to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp
Detailed guide: Claude Detailed guide: ChatGPT
AI vocabulary

BigQuery tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

1
Table
∞
Ad-hoc questions
Tabelas e Views
Kondado automatically maps all tables and views available in your database
Full docs on the wiki → Connect BigQuery now →

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

1
Connect BigQuery and Pick Destination

Connect your BigQuery data source on Kondado at app.kondado.com.br and select a Via Kondado destination so your data lands ready for AI access and for the dashboard templates.

2
Add MCP Server in Claude or ChatGPT

In Claude Web or Desktop, or in ChatGPT, add the Kondado MCP server in the connection settings and authorize once via OAuth at app.kondado.com.br. The setup process is identical in both clients and requires no command line commands or JSON configuration.

3
Chat About Data or Open Dashboards

Ask questions in natural language about your BigQuery data to get analytical answers in chat. For visual recurring monitoring, open a ready Power BI or Looker Studio dashboard template powered by the same data.

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mandrill Mandrill
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Apple App Store Apple App Store
Bing Bing
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Hotmart Hotmart
Loja Integrada Loja Integrada
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Olist Tiny Olist Tiny
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
SQLServer SQLServer
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Google Sheets Google Sheets
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Tangerino Tangerino
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

Related on Kondado

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What business questions can Claude or ChatGPT answer about my BigQuery data? ▼
Claude and ChatGPT can answer questions about sales performance trends, customer segmentation analysis, revenue calculations, and operational KPIs stored in your BigQuery warehouse. You might ask about quarterly growth rates, top-performing product categories, customer churn patterns, or cost center budget variances. The AI queries your actual tables and views to return specific numbers and comparisons based on your current data.
How do I configure Claude Web or Desktop to access my BigQuery data through Kondado? ▼
In Claude Web or Claude Desktop, navigate to the connection settings and add the Kondado MCP server using the URL provided. The interface guides you through OAuth authorization at app.kondado.com.br where you grant access to your replicated BigQuery data. No command line tools or code snippets are required for the setup.
How does authentication work when connecting ChatGPT to BigQuery via Kondado? ▼
When you add the Kondado MCP server in ChatGPT's connection settings, the system redirects you to app.kondado.com.br to complete OAuth authorization. You authenticate once to grant the AI read-only access to your replicated BigQuery tables and views. This single authorization covers both Claude and ChatGPT access to your data.
Can the AI write data back to BigQuery or execute actions in my database? ▼
No, the AI interaction is strictly read-only analytical chat. Claude, ChatGPT, and other MCP clients can only query and analyze data that Kondado has replicated from BigQuery; they cannot insert records, update tables, or execute stored procedures. This ensures your warehouse remains protected while enabling flexible data exploration.
How often does the BigQuery data update in the AI chat? ▼
BigQuery data updates on a configurable schedule that you set in Kondado, which could range from near-real-time intervals to daily or weekly refreshes depending on your business needs. Each time you ask a question in chat, the AI references the most recent successful replication of your tables and views. You can check the last update timestamp in your Kondado dashboard to confirm data freshness.
What dashboard templates are available for visualizing BigQuery data? ▼
Kondado offers ready report templates in Power BI and Looker Studio that visualize BigQuery metrics through pre-built charts and graphs. These templates cover common analytical areas like sales performance, financial summaries, and operational dashboards. While the AI answers specific questions in chat, these reports provide recurring visual monitoring of your key metrics.
What is the difference between asking the AI in chat versus opening a ready dashboard? ▼
Asking the AI in chat allows you to explore ad-hoc questions, perform custom calculations, and investigate specific anomalies using natural language without predefined limits. Ready dashboards in Power BI or Looker Studio offer standardized visual reports that update automatically for recurring monitoring of established KPIs. The same underlying BigQuery data powers both experiences, so you can switch between exploratory chat and structured visual reports as needed.

Try out all the features for free for 14 days