Skip to content
MCP server

Airtable MCP

MCP server giving AI clients governed read and write access to Airtable bases

Runs locally
Install

Airtable MCP is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

Pricing
Open source
Platforms
CLI, API, Self-hosted
Runs
Locally
Version
5.1.0
Listing updated

Similar MCP servers

Install

Run in a terminal

claude mcp add airtable-mcp --env AIRTABLE_TOKEN='<AIRTABLE_TOKEN>' -- npx -y @rashidazarang/airtable-mcp

Add to claude_desktop_config.json

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

Add to ~/.cursor/mcp.json

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

Add to .vscode/mcp.json

{
  "servers": {
    "airtable-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@rashidazarang/airtable-mcp"
      ],
      "env": {
        "AIRTABLE_TOKEN": "<AIRTABLE_TOKEN>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Using several servers? Build one config file with the MCP config generator.

Configuration

  • AIRTABLE_TOKENAirtable personal access token from https://airtable.com/create/tokens. Grant data.records, data.recordComments and schema.bases (read and write) and user.email:read.Required
  • AIRTABLE_BASE_IDDefault base ID. When set, other bases are refused unless listed in AIRTABLE_ALLOWED_BASES. Leave unset to use every base the token can reach.
  • AIRTABLE_ALLOWED_BASESComma-separated base IDs the server may use. Unset allows every base the token can reach.
  • AIRTABLE_ALLOWED_TABLESComma-separated baseId:tableName pairs. In a base listed here, only the listed tables are allowed.
  • AIRTABLE_TOOLSETTools to register: full (all tools), core (18 record tools, for clients that cap enabled tools) or a comma-separated list of tool names.
  • AIRTABLE_GOVERNANCE_PATHPath to a governance JSON file (allow-lists, allowed operations, PII field policies). Defaults to config/governance.json in the working directory, if present.
  • LOG_LEVELLog level. Logs go to stderr.
  • EXCEPTION_QUEUE_SIZEHow many recent errors the list_exceptions tool keeps.

About Airtable MCP

The README describes this as a local Model Context Protocol server that connects AI clients such as Claude Desktop, Claude Code, Cursor, Codex, Windsurf and VS Code to Airtable through a personal access token. It covers records, schema, field and table management, record comments, webhooks and user identity, exposing these as tools the assistant can call from natural language requests.

A notable part of the design is governance. Environment variables let an operator restrict the server to specific base IDs or baseId:table pairs, and a governance JSON file can define allowed operations and PII field masking. Errors are kept in a queue that a list_exceptions tool can read back, and logs are written to stderr so stdio traffic stays clean.

The package is aimed at people who already use Airtable as a database and want an assistant to query, update or restructure it, particularly where access needs to be limited. The site and README state the project is MIT licensed and installed via npx, with an optional HTTP transport for hosted deployments.

Tools this server provides (42)

Taken from the project documentation; the running server may differ.

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

What it does

Record read and write tools
Lists, queries, searches, creates, updates, deletes and upserts Airtable records, with batch operations capped at 10 records.
Schema inspection and editing
Describes bases and tables and can create or modify tables, fields and views.
Base and table allow-lists
Environment variables restrict which bases and tables the server may touch.
PII masking policies
A governance file can define field-level masking and allowed operations.
Record comments
Lists, creates, edits and deletes comments on individual records.
Webhook management
Creates, lists, refreshes and deletes webhooks and retrieves payload history.
Toolset selection
A core profile of 18 record tools or a custom list can be chosen for clients that cap enabled tools.

Good for

  • Letting an AI assistant read and update task or project records in Airtable
  • Setting up Airtable tables and fields from a natural language description
  • Restricting an assistant to specific bases or tables for shared workspaces
  • Bulk updating or deleting Airtable records through an agent workflow
  • Monitoring Airtable changes with webhooks from an AI client

Pricing

Open source

Free and MIT licensed; no paid plan is described.

Prices change. Check airtablemcp.com before you buy.

Airtable MCP FAQ

Does Airtable MCP run locally?

The registry entry lists stdio transport for local use, and the README shows installation through npx. An HTTP transport is available when PORT or MCP_HTTP_PORT is set.

What does the Airtable token need?

The README lists scopes for records, record comments, schema bases (read and write), user email and optional webhook management.

Is Airtable MCP free?

The site says it is free forever under the MIT license, and the README confirms the MIT license.

Can I limit which bases Airtable MCP accesses?

Yes. AIRTABLE_BASE_ID, AIRTABLE_ALLOWED_BASES and AIRTABLE_ALLOWED_TABLES restrict access.

How do I add Airtable MCP to Claude Code?

Run this command in your terminal: claude mcp add airtable-mcp --env AIRTABLE_TOKEN='<AIRTABLE_TOKEN>' -- npx -y @rashidazarang/airtable-mcp

What are the best alternatives to Airtable MCP?

The closest alternatives to Airtable MCP are Airtable, Airtable MCP by InsightfulPipe, Baserow, Fastmcp Sqltools and TableThis.

Where this comes from

  • Description: written from the project's README, the project's website and its MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers