opencode

Connect OpenCode to PostgreSQL

Run OpenCode as a hosted agent in NoClick with PostgreSQL wired into its tools handle. It can use PostgreSQL directly while it works. No glue code, nothing to install. Click below to open a ready-to-run agent and connect your account.

Loading preview…
Opens a workflow with 40 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.

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 SELECT query on a schedule to pull yesterday's sales rows and pass them to a Slack or email node for a daily report.
Execute an INSERT statement to log every incoming form submission or webhook payload into an audit table.
Use the batch execute operation to apply the same UPDATE across hundreds of rows in a single workflow step.
Bulk-import a CSV or API response into a table with the COPY data operation, then verify the load with a row-count query.
Run an EXPLAIN query plan step against a slow query and route the plan into an AI node to suggest a new index.
Wrap a multi-statement change in begin, execute, and commit operations so a partial failure rolls back cleanly.

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

Build a custom OpenCode agentPostgreSQL integration

Open your OpenCode agent in one click

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