Arlet
Airtable

Connect Airtable to Codex

Search, read and write Airtable from Codex. Arlet links the two through one MCP connection and takes care of keys and authentication.

Enable Airtable in ArletCodex connection guide (docs)

Arlet makes Airtable's official MCP server available from the AI client you already use. There is no OAuth integration to create on the Airtable side. Signing in completes the connection.

Beyond searching, adding and updating records, the AI can create tables and fields, draft automations and submit forms. What it can read or write is exactly what your Airtable account can. The available tools are those provided by Airtable's official server.

How to connect Airtable to Codex

  1. 1

    In the Arlet dashboard, open Integrations → Add an integration and choose Airtable. Sign in with Link Airtable, name the connection and click Create.

  2. 2

    In your terminal, run codex mcp add arlet --url https://mcp.arlet.dev/mcp/ to add Arlet as an MCP server.

  3. 3

    Codex detects OAuth support and opens your browser. Sign in with Google and click Allow on the consent screen.

  4. 4

    Once connected, both the CLI and the IDE extension can call Arlet tools (the configuration is shared).

If the browser does not open, run codex mcp login arlet to redo the authentication.

What you can do

Airtable tools that Codex can call.

  • list_bases

    List the bases you can access.

  • search_bases

    Find a base by name.

  • list_tables_for_base

    List the tables in a base.

  • get_table_schema

    Get a table's field definitions.

  • list_records_for_table

    List records with optional filtering and sorting.

  • search_records

    Search records in a table by keyword.

  • create_records_for_table

    Add records to a table.

  • update_records_for_table

    Update existing records.

  • delete_records_for_table

    Delete records by ID.

  • revert_action

    Undo a recent change.

  • create_table

    Create a table.

  • create_field

    Add a field to a table.

  • update_field

    Rename a field or change its description or formula.

  • list_views_for_table

    List a table's views.

  • list_automations

    List the automations in a base.

  • create_automation

    Draft an automation from a trigger and actions.

  • get_form_schema

    Read a form's fields and required conditions.

  • submit_form

    Submit a response to a form.

The tool list follows what Airtable's official MCP server provides and may change.

Example uses

  • Clean up a customer list

    Find blanks and inconsistent values in the customer table and fill them in from company names.

  • Turn daily reports into records

    Pull deals and tasks out of a report or email and add them as records to the right table.

  • Summarize a table

    Pull records by condition and write a report on counts and trends.

  • Design a new tracker

    Describe what you want to track and get a table with fields, plus a draft automation.

Prompts you can use as-is

  • In the Customers table, find rows with an empty Industry and fill it in from the company name
  • Extract today's meetings from this daily report and add them as records to the Deals table
  • In the Tasks table, group everything due this week and still open by assignee
  • Create a table to track job candidates, and draft an automation that posts to Slack when the status changes

Use Airtable with other AI clients