Skip to main content
Airtable is a flexible database platform that combines spreadsheet simplicity with database power. The Airtable MCP server lets you search, filter, create, and update records using natural language.

What Can It Do?

  • Retrieve records with filters, sorts, and selected fields
  • Create and update records to keep your tables current
  • Explore your workspace by listing bases, tables, and schema
  • Manage structure by creating and modifying fields

Where to Use It

Add Airtable as a tool to any agent. The agent can then interact with your bases conversationally, choosing the right actions based on context. To add an MCP tool to your agent:
  1. Open your agent’s configuration
  2. Click Add toolsConnect an app with MCP
  3. Search for the integration and select it
  4. Authenticate with your account
You can control which tools your agent has access to. After adding an integration, click on it to enable or disable specific tools based on what your agent needs.

In Workflows (Via Agent Node)

For automated pipelines, use an Agent Node with Airtable tools. This gives you the flexibility of an agent within a deterministic workflow.

As a Custom MCP Node

You can also create a standalone MCP node for a specific action. This generates a reusable node that performs one task, useful when you need the same operation repeatedly in workflows.
To create a custom MCP node:
  1. Go to your node library and search for the integration
  2. Click Create a node with AI
  3. Describe the specific action you want (e.g., “List records from table X where status is Active”)
  4. Test the node and save it for reuse
Custom MCP nodes are single-purpose by design. For tasks that require multiple steps or dynamic decision-making, use an agent instead.

Available Tools

ToolDescription
List RecordsRetrieve records with filtering, sorting, and field selection
Create RecordsCreate new records in a table
Update RecordsUpdate existing records
Get RecordGet a single record by ID
Delete RecordsDelete one or more records
List BasesList all accessible bases
List TablesList all tables in a base
Base SchemaGet detailed schema for all tables
Update TableUpdate a table’s name or description
Create FieldAdd a new field to a table
Update FieldUpdate a field’s metadata
List CommentsList comments for a record

Example Prompts

Use these with your agent or in the Agent Node: Discover your workspace:
List all my Airtable bases and their tables
Find specific records:
Get all records from the Projects table where Status is "In Progress"
Create new data:
Add a new record to the Tasks table with Name "Review Q4 report" and Due Date "2024-12-15"
Update records:
Update the record for "Project Alpha" to set Status to "Complete"
Explore schema:
Show me all the fields in the Customers table and their types

Troubleshooting

IssueSolution
Agent not finding the right dataBe more specific with table names and filter conditions
Action not completingCheck that you’ve authenticated and have write permissions
Unexpected resultsThe agent may chain multiple tools (e.g., listing tables first, then querying). Review the agent’s reasoning to understand its approach.
Tool not availableVerify the tool is enabled in your agent’s MCP configuration
Agents are smart enough to chain multiple API calls together. For example, asking “Find the project named Marketing Campaign” will automatically list bases, find the right table, then search for the record. If results seem off, check the agent’s step-by-step reasoning.

Need Help?


Use this integration directly in Claude or Cursor. Connect remotely via the Airtable MCP server using your Gumloop credentials.