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.

26 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 an Airtable record from a natural language description using the table schema and an LLM-generated field payload.

Create records

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

Create table

Creates a table in an existing Airtable base with a specified 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 Attachment Info

Retrieves attachment metadata and download URLs from a specified Airtable record field, including sizes, types, and thumbnails when available; attachment URLs expire 2 hours after retrieval.

Get Base Metadata

Retrieves basic metadata for one 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

Lists a page of Airtable bases accessible to the authenticated token.

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.

Who Am I

Returns the connected Airtable account's user ID and, when available, email address.

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

Start with Airtable.It takes 30 seconds.

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

Start building