opencode

Connect OpenCode to Google BigQuery and Confluence

Give OpenCode your BigQuery and Confluence together and it can provision warehouse resources and document them in the same pass. It creates a dataset, adds the tables and routines, then writes the schema up as a Confluence page and labels it. BigQuery is the system of record for your data, and Confluence is where your team goes to understand it. The agent keeps the two in step so new tables do not ship without a page explaining them.

Loading preview…
Opens a workflow with 83 tools ready to use.

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).

Confluence

45 tools
List Pages

List pages, optionally filtered by space, status, or title.

Get Page

Get a single page by ID, optionally including its body.

Create Page

Create a page in a space.

Update Page

Update a page. Requires the new version number (current + 1).

Delete Page

Trash (or permanently purge) a page.

List Pages in Space

List all pages within a given space.

List Child Pages

List the direct child pages of a page.

Get Page Versions

List the version history of a page.

Get Page Ancestors

Get the ancestor pages (breadcrumb path) of a page.

List Blog Posts

List blog posts, optionally filtered by space or status.

Get Blog Post

Get a single blog post by ID, optionally including its body.

Create Blog Post

Create a blog post in a space.

Update Blog Post

Update a blog post. Requires the new version number (current + 1).

Delete Blog Post

Delete a blog post.

List Spaces

List spaces, optionally filtered by key, type, or status.

Get Space

Get a single space by ID.

Create Space

Create a new Confluence space.

List Space Labels

List labels applied to a space.

List Footer Comments

List footer comments on a page.

Create Footer Comment

Add a footer comment to a page or blog post.

Update Footer Comment

Update the body of a footer comment.

Delete Footer Comment

Delete a footer comment.

List Blog Post Footer Comments

List footer comments on a blog post.

List Inline Comments

List inline (highlight) comments on a page.

Create Inline Comment

Create an inline comment anchored to selected text on a page or blog post.

Update Inline Comment

Update the body of an inline comment.

Delete Inline Comment

Delete an inline comment.

List Blog Post Inline Comments

List inline comments on a blog post.

List Attachments

List attachments on a page.

Get Attachment

Get attachment metadata, including its download link.

Upload Attachment

Upload a file as an attachment to a page (v1 multipart API).

Delete Attachment

Delete an attachment.

List Page Labels

List labels attached to a page.

Add Label

Add a label to content (page or blog post). Uses the v1 API.

Remove Label

Remove a label from content (page or blog post). Uses the v1 API.

List Content Properties

List custom content properties (key/value metadata) on a page.

Create Content Property

Set a custom content property on a page.

Update Content Property

Update an existing content property on a page (requires the property ID and current version).

Delete Content Property

Delete a content property from a page.

List Tasks

List inline tasks (checkboxes) across the site or filtered by space/page.

Get Task

Get a single inline task by ID.

Update Task

Update an inline task (e.g., mark as complete or incomplete).

Search (CQL)

Full-text / structured search via CQL (v1). Returns search results.

Search Content (CQL)

CQL search returning content objects only (v1).

Get Current User

Get the authenticated user's account info (v1).

What you can build

After creating a new BigQuery dataset and its tables, create a Confluence page documenting the schema and add a label to it.
When you retire a stale BigQuery table or routine, post a footer comment on the related Confluence page noting the change.
Provision a fresh reporting dataset and its tables in BigQuery, then create a Confluence space to hold the documentation.
Cancel a runaway BigQuery job, then add an inline comment on the runbook page flagging what happened.

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

Frequently asked questions

Open your OpenCode agent in one click

NoClick runs OpenCode for you with Google BigQuery and Confluence wired in as tools. Connect your account and run.