Orphex for BigQueryBigQuery and 60+ Platforms MCP
Explore BigQuery, run read-only SQL and load files into tables from your AI assistant. Put your warehouse next to the rest of your marketing stack in the same conversation.
Claude
ChatGPT
Copilot
Grok
Cursor
BigQuery MCP vs Orphex MCP
Go further. Work with BigQuery and 60+ other platforms in one connection, with a preview before any change.
| What you can do | BigQuery MCP |  Orphex MCP |
|---|---|---|
| List datasets and tables; read schemasSee what is in your project before you query | Supported | Supported |
| Run read-only SQLSELECT queries, with a cost estimate first | Supported | Supported |
| Load a file into a tableCSV, XLSX, Parquet or NDJSON, checked before it loads | Not available in this MCP | Supported |
| Use a table as an ad audience sourceSend a table of customers to an ad platform | Not available in this MCP | Supported |
| Preview before any changeSee the before and after before anything is applied | Not available in this MCP | Supported |
| Separate approval stepNothing runs until the change is approved | Not available in this MCP | Supported |
| Work across platformsCompare and act on several platforms in one answer | Not available in this MCP | Supported |
Make your next move.
From a schema question to an approved load. Pick a job and see how Orphex handles it.
What is in our BigQuery project?
Orphex MCPFull context.
Better actions.
Orphex melts data from every platform into one context, so your AI picks the action that fits the whole business, not just one dashboard.
Same question, different results with different context.
“Which customers should we reach this week?”
BigQueryCustomer tableRepeat buyers: 4,812 with consentGoogle AnalyticsConversionsRepeat buyers convert 2.4x betterGoogle AdsPaid searchBrand terms · $1.20 CPC
Meta AdsProspectingCold audience · $42 CPA- 4,812 repeat buyers have marketing consent.Source: BigQuery
- Repeat buyers convert 2.4x better.Source: GA4
- Brand clicks are cheap.Source: Google Ads
- Cold prospecting costs $42 per conversion.Source: Meta Ads
4 sources · BigQuery, GA4, Google Ads, Meta AdsClear answers for your peace of mind.
Frequently asked questions about setup, security, and more.
BigQuery already has an official MCP. Why should I use Orphex?
Google’s BigQuery MCP runs any SQL, including inserts and schema changes. Orphex only runs SELECT queries, and shows the bytes a query would scan before it runs. Orphex adds file loads, audience uploads to ad platforms and the rest of your marketing stack, each with a preview and approval.
Can Orphex change my tables?
Yes, in two ways. Orphex loads a staged file into a table and creates datasets and views, each shown in a preview and applied only after approval. It does not run inserts, updates or deletes.
Will a query cost me money?
Orphex first estimates the bytes a query would scan and runs it only after you approve. BigQuery bills the scan to your own project.
Can I use BigQuery data in ads?
Yes. A table or view with a consent column and an email or phone column can be the source of an audience on a supported ad platform, with counts shown before anything is sent.
Which AI assistants are compatible with Orphex?
Orphex MCP works with Claude, ChatGPT, Grok, Cursor and Microsoft Copilot.
How long does it take to connect BigQuery?
Setup takes just a few minutes. Once you authorize BigQuery through Orphex, your AI assistant is ready to analyze data and prepare changes.
Is Orphex free to use?
Yes, you can start with Orphex for free, connect your platforms and try it with your own data before choosing a plan.
Explore more integrations.
One MCP connection for BigQuery and 60+ other marketing platforms.
Make your next move.
Connect BigQuery. Keep the assistant you already use.