Can the agent run changes inside a transaction?

Begin Transaction and Commit Transaction are available, so it can wrap a multi-step change and commit only when every step succeeds. Add both to the allowlist if you want it managing transaction boundaries.

Can it install extensions or alter my schema?

Install Extension, Create Schema, and Create Index are in the list, and each of those changes your database. Expose them only when you want the agent making structural changes, and leave them off for read and copy work.

How does the Postgres credential stay safe?

It uses the Postgres credential you connect, which resolves server-side at run time. The connection string is never passed to the model, so the agent works with your access without holding it.

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 Docs and PostgreSQL

Give OpenCode your Google Docs and Postgres together and it can run a database change and document it in the same task. It analyzes tables, copies data in and out, creates schemas and indexes, and wraps multi-step work in a transaction, then writes what it did into a Google Doc. Postgres is the database and Google Docs is where the runbook lives, so every change comes with a record.

Loading preview…

Opens a workflow with 46 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 Docs
A preset of real Google Docs operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Pick what it can do in PostgreSQL
A preset of real PostgreSQL operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect Google Docs
One sign-in. The agent acts through your account, scoped to the operations you picked.
Connect PostgreSQL
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 Docs

6 tools

List Google Drive Documents

Configuration for listing documents from Google Drive

Fetch Document Content

Configuration for getting a document

Create New Document

Configuration for creating a new document

Append Text to Document

Configuration for appending text to a document

Insert Text in Document

Configuration for inserting text at a specific location

Replace Document Text

Configuration for replacing text in a document

PostgreSQL

40 tools

Run Select Query

Execute a SELECT query and return results as JSON

Execute Sql Statement

Execute an INSERT, UPDATE, DELETE, or other non-SELECT statement

Execute Batch Statements

Execute a statement with multiple parameter sets (batch operations)

Run Query with Cursor

Execute query with cursor for large result sets

Copy Data to Table

Bulk import data to a table using COPY

Copy Data from Table

Bulk export data from a table using COPY

List Schema Tables

List all tables in a schema

List Table Columns

Get column metadata for a table

Get Table Info

Get detailed information about a table including constraints and indexes

Create Table

Create a new table

Drop Table

Drop a table

Truncate Table

Truncate a table (remove all rows)

List Schemas

List all schemas in the database

Create Schema

Create a new schema

Drop Schema

Drop a schema

List Databases

List all databases in the PostgreSQL server

List Schema Indexes

List all indexes in a schema

Create Index

Create an index on a table

Drop Index

Drop an index

List Schema Views

List all views in a schema

Create View

Create a view

Drop View

Drop a view

List Schema Sequences

List all sequences in a schema

Get Sequence Next Value

Get the next value from a sequence (nextval)

Get Sequence Current Value

Get the current value from a sequence (currval)

Set Sequence Value

Set the current value of a sequence (setval)

List Schema Functions

List all functions in a schema

Call Database Function

Call a PostgreSQL function

List Table Constraints

List all constraints for a table

List Schema Triggers

List all triggers in a schema

List Extensions

List all installed extensions

Install Extension

Create/install an extension

List Database Users

List all database users

List Database Roles

List all database roles

Explain Query Plan

Explain a query's execution plan

Vacuum Table

Vacuum a table to reclaim storage and update statistics

Analyze Table Statistics

Analyze a table to update statistics

Begin Transaction

Begin a new transaction

Commit Transaction

Commit the current transaction

Rollback Transaction

Rollback the current transaction

Starting points

What you can build

Copy data out of a Postgres table and write a summary of it into a new Google Doc.

Read a migration plan from a Google Doc and run it in Postgres inside a transaction, committing only when it finishes.

Analyze table statistics in Postgres and append the findings to a performance doc.

Create a schema and index in Postgres, then document the change in a runbook Google Doc.

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