Which Postgres and Sheets operations does it get?

Only the ones you allowlist. Allow a read query plus writing to a sheet and that is the full set of tools the agent can use.

Is there anything to install or run myself?

No. NoClick hosts the Codex harness and connects Google Sheets and Postgres as tools automatically.

Can it modify or delete data in my database?

Only if you allowlist a write operation. Connect a read-only Postgres role to keep it to queries that cannot change your data.

How does Codex get access to my apps?

You connect an integration to the agent's tools handle and select which operations to expose. Codex then calls those operations as tools, authenticated with the credentials you connect in NoClick.

Is this the same Codex CLI?

Yes. NoClick runs the Codex harness for you and adds your connected apps as tools. You do not have to install or manage anything locally.

Can I trigger a Codex agent automatically?

Yes. Because it runs hosted, you can start it from a schedule, a webhook, or another app event, not just by hand.

Which apps can I connect?

Any of NoClick’s tool-provider integrations, from Slack and Linear to GitHub, Notion, Google Sheets, Postgres, and dozens more.

Codex

Connect Codex to Google Sheets and PostgreSQL

When Google Sheets and Postgres are both wired into Codex, it can pull live data from your database and shape it in a spreadsheet, or read a sheet and load it into your tables. It can run a SQL query and write the results into Sheets for a report, or take edits from a sheet and update Postgres rows to match. The combination turns a spreadsheet into a working interface over your database.

Loading preview…

Opens a workflow with 59 tools ready to use.

Tools Codex gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Google Sheets

19 tools

Read Sheet Data

Configuration for reading data from a Google Sheet

Write Sheet Data

Configuration for writing data to a Google Sheet

Append Rows to Sheet

Configuration for appending rows to a Google Sheet

Clear Sheet Range

Configuration for clearing values from a range

Create New Spreadsheet

Configuration for creating a new spreadsheet

Fetch Spreadsheet Metadata

Configuration for getting spreadsheet metadata

Read Multiple Sheet Ranges

Configuration for reading multiple ranges at once

Write to Multiple Sheet Ranges

Configuration for writing to multiple ranges at once

Add Spreadsheet Sheet

Configuration for adding a new sheet/tab

Delete Spreadsheet Sheet

Configuration for deleting a sheet/tab

Copy Sheet to Spreadsheet

Configuration for copying a sheet to another spreadsheet

Rename Spreadsheet Sheet

Configuration for renaming a sheet/tab

Duplicate Sheet in Spreadsheet

Configuration for duplicating a sheet within the same spreadsheet

Find and Replace in Spreadsheet

Configuration for find and replace in a spreadsheet

Insert Sheet Rows

Configuration for inserting rows

Delete Sheet Rows

Configuration for deleting rows

Clear Multiple Sheet Ranges

Configuration for clearing multiple ranges at once

Insert Sheet Columns

Configuration for inserting columns

Delete Sheet Columns

Configuration for deleting columns

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 in Postgres and write the results into a Google Sheet

Read rows from a sheet and insert or update matching records in Postgres

Refresh a reporting tab on a schedule from live database data

Reconcile a spreadsheet against a Postgres table and flag the mismatches

About Codex

Codex is OpenAI's command-line coding agent. NoClick runs it as a hosted agent and lets you connect your apps to it as tools, turning it from a coding assistant into an operator that can act across your systems. Connect an integration to the agent and Codex can query, create, and update records in that app directly. You keep the Codex experience and give it real reach into the tools your team already uses.

Fast, capable code generation and editing

Good at well-scoped, concrete tasks

Strong at API and data manipulation

Familiar to teams already on OpenAI tooling