# Airtable MCP

> Airtable MCP is an open-source MCP server for databases. MCP server giving AI clients governed read and write access to Airtable bases. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** CLI, API, Self-hosted, macOS, Windows, Linux, VS Code
- **Website:** https://www.airtablemcp.com
- **Repository:** https://github.com/rashidazarang/airtable-mcp
- **MCP Registry name:** io.github.rashidazarang/airtable-mcp
- **Categories:** [databases](https://ai-powered.com/categories/databases), [productivity](https://ai-powered.com/categories/productivity), [agent tooling](https://ai-powered.com/categories/agent-tooling)
- **Listing updated:** 2026-11-19

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (claude_desktop_config.json)

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

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

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

## 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

## 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.

## Alternatives

- [Airtable](https://ai-powered.com/mcp/airtable-4): Airtable is an open-source MCP server for productivity.
- [Airtable MCP by InsightfulPipe](https://ai-powered.com/mcp/airtable-mcp-by-insightfulpipe): Airtable MCP by InsightfulPipe is an MCP server for productivity.
- [Baserow](https://ai-powered.com/mcp/baserow): Baserow is a freemium MCP server for databases.
- [Fastmcp Sqltools](https://ai-powered.com/mcp/fastmcp-sqltools): Fastmcp Sqltools is an open-source MCP server for databases.
- [TableThis](https://ai-powered.com/mcp/tablethis): TableThis is a freemium MCP server for productivity.
- [Mongodb MCP Server](https://ai-powered.com/mcp/mongodb-mcp-server): Mongodb MCP Server is an open-source MCP server for databases.
- [Teable](https://ai-powered.com/mcp/teable): Teable is a freemium MCP server for databases.
- [Cognigy Ai MCP Management Server](https://ai-powered.com/mcp/cognigy-ai-mcp-management-server): Cognigy Ai MCP Management Server is an open-source MCP server for agent tooling.

---
Source: https://ai-powered.com/mcp/airtable-mcp-2
