OpenAICodex

Connect Codex to Linear and PostgreSQL

Wire Linear and Postgres into Codex and it can move from a database fact to a tracked engineering task without you in the loop. It runs a SELECT to find what is broken or stale in your data, then opens a Linear issue with the numbers, the affected rows, and a priority. You get product decisions filed as work, backed by what the database actually says.

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

Linear

50 tools
List Issue Comments

List comments for a specific Linear issue

Create Issue Comment

Create a comment on a specific Linear issue

Update Issue Comment

Update an existing comment

Delete Issue Comment

Delete a comment

List Team Cycles

Retrieve cycles for a specific Linear team

Create Cycle

Create a new cycle (sprint) for a team

Update Cycle

Update an existing cycle

Archive Cycle

Archive a cycle

Get Document

Retrieve a Linear document by ID

List Documents

List documents in the user's Linear workspace

Create Document

Create a new document. Requires exactly one of: projectId, teamId, or issueId.

Update Document

Update an existing document

Delete Document

Delete a document

Get Issue

Retrieve detailed information about an issue by ID

List Issues

List issues in the user's Linear workspace

Create Issue

Create a new Linear issue

Update Issue

Update an existing Linear issue

Delete Issue

Delete a Linear issue

Search Issues

Search issues by query string

Archive Issue

Archive an issue

Unarchive Issue

Unarchive an issue

List Team Workflow States

List workflow states (statuses) for a team

List Issue Labels

List available issue labels in a Linear workspace

Create Issue Label

Create a new Linear issue label

Update Issue Label

Update an issue label

Delete Issue Label

Delete an issue label

List Projects

List projects in the user's Linear workspace

Get Project

Retrieve details of a specific project

Create Project

Create a new project in Linear

Update Project

Update an existing Linear project

Archive Project

Archive a project (soft delete)

Delete Project

Permanently delete a project

List Project Milestones

List milestones for a project

Create Project Milestone

Create a project milestone

Update Project Milestone

Update a project milestone

Delete Project Milestone

Delete a project milestone

List Teams

List teams in the user's Linear workspace

Get Team

Retrieve details of a specific Linear team

List Users

Retrieve users in the Linear workspace

Get User

Retrieve details of a specific Linear user

Get Authenticated User

Get the currently authenticated user

List Issue Attachments

List attachments for an issue

Create Issue Attachment

Create an attachment (link URL to issue)

Delete Attachment

Delete an attachment

List Issue Relations

List issue relations (blocks, related, duplicate)

Create Issue Relation

Create a relation between issues

Delete Issue Relation

Delete an issue relation

List Webhooks

List webhooks for the organization

Create Webhook

Create a webhook

Delete Webhook

Delete 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

What you can build

Query Postgres for rows that violate an invariant and file a Linear issue per cluster with counts and example IDs
Read an open Linear issue, run the SQL it references against the database, and post the result set as a comment
List issues in a project, check each one against current data, and close the ones the database shows as already resolved
Run a nightly data-quality SELECT and create or update a single rolling Linear issue with the latest breakdown

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

Frequently asked questions

Open your Codex agent in one click

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