Triagic + BigQuery: ticket investigations over your database, read-only
Query datasets and inspect table schemas. Writes are not blocked. Use a service account limited to read-only roles. Triagic connects to BigQuery from the desktop app on each member's machine, with a credential you configure, and shows every call it makes while it investigates a ticket. Nothing is copied out of BigQuery.
What you can ask
- Look up account acme-labs in BigQuery and tell me why their last export failed
- In BigQuery, how many orders for org 8412 are stuck in a non-terminal state right now?
- Which rows in BigQuery changed for user 51930 in the last 24 hours?
- Compare the BigQuery record for invoice INV-2291 with what the customer says they see
- Does BigQuery show the same plan for this account as the billing system does?
What the agent can do
These are the 2 tools Triagic exposes from the BigQuery MCP server. Anything else the server lists is dropped at connect time.
- list-tables
- describe-table
Connect in three steps
- 1
Mint a read-only credential in BigQuery
Create a dedicated user or token that can only read. Only list-tables and describe-table are exposed; the SQL tool is not, and the service account's Data Viewer and Job User roles are the boundary.
- 2
Add it in the Triagic portal
Integrations, then Add shared data source, then BigQuery.
- Project ID
- Location: Where the datasets live: a multi-region (US, EU) or a region like europe-west9.
- 3
Let a desktop pick it up
Saving validates the shape of what you typed. The first desktop app to sync starts BigQuery locally and reports running or degraded with the error text.
Field-by-field setup, TLS options and the error table: BigQuery in the docs.
Read-only, by construction
Only list-tables and describe-table are exposed; the SQL tool is not, and the service account's Data Viewer and Job User roles are the boundary.
FAQ
- Can Triagic change anything in BigQuery?
- No. Only list-tables and describe-table are exposed; the SQL tool is not, and the service account's Data Viewer and Job User roles are the boundary. Give it a read-only credential as well, so the guarantee does not rest on one layer.
- What do I need to connect BigQuery?
- Project ID, Location. The desktop app on a member's machine starts the connection; the portal never holds a live process.
- Does BigQuery cost extra?
- No. Every connector is included in the seat price. Start a 14-day trial without a card.
Related integrations
- MongoDBQuery collections and inspect documents behind a ticket.
- PostgreSQLBrowse schemas and run read-only SQL against a Postgres database.
- MySQLBrowse every database, table and schema the credentials can reach. Read-only: there is no tool that runs a statement you write.
- RedisInspect keys and cached values. Read-only: the server's write tools are not exposed.
Try it on your own BigQuery
No card. Install the desktop app, connect BigQuery read-only, and triage a real ticket this afternoon.