Airtable MCP connector

Airtable is a cloud-based platform that combines database functionality with spreadsheet flexibility to organize and visualize data across workflows. The Airtable MCP connector allows AI agents to manage bases, tables, and records, including creating, updating, upserting, and deleting entries within workspaces. It also supports listing available bases and tables, retrieving individual records, and adding comments to facilitate collaboration.

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:

• Track project tasks and deadlines across distributed teams without email chains
• Organize customer feedback and support tickets in a searchable, collaborative database
• Automate inventory updates when stock levels change across multiple warehouses
• Build approval workflows that route requests to the right stakeholders instantly
• Consolidate sales pipeline data from multiple sources into a single source of truth
• Archive completed records automatically to keep active workflows clean and focused
• Attach comments and notes to records for real-time team communication and context

Example prompts

Use the following example prompts to invoke Airtable MCP connector tools from your AI assistant or Boomi Connect workflow:

• Show me all high-priority tasks assigned to our marketing team in Airtable.
• Create a new customer record in Airtable with contact details for Acme Corp.
• Update the project status to complete for all tasks finished this week in Airtable.
• Delete outdated vendor records from our Airtable database and archive them.
• List all bases in our Airtable workspace so I can find the sales pipeline.
• Add a comment to the client proposal record noting the approved budget amount.
• Sync new leads from our form submissions into our Airtable CRM base.
• Find all records in the product catalog table that need pricing updates in Airtable.
• Merge duplicate customer entries in our Airtable contacts base.
• Show me which tables exist in our operations base in Airtable.

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	Adds a text comment to a specific record in an Airtable base.
listBases	Retrieves all Airtable bases accessible to the authenticated user.
listTables	Retrieves all tables within a specified Airtable base.
listRecords	Retrieves records from a specified table with optional filtering and sorting.
createRecords	Adds new records to a specified table with provided field values.
updateRecords	Modifies existing records in a table with updated field values.
upsertRecords	Creates new records or updates existing ones based on matching criteria.
deleteRecords	Removes specified records from a table.
getRecord	Retrieves a single record by its identifier from a specified table.