Which database operations can the agent run?

Only the Postgres operations you allowlist, such as a read-only query operation, plus the Gmail operations you expose like read emails and send email. Leave write operations off the list to keep it read-only.

Do I need to host OpenCode myself?

No. NoClick runs the OpenCode harness for you in a hosted sandbox and connects Gmail and Postgres as tools, with no local setup or self-hosting.

Can it modify or delete data in my database?

Only if you allowlist write or delete operations on the Postgres node. Expose just a query operation and it can read and report but cannot change anything.

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

Wire Gmail and Postgres into OpenCode and it can run queries against your database and email the results, or take what arrives in the inbox and write it into a table. It reads emails, runs SQL you let it run, and sends formatted reports built from query output. The pairing turns the agent into a self-serve reporting and intake layer over your database without a dashboard in between.

Loading preview…

Opens a workflow with 67 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.

Gmail

27 tools

Send Email Message

Configuration for sending an email

Fetch Emails from Inbox

Configuration for reading emails from inbox

Fetch Email Message

Configuration for getting a specific message

Permanently Delete Message

Configuration for permanently deleting a message

Move Message to Trash

Configuration for moving a message to trash

Restore Message from Trash

Configuration for removing a message from trash

Update Message Labels

Configuration for modifying message labels

Reply to Email Message

Configuration for replying to an email

Forward Email Message

Configuration for forwarding an email

Create Email Draft

Configuration for creating a draft

List Email Drafts

Configuration for listing drafts

Fetch Email Draft

Configuration for getting a specific draft

Update Email Draft

Configuration for updating a draft

Delete Email Draft

Configuration for deleting a draft

Send Email Draft

Configuration for sending a draft

List Email Labels

Configuration for listing all labels

Create Email Label

Configuration for creating a label

Fetch Email Label

Configuration for getting a label

Update Email Label

Configuration for updating a label

Delete Email Label

Configuration for deleting a label

List Email Threads

Configuration for listing threads

Fetch Email Thread

Configuration for getting a specific thread

Move Thread to Trash

Configuration for moving a thread to trash

Restore Thread from Trash

Configuration for restoring a thread from trash

Update Thread Labels

Configuration for modifying thread labels

Permanently Delete Thread

Configuration for permanently deleting a thread

Fetch User Profile

Configuration for getting user profile

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

What you can build

Run a SQL query against Postgres and email the results as a formatted report on a schedule

Read incoming emails, parse the fields, and insert a row into a Postgres table for each

Query Postgres for records matching a condition and send each owner a tailored Gmail message

Pull a daily metrics rollup from Postgres and email a summary to the stakeholder list

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