← Back to directory

Airtable MCP Server

Community

Full Airtable CRUD, schema, and automation access for AI applications over MCP

GitHub source repository ↗

★ 87 Stars Category · Database Popular Source revision 19f7cd772f78

61FMRS · C

Reliability

8/20

Security and permissions

11/20

Maintenance

13/20

Documentation

16/20

Setup experience

13/20

A comprehensive third-party Airtable MCP server offering 42 tools across records, schema, batch operations, webhooks, comments, and governance, supporting both stdio and streamable HTTP transports across modern and legacy MCP protocol clients; well suited for teams already on Airtable wanting deep AI integration, though as a community-maintained project it warrants attention to token security and the impact of its write/delete operations.

Read the FMRS scoring method →

Airtable MCP Server is a Model Context Protocol server that gives any MCP client — Claude, Codex, Cursor, Windsurf, VS Code — comprehensive access to Airtable. It provides 42 tools covering record CRUD, schema and table/field management, batch operations (up to 10 records per call), webhook management, record comments, governance/compliance controls (allow-lists, PII masking), and 10 AI prompt templates for analytics. It runs over local stdio or streamable HTTP for remote deployments, and serves both the modern 2026-07-28 MCP protocol and legacy 2025-era clients.

Tools

list_bases

List all accessible bases with permissions

describe

Describe base or table schema (supports detail levels)

query

Query records with filtering, sorting, and pagination

search_records

Advanced search with Airtable formulas

list_records

List records with field selection and pagination

get_record

Retrieve a single record by ID

create

Create new records (requires dryRun diff review)

update

Update existing records (requires dryRun diff review)

delete_record

Remove a record from a table

upsert

Update or create records based on merge fields

batch_upsert_records

Batch upsert with merge-on fields

list_tables

Get all tables in a base with schema info

get_base_schema

Get complete schema for any base

list_field_types

Reference guide for available field types

get_table_views

List all views for a table

create_table

Create tables with custom field definitions

update_table

Modify table names and descriptions

delete_table

Remove tables (requires confirmation)

create_field

Add fields to existing tables

update_field

Modify field properties and options

delete_field

Remove fields (requires confirmation)

batch_create_records

Create up to 10 records at once

batch_update_records

Update up to 10 records simultaneously

batch_delete_records

Delete up to 10 records in one operation

list_webhooks

View all configured webhooks

create_webhook

Set up real-time notifications

delete_webhook

Remove webhook configurations

get_webhook_payloads

Retrieve notification history

refresh_webhook

Extend webhook expiration

create_view

Create views (grid, form, calendar, etc.)

get_view_metadata

Get view details including filters

upload_attachment

Attach files from URLs

create_base

Create new bases with initial structure

list_collaborators

View collaborators and permissions

list_shares

List shared views and configurations

list_comments

List comments on a record

create_comment

Add a comment to a record

update_comment

Edit an existing comment

delete_comment

Remove a comment

whoami

Get current user identity and scopes

list_governance

Return governance allow-lists and PII masking policies

list_exceptions

List recent exceptions and remediation proposals

Setup

Create a Personal Access Token at airtable.com/create/tokens and grant all the Token Scopes listed in the docs.
Note your Base ID (from the base URL) or skip it and discover bases dynamically via list_bases.
Claude Desktop: edit the config file (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json; Windows: %APPDATA%\Claude\claude_desktop_config.json), add the airtable entry under mcpServers with AIRTABLE_TOKEN (and optional AIRTABLE_BASE_ID), then restart Claude Desktop.
Claude Code: run the one-command installer curl -fsSL https://raw.githubusercontent.com/rashidazarang/airtable-mcp/main/setup.sh | bash, or edit ~/.claude.json manually.
Codex/Cursor/Windsurf/VS Code: add the equivalent npx-based server entry and environment variables to each client's MCP config file.
For clients that cap enabled tools (e.g. Cursor's 40-tool limit), set AIRTABLE_TOOLSET=core or a comma-separated tool allowlist.

claude_desktop_config.json

{"mcpServers":{"airtable":{"command":"npx","args":["-y","@rashidazarang/airtable-mcp"],"env":{"AIRTABLE_TOKEN":"YOUR_AIRTABLE_TOKEN","AIRTABLE_BASE_ID":"YOUR_BASE_ID"}}}}

Generate and validate client config

Fit and risk

Best for

Teams already using Airtable for projects, tasks, or customer data who want AI assistants to operate on it directly
Developers integrating Airtable automation into Claude, Codex, Cursor, or other MCP clients
Use cases needing governance and PII-masking controls over AI access to base data

Not for

Users who don't use Airtable
Organizations requiring guaranteed official vendor support (this is a third-party, community-maintained project, not an Airtable product)
Environments that can't accept running a remote npm package fetched fresh via npx on each launch

Required permissions

data.records:read — read records
data.records:write — create, update, delete records
data.recordComments:read — read record comments
data.recordComments:write — create, update, delete comments
schema.bases:read — view table schemas
schema.bases:write — create and modify tables and fields
user.email:read — read user identity (whoami)
webhook:manage — manage webhooks (optional)

Risks and side effects

The server can write, modify, and delete Airtable data and schema; misuse or prompt injection could cause data loss, though create/update require a dryRun diff review
The Personal Access Token is stored in plaintext in client config environment variables, so config file access must be protected
This is a third-party project (not maintained by Airtable) fetched fresh from npm via npx on each run, introducing a supply-chain trust dependency on the maintainer
Destructive operations like delete_table, delete_field, and batch_delete_records exist; some require confirmation but scopes should still be reviewed carefully before granting

Troubleshooting

Connection issues: verify the MCP server is running and restart your MCP client
Invalid token: confirm the Personal Access Token is correct, has the required scopes, and has no extra whitespace
Base not found: confirm the Base ID is correct, verify the token has access, or use list_bases to discover accessible bases
Clients with tool caps (e.g. Cursor): set AIRTABLE_TOOLSET=core or a comma-separated allowlist to reduce the number of registered tools

Use cases

Query, filter, and update Airtable records using natural language

Create and modify table schemas, fields, and views conversationally

Batch create, update, or delete records for automation workflows

Set up webhooks for real-time notifications on data changes

Add, edit, and manage comments on records

Use built-in AI prompt templates for data insights, quality audits, and predictive analytics

Supported clients

Claude DesktopFull support

Claude CodeFull support

CodexFull support

CursorPartial support

WindsurfFull support

VS CodeFull support

Related MCP servers

Compare with other MCP servers