What Codex can do with Airtable
Ask your agent in plain language. Each of these maps to a real tool on the server.
- Ask Codex to use the create records tool in Airtable
- Ask Codex to use the manage table tool in Airtable
- Ask Codex to use the delete records tool in Airtable
- Ask Codex to use the upload attachment tool in Airtable
- Ask Codex to use the upsert records tool in Airtable
Add the Airtable MCP server to Codex
Run these once. Afterwards, everyone you give access to signs in the same way.
1. Enable Airtable in Metorial
In your Metorial portal, enable the Airtable MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
2. Add the server and sign in
The Codex CLI, IDE extension and ChatGPT desktop app share this config.
codex mcp add metorial --url <your-magic-mcp-url>codex mcp login metorial3. Check the connection
Type /mcp in Codex to see Metorial and its Airtable tools.
Give your team Airtable in Codex
Once Airtable is enabled in Metorial, teammates sign in with SSO and get the same connection in Codex, with only the tools their role allows.
One link covers every app you approve. See how the MCP gateway handles access, roles and audit logs for the whole company.
Airtable tools available in Codex
Full descriptions and inputs are on the Airtable MCP server page.
- Upsert Records: Find, create, or update records in a single operation.
- List Bases: List all Airtable bases the authenticated user has access to.
- Manage Field: Create a new field or update an existing field in a table within the specified Airtable base.
- Get Base Schema: Retrieve the full schema of the specified Airtable base, including all tables, their fields (with types and options), and views.
- List Records: List records from a table in the specified Airtable base.
- Manage Comment: List, create, update, or delete comments on a record in the specified Airtable base.
- Get Record: Retrieve a single record by its ID from a table in the specified Airtable base.
- Update Records: Update one or more existing records in a table in the specified Airtable base.
- Create Records: Create one or more records in a table in the specified Airtable base.
- Manage Table: Create a new table or update an existing table in the specified Airtable base.
- Delete Records: Delete one or more records from a table in the specified Airtable base.
- Upload Attachment: Upload a base64-encoded file directly into an Airtable attachment field on an existing record.
Using Airtable tools in Codex
What to expect once Airtable is connected.
- Limit which Airtable tools Codex sees with enabled_tools and disabled_tools on the metorial server in config.toml.
- Set default_tools_approval_mode to auto, prompt, writes or approve. writes prompts only for tools that are not marked read-only.
- Type /mcp in the composer to see the connected servers.
- Override the approval behavior for a single Airtable tool with tools.<tool>.approval_mode.
Troubleshooting Codex
- Metorial is listed but tools are missing
- Codex can connect without credentials and then see nothing. Run codex mcp login metorial to complete the OAuth sign-in.
- Metorial times out at startup
- Codex waits 10 seconds by default. Raise startup_timeout_sec under [mcp_servers.metorial] in ~/.codex/config.toml.
- Long tool calls fail after a minute
- The default tool timeout is 60 seconds. Raise tool_timeout_sec for the metorial server in config.toml.
Based on the Codex MCP documentation.
Frequently asked questions
Common questions about connecting Airtable to AI agents with Metorial.
Does Codex support the Airtable MCP server?
Yes. Codex connects to the Airtable MCP server through one CLI command, pointed at your Metorial URL. You need the Codex CLI, IDE extension or ChatGPT desktop app.Do I need an API key to connect Airtable to Codex?
No. You sign in to Airtable once through Metorial, and Codex uses that connection. No API keys go into Codex's settings.Which Airtable tools can Codex use?
All 12 Airtable tools your team allows, such as Upsert Records, List Bases, Manage Field. Admins can narrow that list per team.Can I control which teammates use Airtable in Codex?
Yes. Role-based access control decides who can use Airtable and which of its tools appear in Codex, and every call is logged with the person's identity.What if Codex doesn't show Airtable tools?
Codex can connect without credentials and then see nothing. Run codex mcp login metorial to complete the OAuth sign-in.
GitHub
Linear