Airtable MCP connector

What agents can do

The server has 24 actions (10 read, 14 write).

• Bases and schema: list_bases, list_tables, describe_table, list_fields and list_views.
• Read records: list_records with formulas, views, sorting and field selection, get_record, search_records by keyword across fields, and count_records for records that match a filter.
• Write records: create_record, create_records, update_record, update_records, delete_record and delete_records.
• Tables and fields: create_table, update_table, create_field and update_field to create, rename and describe them.
• Comments: list_comments, create_comment, update_comment and delete_comment.
• Attachments: upload_attachment adds a file to a record from a URL or file content.

Before you connect

• An Airtable account with access to the bases you want to connect.
• An InsightfulPipe workspace with a brand for the Airtable account. Owners, admins and operators can add connections.

Connect Airtable

1. In the InsightfulPipe app, open Connectors, choose Airtable and click Connect.
2. Under Permissions, choose Read Only or Read + Write.
3. Click Connect to Airtable.
4. Sign in to Airtable, choose the bases to grant and approve access.

Add the MCP server to your AI client

Server URL: https://airtable.insightfulmcp.com/ and server name: airtable-mcp.

• Claude: open Claude Connectors Settings, scroll to the bottom and click Add custom connector, paste the URL, click Add, then click Connect.
• ChatGPT: in ChatGPT Security Settings turn on Developer mode, click Create on the Connectors page, paste the URL, click Create, then click Connect. Turn the connector on in each new chat with + → More.
• Claude Code: run claude mcp add --transport http airtable-mcp https://airtable.insightfulmcp.com/, then type /mcp, select airtable-mcp and click Authenticate.
• Cursor: in the app, open MCP Servers, choose Airtable and click Install Airtable MCP, click Open Cursor then Install, then click Connect and Open.
• Gemini CLI: run gemini mcp add --transport http airtable-mcp https://airtable.insightfulmcp.com/, then /mcp auth airtable-mcp.
• Codex CLI: run codex mcp add airtable-mcp --url https://airtable.insightfulmcp.com/; authorization starts automatically.

Each client opens a browser window where you log in to InsightfulPipe and click Authorize access. Step-by-step guides: Claude, ChatGPT, Claude Code, Cursor, Gemini CLI and Codex CLI. To reach every connected platform through one server, use the unified server.

Permissions and safety

• Read Only connections request only Airtable read scopes, so every write is locked. Writes need Read + Write.
• delete_record, delete_records and delete_comment are destructive, so they stay off until an owner, admin or operator enables them in Configure actions for this account.
• update_record and update_records overwrite the fields you send. They are regular write actions that are on for Read + Write connections.
• Writes need the Owner, Administrator or Operator role. Members with the User role can only run enabled read actions on accounts granted to them.

Limits

• Creating, updating and deleting records is limited to 10 records per call. Agents split larger changes into several calls.
• Attachments larger than 5 MB are rejected.
• There are no actions for webhooks, automations, interfaces or creating bases.
• Airtable API rate limits apply. The server waits and retries when Airtable asks it to slow down.

Example prompts

• "Using Airtable, how many records in Leads have Status set to Qualified?"
• "Find records in Campaigns that mention Black Friday."
• "Set Status to Published on these eight records."
• "Add a Budget currency field to the Campaigns table."

Troubleshooting

• A base is missing: reconnect Airtable and grant that base during sign-in.
• "This action is disabled for this connected account. An owner or admin must enable it for the account." An owner, admin or operator can enable it in Configure actions for this account.
• "This account is connected read-only, so this action cannot be enabled for it. An owner or admin must reconnect it with Read & Write permissions." Reconnect and choose Read + Write under Permissions.
• An attachment upload fails: check that the file link is public and the file is 5 MB or smaller.

FAQ

Is this Airtable's official MCP server?

No. Airtable runs its own MCP server. InsightfulPipe is an independent hosted server that uses Airtable OAuth and adds Read Only connections, per-action controls, deletes off by default and your other platforms in the same workspace.

Can the agent update hundreds of records at once?

Not in one call. Record writes take up to 10 records per call, so the agent works through larger updates in batches.

Can I connect several Airtable accounts?

Yes. Each connection is one Airtable account with the bases it grants, and each connected account counts as one connection on your plan.

Related

• Airtable MCP server
• Notion connector
• Google Sheets connector
• Workspace roles and permissions
• MCP troubleshooting