Airtable MCP connector
Updated
Airtable is a cloud-based platform that organizes data into bases and tables to power collaborative workflows. Its MCP connector allows AI agents to explore bases and tables, create and update records, and manage comments on shared work. It also supports upserting and deleting records, retrieving individual record details, and keeping data synchronized across connected workflows.
Authentication type
- OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.
Uses
Use the Airtable MCP connector to perform the following actions:
- Sync project trackers and centralize records across multiple Airtable bases
- Automate record creation from form submissions or workflow triggers
- Add comments to records to log updates and collaborate with a team
- Keep inventory, CRM, or content calendars updated in real time
- Bulk update or upsert records to eliminate duplicate data entry
- Retrieve specific records instantly without opening Airtable manually
- Delete outdated or duplicate records to maintain clean bases
- Pull structured data from Airtable into other business workflows
Example prompts
Use the following example prompts to invoke Airtable MCP connector tools from your AI assistant or Boomi Connect workflow:
Show me all open invoices from last month in Airtable.Create a new record in my Airtable inventory base for the latest shipment.Add a comment to the record for the Johnson account in Airtable.List all the bases I have access to in Airtable.What tables exist in my Airtable marketing base?Update the status of all overdue tasks to complete in Airtable.Upsert this list of customer contacts into my Airtable CRM base.Delete the duplicate entries from my Airtable event registration table.Get the details for record REC12345 in Airtable.Pull all records from my Airtable content calendar for this week.
Airtable MCP connector tools
The Airtable MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.
| Tool | Description |
|---|---|
| airtable_createComment_invoke | Creates a comment on the given record. |
| listBases | List bases |
| listTables | List tables in a base |
| listRecords | List records |
| createRecords | Create records |
| updateRecords | Update records |
| upsertRecords | Upsert records |
| deleteRecords | Delete records |
| getRecord | Get a record |
