Which database and Airtable actions are available to Codex?

Only what you allowlist, such as a read query on Postgres and create or update on Airtable records. If you do not expose a write or an UPDATE, the agent cannot run it.

Do I have to host the Codex harness?

No. NoClick runs Codex for you and connects Airtable and Postgres as tools, so there is no install or infrastructure to manage.

Can I keep it from writing to my Postgres database?

Yes. Allowlist only read operations and the agent can query but never modify your tables, while still updating Airtable if you allow that.

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

Connect Airtable and Postgres to Codex and it can reconcile a working base against your system of record. Codex can query your Postgres tables, compare the rows to Airtable records, and create or update entries so both reflect the same data. It turns a manual export-and-match chore into something the agent runs on demand.

Loading preview…

Opens a workflow with 64 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 Codex, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in Airtable
A preset of real Airtable 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 Airtable
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 Codex first calls in. Codex connects when a session starts — run codex, or restart a running one.
Run this in your terminal
$codex mcp add noclick --url https://mcp.noclick.app/s/<your-link>
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools Codex gets

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

Airtable

24 tools

List Accessible Bases

List all accessible bases

Fetch Base Schema

Get the schema (tables and fields) of a base

Create New Table

Create a new table in a base

Update Table Metadata

Update a table's name or description

Create Table Field

Create a new field in a table

Update Table Field

Update a field's name or description

List Table Records

List records from a table with filtering, sorting, and pagination

Fetch Single Record

Get a single record by ID

Create Multiple Records

Create one or more records (batch create up to 10)

Update Multiple Records

Update one or more records (batch update up to 10)

Update Single Record

Update a single record by ID

Delete Multiple Records

Delete one or more records (batch delete up to 10)

Delete Single Record

Delete a single record by ID

Upsert Records by Field Match

Create or update records based on field matching (upsert)

List Record Comments

List comments on a record

Create Record Comment

Create a comment on a record

Update Record Comment

Update a comment

Delete Record Comment

Delete a comment

List Base Webhooks

List all webhooks for a base

Create Base Webhook

Create a webhook for a base

Delete Base Webhook

Delete a webhook

List Webhook Payloads

List payloads for a webhook

Refresh Webhook Expiration

Refresh a webhook to extend its expiration

Enable Webhook Notifications

Enable notifications for a webhook

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

Query Postgres for new rows and add the matching records to an Airtable base

Cross-check Airtable records against a Postgres table and flag the ones that drifted

Pull an Airtable record's edits and write them back to the right Postgres row

Run a Postgres aggregate and log the results as a snapshot row in Airtable

Meet the runner

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

Good to know