Can NoClick run a SQL query in BigQuery and use the results?

Yes. The node submits your query as a job with Insert Job and reads the output with Get Query Results, so a workflow can run SQL and hand the rows to the next step. You can also check progress with Get Job or stop a running query with Cancel Job.

How do I connect BigQuery to NoClick?

You authorize the node with your Google account, and it calls the BigQuery REST API for your Google Cloud project. From there it can reach your datasets, tables, jobs, and routines. It can also return the project's BigQuery service account with Get Service Account when you need it for permissions.

Can a workflow react to a scheduled query in BigQuery?

Yes. The On Scheduled Query Results trigger starts a workflow when a scheduled query produces results, so fresh data can flow into Slack, a spreadsheet, or another system without polling. Pair it with Get Query Results to read the exact rows the query returned.

Can it create and delete datasets and tables?

It creates datasets and tables, reads their metadata with Get Dataset and Get Table, lists datasets, and deletes datasets and tables when you need to tear them down. That makes it easy to stand up scratch tables for a pipeline and clean them up when the run finishes.

Does the node handle routines and models?

Yes. It manages routines with Create Routine, Get Routine, and Delete Routine, and it can read a model with Get Model or remove one with Delete Model. For governance, it also inspects a table's IAM policy and row access policy so you can audit who can see what.

What makes OpenCode different here?

OpenCode is open and model-agnostic, so you have flexibility over the underlying model. NoClick handles running it and connecting your apps as tools.

How do I give OpenCode tools?

Connect an integration node to the agent's tools handle and choose the operations to allow. Each becomes a tool the agent can call.

Do I manage any infrastructure?

No. NoClick runs the OpenCode harness in a hosted sandbox and resolves credentials for the apps you connect.

Can it combine several apps?

Yes. Add as many integrations as you need and the agent can use them together in one run.

Connect OpenCode to Google BigQuery

Give an AI agent your BigQuery as a tool and it can query the warehouse itself instead of asking you to. It submits SQL jobs, reads the query results, creates tables and datasets, and checks or cancels job status on its own, calling each operation as a tool while it works through a task. Wire it into a coding agent in NoClick and it can investigate data, build a table, and load results without a human running each query.

Loading preview…

Opens a workflow with 38 tools ready to use.

What happens next

Set up in minutes

The open button drops you into a guided setup. It asks exactly this, nothing else:

Choose where it runs
On your computer through your own OpenCode, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in Google BigQuery
A preset of real Google BigQuery operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect Google BigQuery
One sign-in. The agent acts through your account, scoped to the operations you picked.
Add your personal MCP link
The last step mints a private MCP URL for this agent and walks you through exactly this, with your real link filled in. The page flips to Connected the moment your OpenCode first calls in.
1. Run this in your terminal
$opencode mcp add
2. Choose Remote and paste your server URL
https://mcp.noclick.app/s/<your-link>
3. Choose No when asked about OAuth authentication — the link itself is the key
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools OpenCode gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Google BigQuery

38 tools

Run Query

Run a SQL query and return results inline (synchronous, bounded by timeout).

Get Query Results

Page through the results of a (possibly async) query job.

Insert Job

Start a query / load / extract / copy job (async).

Get Job

Fetch a job's status and statistics (poll until DONE).

List Jobs

List jobs in a project (filter by state, time range).

Cancel Job

Request cancellation of a running job.

Delete Job

Delete a job's metadata.

List Datasets

List datasets in the project.

Get Dataset

Fetch dataset metadata.

Create Dataset

Create a new dataset.

Update Dataset

Full replace of dataset metadata (PUT).

Patch Dataset

Partial update of dataset metadata (PATCH).

Delete Dataset

Delete a dataset.

List Tables

List tables/views in a dataset.

Get Table

Fetch table metadata/schema.

Create Table

Create a table or view with a schema.

Patch Table

Partial update of a table (add columns, set expiration, etc.).

Update Table

Full replace of table metadata (PUT).

Delete Table

Delete a table or view.

Stream Insert Rows

Streaming insert of JSON rows into a table (real-time append).

List Table Data

Read rows from a table directly (paginated, no SQL).

List Routines

List stored procedures / UDFs / TVFs in a dataset.

Get Routine

Fetch a routine definition.

Create Routine

Create a stored procedure / UDF / TVF.

List Models

List BigQuery ML models in a dataset.

Get Model

Fetch BQML model metadata.

Delete Model

Delete a BQML model.

Get Service Account

Return the BigQuery service account for the project (KMS/transfer grants).

List Projects

List projects the caller can access (for project picker UIs).

Undelete Dataset

Restore a dataset within its time-travel window (datasets.undelete).

Update Routine

Replace a routine's full definition (routines.update, PUT).

Delete Routine

Delete a routine (routines.delete).

Patch Model

Update mutable BQML model metadata (models.patch).

Get Table IAM Policy

Get the IAM policy for a table (tables.getIamPolicy).

Set Table IAM Policy

Set the IAM policy for a table (tables.setIamPolicy).

Test Table IAM Permissions

Test the caller's permissions on a table (tables.testIamPermissions).

List Row Access Policies

List row access policies on a table (rowAccessPolicies.list).

Get Row Access Policy

Get a single row access policy (rowAccessPolicies.get).

Starting points

What you can build

When a scheduled query finishes, take its results and post a summary to your team channel automatically.

Run a SQL job on a schedule, wait for it to complete, then read the query results into the next step for reporting.

Spin up a fresh dataset and tables at the start of a pipeline, then delete the dataset once the run is done.

Let an AI step turn a plain-English request into SQL, submit it as a job, and return the answer from the results.

Cancel a long-running BigQuery job automatically when a workflow detects it has been running past its budget.

Before a nightly load, check a table's metadata and IAM policy so the workflow only writes when the schema and permissions match what you expect.

Meet the runner

About OpenCode

OpenCode is an open, model-agnostic command-line coding agent. In NoClick it runs hosted and gains your apps as tools, so it can act on real systems rather than just edit files. Wire an integration into the agent and OpenCode can use that app’s operations directly while it works. It is a flexible choice when you want an open agent with broad model support and real tool access.

Open and model-agnostic

Flexible across many underlying models

Good general-purpose tool use

Lightweight to point at a focused task

Good to know