Airtable MCP Server

Provides MCP resources and tools for AI assistants to access, manage, and modify records, bases, and comments within Airtable, supporting both data and schema operations.

records

Dataset

List records in a table.

idcreatedTimeAddress +3 more

user_info

Dataset

Retrieve the user's ID, email (if scoped), and token scopes (if OAuth).

idemailscopes

bases

Dataset

Returns the list of bases the token can access.

idnamepermissionLevel

comments

Dataset

Returns a list of comments for a specific record.

idcreatedTimelastUpdatedTime +5 more

enterprise_packages

Dataset

List all packages for an enterprise account.

idnametype +7 more

listrecords_post

Tool

Alternative POST method to list records, used when query parameters (like filterByFormula) cause the URL length to exceed 16,000 characters.

timeZone (optional)userLocale (optional)pageSize (optional) +6 more

create_records

Tool

Creates one or multiple records (up to 10) in a specified table.

baseId (required)tableIdOrName (required)records/fields (data payload) (required) +2 more

update_multiple_records

Tool

Updates up to 10 existing records using PATCH (partial update) or PUT (destructive update). Supports upsert functionality via 'performUpsert'.

baseId (required)tableIdOrName (required)records/fields (data payload) (required) +5 more

update_record

Tool

Updates a single record using PATCH (partial update) or PUT (destructive update). PATCH only updates specified fields; PUT clears all unspecified fields.

baseId (required)tableIdOrName (required)recordId (required) +3 more

delete_record

Tool

Deletes a single record.

baseId (required)tableIdOrName (required)recordId (required)

delete_multiple_records

Tool

Deletes up to 10 records given an array of record ids.

baseId (required)tableIdOrName (required)records (query parameter, array of recordIds) (required)

sync_csv_data

Tool

Syncs raw CSV data into a Sync API table. Limited to 10k rows/2MB per request.

baseId (required)tableIdOrName (required)apiEndpointSyncId (required) +1 more

upload_attachment

Tool

Upload an attachment up to 5 MB to an attachment cell via the file bytes directly (base64 encoded).

baseId (required)recordId (required)attachmentFieldIdOrName (required) +3 more

create_field

Tool

Creates a new column (field) in a specified table.

baseId (required)tableId (required)name (required) +3 more

update_field

Tool

Updates the name and/or description of a field.

baseId (required)tableId (required)columnId (required) +2 more

oauth_authorize

Tool

Initiates the OAuth 2.0 Authorization Code flow with PKCE. Redirects the user for consent.

client_id (required)redirect_uri (required)response_type (code) (required) +4 more

oauth_token_creation

Tool

Exchanges the authorization grant code for an access token and refresh token.

code (required)redirect_uri (required)grant_type (authorization_code) (required) +4 more

oauth_token_refresh

Tool

Exchanges a refresh token for a new access token.

refresh_token (required)grant_type (refresh_token) (required)Content-Type: application/x-www-form-urlencoded (required) +2 more

create_comment

Tool

Creates a comment on a record.

baseId (required)tableIdOrName (required)recordId (required) +2 more

Airtable Resources

Datasets

Tools

Airtable MCP Server

Connect your AI to Airtable data through the Model Context Protocol.

Granularly control which tools your AI can access
Full visibility with logging and auditing
Standard MCP protocol - no custom wrappers needed

Select a dataset or tool from the left to see more details

Universal MCP Server for Airtable

Connect Claude, Microsoft Copilot, and any MCP-compatible AI to Airtable. One server, instant access to datasets, tools, and workflows.

Model Context Protocol: Industry standard supported by Claude and Microsoft Copilot
Fine-Grained Control: Choose exactly which datasets and tools your AI can access
Connect Once, Use Everywhere: Single authentication for all your AI assistants

Get Started with Your Favorite AI Tool

Follow our step-by-step guides for popular AI frameworks and tools

Native MCP support

Copilot + MCP

AI-first IDE

Custom actions

Automation platform