Airtable MCP Server

Official Airtable MCP server. Search, analyze, create, and update records across Airtable bases, tables, and interfaces via mcp.airtable.com.

Collaboration by Airtable OAuth2 active

Connect (Remote Server) Docs

Overview

The Airtable MCP server is the official Model Context Protocol endpoint maintained by Airtable, hosted at https://mcp.airtable.com/mcp. It lets AI agents and MCP-capable clients (Claude, ChatGPT, Cursor, Amazon Q, Claude Code, etc.) read and write data across Airtable bases, tables, fields, records, comments, and interfaces using natural language. The server respects existing Airtable permissions, so an agent can only do what the authenticated user is allowed to do.

The server exposes 20+ tools covering discovery (list workspaces, bases, tables, interfaces), data retrieval (list, get, and search records), data management (create, update, delete records, manage fields and tables), comments, file uploads to attachment fields, and even creating entire new bases from scratch. Recent additions include list_workspaces, create_base, and upload_attachment (added in May 2026).

Because it is provider-hosted and OAuth2-based, there is no code to install. Users either authorize the pre-built connectors in Claude or ChatGPT, or register a custom OAuth client in Airtable's developer portal for clients like Cursor. A Personal Access Token (PAT) can also be supplied via a custom Bearer Authorization header for clients that do not support OAuth flows.

Tools

Tool	Description
`list_workspaces`	List Airtable workspaces accessible to the authenticated user.
`list_bases`	Retrieve a list of Airtable bases the user can access.
`list_tables`	Retrieve tables within a specified base, with selectable detail levels (tableIdentifiersOnly, identifiersOnly, or full).
`describe_table`	Get detailed information about a specific table including field types, descriptions, and configurations.
`list_records`	Retrieve records from a table, optionally filtered by formula, view, sort, or page size.
`get_record`	Retrieve a single record by its record ID.
`search_records`	Search for records containing specific text. Read-only.
`create_record`	Create a new record in a table. Up to 10 records per request.
`update_records`	Update up to 10 records in a table.
`delete_records`	Delete one or more records from a table.
`create_field`	Create a new field in an existing table.
`create_table`	Create a new table in a base with fields and configuration.
`update_table`	Update a table's name or description.
`create_base`	Create a new base from scratch with custom tables and fields.
`create_comment`	Create a comment on a record.
`upload_attachment`	Upload a file directly to an attachment field on an existing record via Airtable's content API. Files up to 5 MB.
`list_interfaces`	List Airtable Interfaces the user has access to.
`query_interface`	Query data from an Airtable Interface, including for users with interface-only permissions.

Setup Guide

Server URL

https://mcp.airtable.com/mcp

Prerequisites

An Airtable account with access to at least one base
Organization permission to enable third-party integrations (admin may need to allow)
An MCP-capable client (Claude, ChatGPT, Cursor, Claude Code, Amazon Q, etc.)

Claude (Web / Desktop)

Visit the connector page at claude.com/connectors/airtable and authorize via OAuth.

Claude Code (Terminal)

claude mcp add --transport http airtable https://mcp.airtable.com/mcp

Then run /mcp inside Claude Code to start the OAuth flow.

ChatGPT

Use the pre-built Airtable connector (Client ID 7a713e1a-3d99-4fdf-b59a-311bdf94ba97).

Cursor / Custom MCP clients (OAuth)

Register an OAuth client in the Airtable developer portal with your client's redirect URI, then add the server to your MCP config:

{
  "mcpServers": {
    "airtable": {
      "url": "https://mcp.airtable.com/mcp",
      "transport": "http"
    }
  }
}

Personal Access Token (alternative)

For clients that support custom headers, supply a PAT instead of OAuth:

Authorization: Bearer <YOUR_PERSONAL_ACCESS_TOKEN>

Required OAuth Scopes

data.records:read, data.records:write, schema.bases:read, schema.bases:write, data.recordComments:read, data.recordComments:write, workspacesAndBases:read, webhook:manage

Use Cases

Ask natural-language questions about base data ("Which deals in the Pipeline base closed last week and total over $50K?") without writing filterByFormula syntax.
Bulk-create or update records from agent workflows, e.g. dropping form responses, email parses, or research findings into a CRM or content calendar base.
Generate entire base schemas: have an agent design tables, fields, and relationships, then call create_base to spin up a working base from a prompt.
Upload screenshots, PDFs, or generated images directly into attachment fields on records via upload_attachment.
Query Airtable Interfaces for users who only have interface-level permissions, surfacing filtered dashboards inside an AI assistant.

Example Prompts

"List all bases in my Marketing workspace, then show me the schema for the Content Calendar table."
"Find every record in the Leads table where Status is 'Qualified' and Last Contact is older than 30 days, and add a comment tagging the owner."
"Create a new base called 'Q3 Launch Tracker' with tables for Tasks, Owners, and Milestones, including a linked record field between Tasks and Owners."
"Update the Status field to 'Shipped' for these 8 record IDs in the Orders table."
"Upload this PNG into the Logo attachment field on the Acme Corp record in the Customers table."

Pros

Officially maintained by Airtable, hosted at a stable URL with no self-hosting required.
Broad tool coverage including schema creation, record CRUD, comments, file uploads, and Interface access.
OAuth2 with granular scopes that respect existing Airtable permissions; PAT fallback for clients without OAuth support.
Pre-built connectors for Claude and ChatGPT mean zero-config setup for most users.

Limitations

Subject to standard Airtable API rate limits and a 10-record cap per create/update request, which can slow large migrations.
Cannot access Airtable development apps or extensions.
Requires organization admins to allow third-party integrations, which may block setup in some workspaces.

Alternatives

domdomegg/airtable-mcp-server: community open-source Airtable MCP server you self-host.
felores/airtable-mcp: community implementation focused on search, create, and update operations.
Zapier MCP for Airtable: third-party hosted option if you prefer Zapier's auth and action layer.