App

Google BigQuery integrations

Connect Google BigQuery to any other app, or use it from your AI client over MCP. BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Connects with OAuthgoogle.com

What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.

Build solutions, not workarounds.

What do you want to automate with Google BigQuery?

Ask the assistant

You'll sign in before anything runs. What you typed comes with you.

Connect your AI client

Give your AI client this address.

https://mcp.apiant.ai

Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.

Set it up in your client
Claude Code

Run this in the directory you want to work in.

claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai

Start Claude Code there, approve the server, and sign in in the browser page it opens.

Claude Code guide (opens in a new tab)
Claude, web and desktop

Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.

Setup guide (opens in a new tab)
Cursor

Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.

Setup guide (opens in a new tab)
Zed

Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.

Setup guide (opens in a new tab)
Codex and the ChatGPT desktop app

Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.

Setup guide (opens in a new tab)
Any other MCP client

Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.

Setup guide (opens in a new tab)

Pair it

Connect Google BigQuery with another app

What your agent can do with Google BigQuery

Triggers and actions 4 triggers · 10 actions

  • Trigger
    New Job Completed

    Triggers when a BigQuery job in the project finishes, whether it succeeded or failed.

  • Trigger
    New Row

    Triggers when a new row is added to a table. New rows are detected by a column you name that increases for newer rows, such as a creation time or a sequential ID.

  • Trigger
    Query Job Completed (With Row Data)

    Triggers when a SELECT query job in the project finishes successfully, and includes its result rows.

  • Trigger
    Updated Row

    Triggers when a row in a table is added or changed, detected by a last-updated timestamp column you name.

  • Action
    Create Row

    Creates a new row of data in a table. Note: Does not create a job.

  • Action
    Create Rows

    Creates new rows of data in a table (accepts line items). Note: Does not create a job.

  • Action
    Delete Rows

    Deletes every row in a table whose match column equals the value you give.

  • Action
    Find One Row

    Finds the first row in a table whose column equals the value you give.

  • Action
    Get Rows for Job Completed

    Returns the result rows of a finished query job.

  • Action
    Import Data

    Imports a JSON, CSV, Avro or Parquet file from Cloud Storage into a table. Waits up to about 40 seconds for the import to finish; larger imports keep running in BigQuery and return state RUNNING.

  • Action
    List Datasets

    Returns the datasets in a Google Cloud project.

  • Action
    List Tables

    Returns the tables in a BigQuery dataset.

  • Action
    Run a Query

    Runs a SQL query against a table in BigQuery.

  • Action
    Update Row(s)

    Updates every row in a table whose match column equals the value you give, setting the columns you choose.

Reviews

What our customers say

Questions

Google BigQuery, answered

Is there a Google BigQuery MCP server?

APIANT's MCP server at https://mcp.apiant.ai works with Google BigQuery. Add that address to any AI client that takes a remote MCP server, sign in once in your browser, and your client can build, test and run automations that use Google BigQuery. Nothing to install.

What can start an automation from Google BigQuery?

Any of Google BigQuery's 4 triggers in the catalog, including New Job Completed, New Row, Query Job Completed (With Row Data) and Updated Row. Describe the moment in plain language and your agent picks the right one.

What can your agent do in Google BigQuery?

Any of Google BigQuery's 10 actions, including Create Row, Create Rows, Get Rows for Job Completed and Update Row(s). Your agent maps the data both ways and tests every scenario before it ships.

Which apps can Google BigQuery connect to?

Any app in the catalog; the list on this page pairs Google BigQuery with each of them. If the other app is missing, point your agent at its API documentation and it builds the connector.

What happens when something fails?

Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.

Is there a free plan?

Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.