Connect OpenCode to Google BigQuery and Google Docs
Wire BigQuery and Google Docs into OpenCode at once and it can read a spec and build the warehouse to match. It fetches the definition from a Doc, creates the dataset and tables in BigQuery, then writes back what it built. The Doc holds the intent and BigQuery holds the real resources, so the agent turns a written plan into provisioned tables and keeps the document current. You get the loop from spec to schema without hand-copying in either direction.
Tools OpenCode gets
Pick the operations you want and each becomes a tool the agent can call directly while it works.
Google BigQuery
38 toolsRun a SQL query and return results inline (synchronous, bounded by timeout).
Page through the results of a (possibly async) query job.
Start a query / load / extract / copy job (async).
Fetch a job's status and statistics (poll until DONE).
List jobs in a project (filter by state, time range).
Request cancellation of a running job.
Delete a job's metadata.
List datasets in the project.
Fetch dataset metadata.
Create a new dataset.
Full replace of dataset metadata (PUT).
Partial update of dataset metadata (PATCH).
Delete a dataset.
List tables/views in a dataset.
Fetch table metadata/schema.
Create a table or view with a schema.
Partial update of a table (add columns, set expiration, etc.).
Full replace of table metadata (PUT).
Delete a table or view.
Streaming insert of JSON rows into a table (real-time append).
Read rows from a table directly (paginated, no SQL).
List stored procedures / UDFs / TVFs in a dataset.
Fetch a routine definition.
Create a stored procedure / UDF / TVF.
List BigQuery ML models in a dataset.
Fetch BQML model metadata.
Delete a BQML model.
Return the BigQuery service account for the project (KMS/transfer grants).
List projects the caller can access (for project picker UIs).
Restore a dataset within its time-travel window (datasets.undelete).
Replace a routine's full definition (routines.update, PUT).
Delete a routine (routines.delete).
Update mutable BQML model metadata (models.patch).
Get the IAM policy for a table (tables.getIamPolicy).
Set the IAM policy for a table (tables.setIamPolicy).
Test the caller's permissions on a table (tables.testIamPermissions).
List row access policies on a table (rowAccessPolicies.list).
Get a single row access policy (rowAccessPolicies.get).
Google Docs
6 toolsConfiguration for listing documents from Google Drive
Configuration for getting a document
Configuration for creating a new document
Configuration for appending text to a document
Configuration for inserting text at a specific location
Configuration for replacing text in a document
What you can build
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.
Frequently asked questions
More tools for OpenCode
Popular OpenCode pairs
Open your OpenCode agent in one click
NoClick runs OpenCode for you with Google BigQuery and Google Docs wired in as tools. Connect your account and run.