How to connect Airtable to your AI assistant with MCP

TL;DR:

• Using Composio's managed MCP server, you can query, update, and summarize your Airtable records directly from your AI assistant in a single session.

• This setup lets your AI assistant take direct action on your Airtable data, querying, updating, and creating records through plain-English prompts, without switching tabs or writing formulas.

• Composio routes each prompt to the right Airtable operation automatically, with authentication and data formatting handled in the background so you don't have to think about it.

Your Airtable base holds the data. Your AI assistant knows how to reason about it. The missing piece is a reliable connection between the two that can handle real operations, filter records, write new rows, update fields, and summarize trends across tables. This guide shows how to set that up using Composio's managed MCP server, which routes natural-language prompts to the right Airtable operations and handles the auth plumbing automatically.

Think of MCP as a universal connector for AI. When you type a prompt in your AI assistant, MCP translates that natural language into a structured API call, sends it to Airtable, and returns the result in a format your assistant can reason about and respond to.

Composio's Airtable MCP integration securely connects AI assistants to Airtable bases. Authenticate once, scope access to the bases you need, and Claude can query, create, and update records using plain English.

The benefits of linking your AI assistant to Airtable

The Composio Airtable toolkit docs cover the full range of operations: listing records, creating rows, updating fields, reading schema details, and more, all through a single authenticated connection.

Before MCP, wiring an AI assistant to Airtable meant writing custom scripts for every operation, one for listing records, another for creating rows, another for filtering by field value, and maintaining each one as the API evolved. Composio's managed server covers all of those operations through a single authenticated connection, so you describe what you want in plain English and the server routes it to the right call.

How to connect Airtable to your AI assistants

How to connect Airtable MCP with ChatGPT Work

ChatGPT Work is an agent inside ChatGPT built for your most ambitious work. It takes action across your apps and files, stays with a project for hours, and turns a goal into finished materials like sheets, slides, and docs - not just answers.

Prerequisites

• A ChatGPT account with access to ChatGPT Work (rolling out across Pro, Enterprise, Edu, Plus, and Business plans). We will use the ChatGPT desktop app, which is available on every plan.

• Access to the Airtable workspace you want to connect.

• Composio MCP.

Note: Composio connects through OAuth. You will be asked to sign in and approve specific permissions. Review the permission screen carefully if you are using a work account.

Step 1: Open the MCP settings

In ChatGPT Work, go to Settings and open the Plugins section. Inside the Plugins page, click the MCP tab.

Step 2: Add the server

Click Add server. In the Name field enter Composio, for Type select Streamable HTTP, and in the URL field paste the Composio MCP server URL:

https://connect.composio.dev/mcp

Then click Save. The Composio server now appears in your MCP plugins list.

Step 3: Authenticate

Click Authenticate, log in via Composio, and click Allow access to authorize ChatGPT Work to use your Composio account.

Step 4: Start using Composio

That is it - Composio tools are now available in ChatGPT Work. Ask it to work with your Airtable account and it will run the actions you authorize.

How to connect Airtable to Claude Cowork

Prerequisites

• Claude Desktop with access to Cowork.

• An Airtable account you want to connect.

• Composio MCP.

Step 1: Open Customize

In Claude Desktop, click Customize in the left sidebar, then select Connectors and click the + icon at the top.

Step 2: Add the Composio MCP server

Click Add custom connector and paste in the Composio MCP server URL:

https://connect.composio.dev/mcp

Step 3: Authorize in your browser

Click Connect. You'll be redirected to a browser window where you can authorize Composio to continue.

Step 4: Connect your Airtable account

Back in Cowork, ask the agent to connect to Airtable or give it any Airtable-related task.

For example, ask Cowork to:

• "Add new contacts from a signup list"

• "Create a project tracking table in workspace"

• "Delete outdated records from clients table"

It will prompt you to authenticate and authorize access.

That's it. Composio's tools are now available in Cowork, and your Airtable account is ready to use.

How to connect Airtable MCP with Cursor

Prerequisites

• Cursor installed on your computer.

• An Airtable account you want to connect.

• Composio MCP.

Step 1: Open Cursor settings

Open Cursor and go to Settings.

Select Tools & Integrations and open the MCP section.

Step 2: Add the Composio MCP server

Click New MCP Server and add the Composio MCP server URL:

https://connect.composio.dev/mcp

Step 3: Save the MCP configuration

Save the configuration and make sure the Composio MCP server is enabled in Cursor.

Step 4: Authenticate your Airtable account

Open Cursor's Agent and ask it to perform an Airtable action.

Cursor will prompt you to authenticate your Airtable account through Composio. Follow the authentication flow in your browser and authorize the requested permissions.

Step 5: Use Airtable in Cursor

Once authenticated, you can ask Cursor to perform Airtable actions directly from the Agent.

For example:

• "Add new contacts from a signup list"

• "Create a project tracking table in workspace"

• "Delete outdated records from clients table"

Your Airtable account is now connected to Cursor through Composio MCP.

Key ways to automate your Airtable data

With the connection live, here's what you can do in practice. These examples use natural-language prompts that work identically in Claude, ChatGPT Work, and Cursor.

Filtering records with natural language: Instead of building filtered views and exporting them, describe what you want directly in your AI assistant.

• "Show me all leads added this week where Status is 'New' and Source is 'Website'."

• "List every project where the deadline is before month-end and the owner is unassigned."

• "Find all clients in the Active table with an empty Last Contact Date field."

Writing records back to Airtable: Update operations work the same way.

• "Add a new lead: name is Sarah Chen, email is sarah@example.com, source is LinkedIn."

• "Update the Status field to 'Proposal Sent' for all records where the Stage is 'Discovery'."

• "Create a new row in the Project Log named 'Q3 Audit' with a deadline of September 30."

Extracting insights across your data: Your AI assistant can synthesize and summarize, not just retrieve.

• "Summarize the deals closed this quarter grouped by product line."

• "Which client accounts have the most open tasks, and what are those tasks?"

• "Compare the revenue in my Invoices table for this quarter versus last quarter."

For a practical example of this kind of natural-language interaction with live data, this autonomous AI SEO analyst walkthrough using Claude and Composio MCP shows the same reasoning pattern applied to a different data source.

Ready-to-use Airtable MCP commands

Airtable data safety and permissions

Composio holds SOC 2 and ISO 27001 certifications, with all data encrypted at rest and in transit. If you need zero data retention on record contents, that's available as a paid add-on.

To get started, create a free Composio account (no credit card required, 100,000 tool calls per month included) and connect Airtable via the dashboard.

FAQs

Does connecting Airtable to Claude expose my entire workspace?

No. Airtable Personal Access Tokens let you specify exactly which bases the token can reach and which operations it can perform. Claude can only access the bases you explicitly grant in the PAT's Access settings.

Can Claude write to Airtable, or only read from it?

Claude can both read and write to Airtable, it depends on the permissions you grant when you create your Personal Access Token. If you give it write access (the data.records:write scope), it can create, update, and delete records. If you only grant read access, it can retrieve and display data but won't be able to make any changes.

What happens if my Airtable token stops working?

Airtable PATs don't expire automatically, so a broken connection usually means the token was regenerated or deleted. Generate a new PAT at airtable.com/create/tokens and update the credential in your Composio dashboard under Manage Connections.

Can I use this setup with ChatGPT or Cursor instead of Claude?

Yes. Composio's MCP server works with any MCP-compatible client.

What file size limit applies when uploading attachments through MCP?

Files up to 5MB can be uploaded by passing file bytes directly in the API request. Files above that size need to be hosted at a public URL and referenced in the request instead.

Glossary

Personal Access Token (PAT): A scoped credential in Airtable that defines which bases a token can reach and which API operations it can perform. Tokens don't expire automatically and remain active until you manually delete or regenerate them in Airtable's developer settings.

MCP (Model Context Protocol): A common way for AI assistants to talk to outside tools and data, like Airtable, using the same format every time.

Tool call: A single request your AI assistant makes to an external tool, such as querying a record or creating a row. Composio's free tier includes 100,000 tool calls per month with no overage on the free plan.

Base: Airtable's term for a database. Each base contains one or more tables, and PAT access is scoped at the base level rather than the workspace level.