Airtable MCP for AI Agents

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Airtable MCP or direct API to find, update, create, and organize records and tables through natural language.
Trusted by
AWS
Glean
Zoom
Airtable
GET STARTED FOR FREEGET A DEMO

30 min · no commitment · see it on your stack

Airtable Logo
Gradient Top
Gradient Middle
Gradient Bottom
divider

Try Airtable now

Enter a prompt below to test the integration in our Tool Router playground. You'll be redirected to sign in and try it live.

Supported Tools and Triggers

Tools
Triggers
Create baseCreates a new Airtable base with specified tables and fields within a workspace.
Create CommentTool to create a comment on a specific Airtable record.
Create FieldCreates a new field within a specified table in an Airtable base.
Create Record From Natural LanguageCreates a new record in an Airtable table from a natural language description.
Create recordsTool to create multiple records (up to 10) in a specified Airtable table.
Create tableCreates a new table within a specified existing Airtable base, allowing definition of its name, description, and field structure.
Delete CommentTool to delete a comment from a record in an Airtable table.
Delete multiple recordsTool to delete up to 10 specified records from a table within an Airtable base.
Delete RecordPermanently deletes a specific record from an existing table within an existing Airtable base.
Get Base SchemaRetrieves the detailed schema for a specified Airtable base, including its tables, fields, field types, and configurations, using the `baseId`.
Get RecordRetrieves a specific record from an Airtable table by its record ID.
Get user informationRetrieves information, such as ID and permission scopes, for the currently authenticated Airtable user from the `/meta/whoami` endpoint.
List basesRetrieves all Airtable bases accessible to the authenticated user, which may include an 'offset' for pagination.
List CommentsTool to list comments on a specific Airtable record.
List recordsTool to list records from an Airtable table with filtering, sorting, and pagination.
Update CommentTool to update an existing comment on a specific Airtable record.
Update FieldUpdates a field's name or description in an Airtable table.
Update multiple recordsTool to update up to 10 records in an Airtable table with selective field modifications.
Update multiple records (PUT)Tool to destructively update multiple records in Airtable using PUT, clearing unspecified fields.
Update recordModifies specified fields of an existing record in an Airtable base and table; the base, table, and record must exist.
Update record (PUT)Updates an existing record in an Airtable base using PUT method.
Update TableUpdates the name, description, and/or date dependency settings of a table in Airtable.
Upload attachmentUploads a file attachment to a specified field in an Airtable record.
Python
TypeScript

Install Composio

python
pip install composio claude-agent-sdk
Install the Composio SDK and Claude Agent SDK

Create Tool Router Session

python
from composio import Composio
from claude_agent_sdk import ClaudeSDKClient, ClaudeAgentOptions

composio = Composio(api_key='your-composio-api-key')
session = composio.create(user_id='your-user-id')
url = session.mcp.url
Initialize the Composio client and create a Tool Router session

Connect to AI Agent

python
import asyncio

options = ClaudeAgentOptions(
    permission_mode='bypassPermissions',
    mcp_servers={
        'tool_router': {
            'type': 'http',
            'url': url,
            'headers': {
                'x-api-key': 'your-composio-api-key'
            }
        }
    },
    system_prompt='You are a helpful assistant with access to Airtable tools.',
    max_turns=10
)

async def main():
    async with ClaudeSDKClient(options=options) as client:
        await client.query('Create a new record in the "Projects" table with name "Website Redesign" and status "In Progress"')
        async for message in client.receive_response():
            if hasattr(message, 'content'):
                for block in message.content:
                    if hasattr(block, 'text'):
                        print(block.text)

asyncio.run(main())
Use the MCP server with your AI agent

Why Use Composio?

AI Native Airtable Integration

  • Supports both Airtable MCP and direct API based integrations
  • Structured, LLM-friendly schemas for reliable tool execution
  • Rich coverage for reading, writing, and querying your Airtable data

Managed Auth

  • Built-in OAuth handling with automatic token refresh and rotation
  • Central place to manage, scope, and revoke Airtable access
  • Per user and per environment credentials instead of hard-coded keys

Agent Optimized Design

  • Tools are tuned using real error and success rates to improve reliability over time
  • Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

  • Fine-grained RBAC so you control which agents and users can access Airtable
  • Scoped, least privilege access to Airtable resources
  • Full audit trail of agent actions to support review and compliance

Use Airtable with any AI Agent Framework

Choose a Framework you want to connect Airtable with

Frequently Asked Questions

Do I need my own developer credentials to use Airtable with Composio?

No, you can get started immediately using Composio's built-in Airtable app. For production, we recommend configuring your own OAuth credentials.

Can I use multiple toolkits together?

Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.

Is Composio secure?

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. Learn more.

What if the API changes?

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

Used by agents from

Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai

Never worry about agent reliability

We handle tool reliability, observability, and security so you never have to second-guess an agent action.

Get started for freeGet a demo↗