What Is Airtable MCP Server?

Airtable MCP Server connects Claude directly to your Airtable bases, enabling read and write operations on records, fields, and tables without leaving your AI workflow. It is maintained by rashidazarang and distributed as an npm package under active development.

Quick Facts

Field	Value
Package	`mcp-airtable`
Install	`npx mcp-airtable`
Compatible with	Claude Desktop, Claude Code
Status	Active
GitHub	https://github.com/rashidazarang/airtable-mcp

What You Can Do With It

Database queries: Ask Claude to filter, search, and retrieve records from any Airtable base your token can access.
Record creation: Create new records in a specified table directly from a Claude prompt, without opening the Airtable UI.
CRM management: Read and update contact or deal records in an Airtable-backed CRM from within a Claude conversation.
Project tracking: Pull task lists, update statuses, or add new items to a project tracking base in real time.

How to Set It Up

Step 1 — Obtain an Airtable personal access token

Go to airtable.com/create/tokens and create a token with the scopes data.records:read and data.records:write (add schema.bases:read if you need table/field metadata). Note your Base ID from the Airtable URL (appXXXXXXXXXXXXXX).

Step 2 — Add the server to your Claude config

For Claude Desktop, edit ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or the equivalent path on your OS:

``json { "mcpServers": { "airtable": { "command": "npx", "args": ["mcp-airtable"], "env": { "AIRTABLE_API_KEY": "your_personal_access_token", "AIRTABLE_BASE_ID": "appXXXXXXXXXXXXXX" } } } } For **Claude Code**, add the equivalent block to.claude/mcp.json` in your project root using the same structure.

Step 3 — Restart Claude

Restart Claude Desktop or reload the Claude Code session. The Airtable tools will appear in the tool list if the server started correctly.

Works Best With

This server is tested against Claude Desktop and Claude Code. Both clients support the full MCP tool-calling loop required for read/write operations. Claude Desktop is suited for interactive, one-off data tasks; Claude Code is better for scripted or repeated operations embedded in a development workflow.

Known Limitations

Authentication scope: You must manually configure token scopes in Airtable. An under-scoped token will cause silent failures or permission errors — check scopes first if tools return no data.
Rate limits: Airtable’s API enforces 5 requests per second per base. Heavy queries or bulk record operations may hit this limit. The server does not implement automatic retry logic, so you may need to handle throttling manually.
Single base per instance: The config expects one AIRTABLE_BASE_ID per server instance. Accessing multiple bases requires running separate server entries in your config.
No attachment handling: Binary field types such as file attachments are not a documented use case and may not behave as expected.
Schema changes: Renaming or deleting fields in Airtable while a session is active can cause tool errors mid-conversation.