OpenAICodex

Connect Codex to Google BigQuery and GitLab

Wire BigQuery and GitLab into Codex at the same time and it can move a change from the repository into the warehouse without a handoff. GitLab is where branches, commits, merge requests, and pipelines live, and BigQuery is where the datasets, tables, and routines those changes depend on live. Codex can commit a migration to a new branch and create the matching table, or approve a merge request and provision the dataset the release expects. The two tools together let it own the schema change end to end.

Loading preview…
Opens a workflow with 119 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 BigQuery

38 tools
Run Query

Run a SQL query and return results inline (synchronous, bounded by timeout).

Get Query Results

Page through the results of a (possibly async) query job.

Insert Job

Start a query / load / extract / copy job (async).

Get Job

Fetch a job's status and statistics (poll until DONE).

List Jobs

List jobs in a project (filter by state, time range).

Cancel Job

Request cancellation of a running job.

Delete Job

Delete a job's metadata.

List Datasets

List datasets in the project.

Get Dataset

Fetch dataset metadata.

Create Dataset

Create a new dataset.

Update Dataset

Full replace of dataset metadata (PUT).

Patch Dataset

Partial update of dataset metadata (PATCH).

Delete Dataset

Delete a dataset.

List Tables

List tables/views in a dataset.

Get Table

Fetch table metadata/schema.

Create Table

Create a table or view with a schema.

Patch Table

Partial update of a table (add columns, set expiration, etc.).

Update Table

Full replace of table metadata (PUT).

Delete Table

Delete a table or view.

Stream Insert Rows

Streaming insert of JSON rows into a table (real-time append).

List Table Data

Read rows from a table directly (paginated, no SQL).

List Routines

List stored procedures / UDFs / TVFs in a dataset.

Get Routine

Fetch a routine definition.

Create Routine

Create a stored procedure / UDF / TVF.

List Models

List BigQuery ML models in a dataset.

Get Model

Fetch BQML model metadata.

Delete Model

Delete a BQML model.

Get Service Account

Return the BigQuery service account for the project (KMS/transfer grants).

List Projects

List projects the caller can access (for project picker UIs).

Undelete Dataset

Restore a dataset within its time-travel window (datasets.undelete).

Update Routine

Replace a routine's full definition (routines.update, PUT).

Delete Routine

Delete a routine (routines.delete).

Patch Model

Update mutable BQML model metadata (models.patch).

Get Table IAM Policy

Get the IAM policy for a table (tables.getIamPolicy).

Set Table IAM Policy

Set the IAM policy for a table (tables.setIamPolicy).

Test Table IAM Permissions

Test the caller's permissions on a table (tables.testIamPermissions).

List Row Access Policies

List row access policies on a table (rowAccessPolicies.list).

Get Row Access Policy

Get a single row access policy (rowAccessPolicies.get).

GitLab

81 tools
List Projects

List projects accessible to the token.

Get Project

Retrieve a single project by ID or namespace/path.

Create Project

Create a new project (repository).

List Project Members

List members of a project.

List Issues

List issues in a project.

Get Issue

Get a single issue by its project-scoped IID.

Create Issue

Create an issue in a project.

Update Issue

Edit issue fields or change its state.

Add Comment

Add a comment (note) to an issue or merge request.

List Merge Requests

List merge requests in a project.

Get Merge Request

Get a single merge request by IID.

Create Merge Request

Open a merge request.

Update Merge Request

Edit a merge request or change its state.

Merge Merge Request

Accept/merge a merge request.

List Branches

List repository branches.

Create Branch

Create a repository branch.

Delete Branch

Delete a repository branch.

List Commits

List repository commits.

Create Commit

Create a commit with file actions in one call.

Get File

Get a repository file's content and metadata.

Create/Update File

Create or update a single repository file.

Create Tag

Create a git tag.

List Pipelines

List CI/CD pipelines.

Create Pipeline

Trigger a new pipeline on a ref.

List Pipeline Jobs

List jobs for a pipeline.

Create Release

Create a release tied to a tag.

List Groups

List groups visible to the token.

Global Search

Global search across GitLab.

Get Current User

Return the authenticated user (token validity check).

Get Pipeline

Get a single pipeline.

Retry Pipeline

Retry the failed/canceled jobs of a pipeline.

Cancel Pipeline

Cancel a pipeline's running jobs.

Get Job

Get a single job.

Get Job Log

Get a job's log/trace (plain text).

Retry Job

Retry a single job.

Play Job

Run a manual job.

Cancel Job

Cancel a single job.

List Variables

List a project's CI/CD variables.

Create Variable

Create a project CI/CD variable.

Update Variable

Update a project CI/CD variable's value.

Delete Variable

Delete a project CI/CD variable.

Approve Merge Request

Approve a merge request.

Unapprove Merge Request

Remove your approval from a merge request.

List Notes

List comments (notes) on an issue or merge request.

Delete Issue

Delete an issue.

List Labels

List a project's labels.

Create Label

Create a project label.

Delete Label

Delete a project label.

List Milestones

List a project's milestones.

Create Milestone

Create a project milestone.

Add Member

Add a user as a project member.

Remove Member

Remove a project member.

List Releases

List a project's releases.

Get Release

Get a release by tag name.

Set Commit Status

Post a build/commit status onto a commit SHA.

List Environments

List a project's environments.

Create Environment

Create an environment.

Stop Environment

Stop an environment.

Delete Environment

Delete a stopped environment.

List Deployments

List a project's deployments.

Get Deployment

Get a single deployment.

Create Deployment

Create a deployment record.

List Wiki Pages

List a project's wiki pages.

Get Wiki Page

Get a wiki page by slug.

Create Wiki Page

Create a wiki page.

Update Wiki Page

Update a wiki page.

Delete Wiki Page

Delete a wiki page.

List Protected Branches

List protected branches.

Protect Branch

Protect a branch (or wildcard).

Unprotect Branch

Unprotect a branch.

List Todos

List the current user's todos.

Mark Todo Done

Mark a single todo as done.

Mark All Todos Done

Mark all of the current user's todos as done.

List Webhooks

List a project's webhooks.

Create Webhook

Create a project webhook.

Delete Webhook

Delete a project webhook.

Update Release

Update a release's name/notes.

Delete Release

Delete a release (the tag is kept).

List Epics

List a group's epics (Premium).

Create Epic

Create an epic in a group (Premium).

Update Epic

Update an epic (Premium).

What you can build

Create a BigQuery table for a schema change and commit the migration to a new GitLab branch in the same pass.
When Codex approves a merge request in GitLab, provision the BigQuery dataset the release depends on.
Set up a new GitLab environment for a launch and create the matching BigQuery dataset behind it.
Cancel a stuck GitLab pipeline and cancel the BigQuery job it kicked off so nothing keeps running.

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 Google BigQuery and GitLab wired in as tools. Connect your account and run.