Airtable MCP server for AI agents and assistants

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.

Airtable logoAirtable
Oauth2Api Key

Airtable combines the flexibility of spreadsheets with the power of a database for easy project and data management. Teams use Airtable to organize, track, and collaborate with custom views and automations.

23 Tools6 Triggers

Try Airtable now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND
Airtable
Try asking
TOOLS & TRIGGERS

Supported Tools and Triggers

Every Airtable action and event your agent gets out of the box.

Create base

Creates a new Airtable base with specified tables and fields within a workspace.

Create Comment

Tool to create a comment on a specific Airtable record.

Create Field

Creates a new field within a specified table in an Airtable base.

Create Record From Natural Language

Creates a new record in an Airtable table from a natural language description.

Create records

Tool to create multiple records (up to 10) in a specified Airtable table.

Create table

Creates a new table within a specified existing Airtable base, allowing definition of its name, description, and field structure.

Delete Comment

Tool to delete a comment from a record in an Airtable table.

Delete multiple records

Tool to delete up to 10 specified records from a table within an Airtable base.

Delete Record

Permanently deletes a specific record from an existing table within an existing Airtable base.

Get Base Schema

Retrieves the detailed schema for a specified Airtable base, including its tables, fields, field types, and configurations, using the `baseId`.

Get Record

Retrieves a specific record from an Airtable table by its record ID.

Get user information

Retrieves information, such as ID and permission scopes, for the currently authenticated Airtable user from the `/meta/whoami` endpoint.

List bases

Retrieves all Airtable bases accessible to the authenticated user, which may include an 'offset' for pagination.

List Comments

Tool to list comments on a specific Airtable record.

List records

Tool to list records from an Airtable table with filtering, sorting, and pagination.

Update Comment

Tool to update an existing comment on a specific Airtable record.

Update Field

Updates a field's name or description in an Airtable table.

Update multiple records

Tool 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 record

Modifies 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 Table

Updates the name, description, and/or date dependency settings of a table in Airtable.

Upload attachment

Uploads a file attachment to a specified field in an Airtable record.

SETUP GUIDE

Connect Airtable MCP Tool with your Agent

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai
Install the Composio SDK and your agent framework
2

Create a session with MCP enabled

typescript
import { Composio } from "@composio/core";

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["airtable"],
  mcp: true,
});
Create a session scoped to Airtable and read its MCP URL and headers
3

Connect your agent to the MCP server

typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "Add a new project record to the \"Projects\" table with today's date and status as \"In Progress\".",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();
Pass the session's MCP URL and headers to your agent and run a Airtable request
SETUP GUIDE

Connect Airtable API Tool with your Agent

1

Install Composio

typescript
npm install @composio/core @composio/openai openai
Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
2

Create a Composio session

typescript
import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["airtable"] });
const tools = await session.tools();
Initialize Composio with the OpenAI Responses provider and create a session scoped to Airtable
3

Run Airtable tools with your agent

typescript
let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "Add a new project record to the \"Projects\" table with today's date and status as \"In Progress\"." }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);
Send a request, execute the Airtable tool calls through the session, and print the final answer
Guide

Connect multiple Airtable accounts to Claude and tell it which one to use by name.

Read the guide

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

Rolling this out across your team?

Give your team centralized access control across every framework with Composio’s MCP Gateway.

EXPLORE MCP GATEWAY
FAQ

Frequently asked questions

No. Composio provides a managed OAuth app for Airtable, so you sign in with your normal Airtable account and approve access. If you later want the consent screen to show your own company name, you can add your own Airtable OAuth app in the Composio dashboard, and every connection after that uses it.

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

Yes. Composio is SOC 2 Type II compliant and is built to keep your Airtable connection and credentials secure. OAuth tokens and API keys are encrypted, and sensitive customer data is protected at rest and in transit.

Composio also undergoes independent security testing and continuously monitors its systems for security threats. You can review the latest reports and policies in the Composio Trust Center.

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

When you connect a Airtable account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in Airtable as done by you. Keep an approval step in your prompt for actions with side effects, such as sending or deleting, and have the agent draft first.

Exactly the ones Airtable lists on its consent screen when you connect. Review that screen before approving. If you connect a work account, your Airtable administrator may need to approve the app first, and you can revoke the access inside Airtable whenever you want.

Yes. Composio supports multiple connected accounts for the same app, and that works in Claude, ChatGPT, or any other assistant you connect through Composio. Give each Airtable connection a name such as work or personal, and the assistant uses the one you mention in the request. Each account keeps its own credentials and nothing is merged.

Composio refreshes Airtable tokens automatically, so day to day you do nothing. If you revoke access inside Airtable, or Airtable invalidates the session, the connection shows as expired in Composio and the agent stops acting on that account until you reconnect it, which is a single sign-in.

Composio's free Hobby plan includes 100,000 tool calls per month with no credit card, and up to 20,000 of those can run through Composio-managed apps like Airtable. Personal Airtable use rarely gets near that. Paid plans add higher limits and team features, and Airtable's own pricing is unaffected.

Built-in connectors usually give one AI access to a limited set of apps. Many people use Composio because it lets their AI connect to more apps than it normally supports, or connect to multiple accounts for the same app (e.g. connect Claude to multiple Airtable accounts).

With Composio, you connect Airtable once and then use it across different AI assistants without setting it up separately in each one. Connect your apps to Composio once, then connect Composio to whichever AI you use, whether that's Claude, ChatGPT, Hermes, or your own custom assistant.

Start with Airtable.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Airtable tool your agent needs.Free to start.

Start building