rashidazarang/airtable-mcp

A Model Context Protocol (MCP) server for Airtable with full CRUD operations, schema management, record comments, webhooks, batch operations, governance controls, and AI-powered analytics.
**Version 5.1.0** | MCP Protocol 2026-07-28 (stateless core, legacy 2025-era clients still served) | Works with Claude, Codex, Cursor, Windsurf, VS Code, and any MCP client |
---
Quick Start (Claude Desktop)
No installation required — just add this to your Claude Desktop config and restart:
**macOS**: ~/Library/Application Support/Claude/claude_desktop_config.json
**Windows**: %APPDATA%\Claude\claude_desktop_config.json
That's it. npx downloads and runs the server automatically. No git clone, no npm install.
> **Get your token** at airtable.com/create/tokens — grant all scopes listed under Token Scopes below. **Get your Base ID** from the URL when viewing your base: https://airtable.com/[BASE_ID]/... (or omit it and use list_bases to discover bases dynamically).
---
Quick Start (Claude Code)
One-command install
The script checks prerequisites, prompts for your Airtable token, and writes the MCP config to ~/.claude.json. Restart Claude Code (or run /mcp) to connect.
You can also pass your token directly:
Manual config
Add to ~/.claude.json under mcpServers:
> **Why the bash wrapper?** npx can fail to resolve the binary when run from a directory that contains a package.json with the same package name. The cd /tmp && prefix avoids this edge case.
---
Quick Start (Codex, Cursor, Windsurf, VS Code)
The server works with any MCP client. It serves both the modern 2026-07-28 protocol and 2025-era clients automatically — no configuration needed for either.
OpenAI Codex (CLI, IDE extension, ChatGPT desktop)
One command:
Or edit ~/.codex/config.toml (or .codex/config.toml for a trusted project) directly:
The Codex CLI, IDE extension, and ChatGPT desktop app share this configuration.
Cursor
Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project):
> **Why AIRTABLE_TOOLSET=core?** Cursor caps agents at **40 enabled tools across all servers**, and this server exposes 42. The core profile registers the 18 record-centric tools (reads, writes, batches, governance), leaving room for other servers. Omit it (or set full) if Airtable is your only MCP server and you manage the cap by disabling individual tools in Cursor's *Tools & MCP* settings. Also note: Cursor offers MCP tools in **Agent** and **Plan** modes only (not Ask/Edit), and consumes tools and resources but not MCP prompts.
Windsurf
Add the same JSON block to ~/.codeium/windsurf/mcp_config.json (Cascade → MCP settings). Windsurf supports per-tool toggling if you prefer the full toolset.
VS Code (GitHub Copilot agent mode)
Add to .vscode/mcp.json:
Compatibility notes (any client)
- **Both protocol eras served** — modern 2026-07-28 clients and legacy 2025-era clients (Codex, Cursor, Windsurf, Cline, Zed, and most others today) negotiate automatically.
- **Tool names are client-safe** — bare snake_case, well under length limits, and free of : and * (reserved by Cursor's allowlist grammar server:tool).
- **Logs never touch stdout** — all logging goes to stderr, so stdio framing is never corrupted.
- **Remote/HTTP clients** — start the server with PORT or MCP_HTTP_PORT set and point the client at http://host:port/mcp (streamable HTTP, stateless; /health for orchestrators).
- **Tool caps** — use AIRTABLE_TOOLSET=core or an explicit allowlist (e.g. AIRTABLE_TOOLSET=describe,query,list_records) for clients that limit enabled tools or to slim the agent's context.
---
Overview
This server provides comprehensive Airtable integration through the Model Context Protocol, enabling natural language interactions with your Airtable data. It includes **42 tools** covering every Airtable PAT scope and **10 AI prompt templates** for intelligent analytics.
Key Features
- **Full CRUD Operations** — Create, read, update, and delete records with filtering and pagination