Airtable
FreeNot checkedEnables AI assistants to perform complete CRUD operations on Airtable bases, tables, records, fields, and comments, with batch processing and file attachment su
About
Enables AI assistants to perform complete CRUD operations on Airtable bases, tables, records, fields, and comments, with batch processing and file attachment support, plus enterprise-grade reliability features.
README
MCP Airtable
Production-ready MCP server for Airtable integration
TypeScript Node.js Tests License
Built with FastMCP — Works with Claude Desktop & Claude.ai
Overview
A minimal, enterprise-grade MCP server enabling AI assistants to interact with Airtable. Features 21 tools covering complete CRUD operations, batch processing, schema management, and file attachments—built with meticulous precision and strategic clarity.
Δ Capabilities
Core21 Tools — Full CRUD, batch operations, attachments Streamable HTTP — Claude Desktop 2025+ native support Header Auth — Multi-tenant ready architecture |
ReliabilityCircuit Breaker — Cascading failure prevention Auto-Retry — Exponential backoff with jitter Health Checks — K8s liveness & readiness probes |
SecurityInput Validation — Zod schemas everywhere Injection Prevention — Formula & path attacks blocked Audit Ready — Full security documentation |
PerformanceConnection Pooling — Keep-alive via undici Request Deduplication — Shares concurrent results Response Caching — 5-10min TTL for metadata |
Quick Start
npm install && npm run build
npm start
Server runs at http://localhost:3000/mcp
Configuration
Local Development (stdio)
{
"mcpServers": {
"mcp-airtable": {
"command": "node",
"args": ["/path/to/mcp-airtable/dist/index.js", "--stdio"],
"env": {
"AIRTABLE_API_KEY": "patXXXXX.XXXXX..."
}
}
}
}
Remote HTTP (mcp-remote)
{
"mcpServers": {
"mcp-airtable": {
"command": "npx",
"args": [
"-y", "mcp-remote",
"https://your-server.com/mcp",
"--header", "x-airtable-api-key:patXXXXX.XXXXX...",
"--header", "x-airtable-workspace-id:wspXXXXXXXXXXX"
]
}
}
}
Claude.ai Web
- Deploy:
npm start - Claude.ai → Settings → Connectors
- Add URL:
https://your-server.com/mcp - Add header:
x-airtable-api-key: patXXXXX...
| Platform | Config Path |
|---|---|
| macOS | ~/Library/Application Support/Claude/claude_desktop_config.json |
| Windows | %APPDATA%\Claude\claude_desktop_config.json |
β Tools
| Category | Tools |
|---|---|
| Bases & Workspaces | list_workspaces° · list_bases · get_base_schema · create_base |
| Tables | list_tables · create_table · update_table |
| Fields | create_field · update_field · upload_attachment |
| Records | get_records · get_record · create_records · update_record · delete_record |
| Batch | upsert_records · delete_records |
| Comments | list_comments · create_comment · update_comment · delete_comment |
| Health | health_check · liveness · readiness |
° Enterprise Scale plan required
Usage
"List all my Airtable bases"
"Get records from Tasks where Status = 'Active'"
"Create a task with Name='Review PR' and Priority='High'"
"Upload the PDF to the Attachments field on record rec123"
Authentication
| Priority | API Key | Workspace ID |
|---|---|---|
| 1 | x-airtable-api-key header |
x-airtable-workspace-id header |
| 2 | Authorization: Bearer header |
workspaceId parameter |
| 3 | airtableApiKey parameter |
AIRTABLE_WORKSPACE_ID env |
| 4 | AIRTABLE_API_KEY env |
— |
Airtable Plan Requirements
API Scopes by Plan
| Scope | Free | Team | Business | Enterprise |
|---|---|---|---|---|
data.records:read |
✅ | ✅ | ✅ | ✅ |
data.records:write |
✅ | ✅ | ✅ | ✅ |
data.recordComments:read |
✅ | ✅ | ✅ | ✅ |
data.recordComments:write |
✅ | ✅ | ✅ | ✅ |
schema.bases:read |
✅ | ✅ | ✅ | ✅ |
schema.bases:write |
✅ | ✅ | ✅ | ✅ |
webhook:manage |
✅ | ✅ | ✅ | ✅ |
user.email:read |
✅ | ✅ | ✅ | ✅ |
workspacesAndBases:read |
❌ | ❌ | ✅ | ✅ |
enterprise.* scopes |
❌ | ❌ | ❌ | ✅ |
API Rate Limits by Plan
| Plan | Monthly Calls | Rate Limit | Overage Behavior |
|---|---|---|---|
| Free | 1,000/month | 5 req/sec | 30-day grace period (once), then blocked |
| Team | 100,000/month | 5 req/sec | Throttled to 2 req/sec until reset |
| Business | Unlimited | 5 req/sec | — |
| Enterprise | Unlimited | 5 req/sec | — |
Tool Compatibility
| Tool | Required Scope | Min Plan |
|---|---|---|
list_workspaces |
workspacesAndBases:read |
Enterprise° |
list_bases |
schema.bases:read |
Free |
get_base_schema |
schema.bases:read |
Free |
create_base |
schema.bases:write |
Free |
list_tables |
schema.bases:read |
Free |
create_table |
schema.bases:write |
Free |
update_table |
schema.bases:write |
Free |
create_field |
schema.bases:write |
Free |
update_field |
schema.bases:write |
Free |
get_records |
data.records:read |
Free |
get_record |
data.records:read |
Free |
create_records |
data.records:write |
Free |
update_record |
data.records:write |
Free |
delete_record |
data.records:write |
Free |
upsert_records |
data.records:write |
Free |
delete_records |
data.records:write |
Free |
upload_attachment |
data.records:write |
Free |
list_comments |
data.recordComments:read |
Free |
create_comment |
data.recordComments:write |
Free |
update_comment |
data.recordComments:write |
Free |
delete_comment |
data.recordComments:write |
Free |
° Returns 404 on non-Enterprise plans. Workaround: Get workspace ID from Airtable UI URL (airtable.com/wspXXX/...)
Stability & Resilience
Retry with Exponential Backoff
- Auto-retries on HTTP 429, 500, 502, 503, 504
- Handles network errors (ECONNRESET, ETIMEDOUT, ECONNREFUSED)
- Respects
Retry-Afterheaders - Configurable max retries, delays, jitter
Circuit Breaker Pattern
Prevents cascading failures:
- CLOSED — Normal operation
- OPEN — Fast-fail mode
- HALF_OPEN — Recovery testing
Request Management
- Timeout: 30s default (AbortController)
- Deduplication: Shares identical concurrent GETs
- Queue: Limits to 5 concurrent requests
- Keep-Alive: Connection pooling via undici
Health Checks
Kubernetes-ready probes:
health_check— Full status reportliveness— Alive checkreadiness— Traffic ready
Deployment
FROM node:20-alpine
WORKDIR /app
COPY package*.json ./
RUN npm ci --production
COPY dist ./dist
EXPOSE 3000
CMD ["node", "dist/index.js"]
docker build -t mcp-airtable .
docker run -p 3000:3000 mcp-airtable
Environment Variables
# Server
PORT=3000
NODE_ENV=production
# Auth (prefer headers in production)
AIRTABLE_API_KEY=
AIRTABLE_WORKSPACE_ID=
# Rate Limiting
RATE_LIMIT_ENABLED=true
RATE_LIMIT_REQUESTS_PER_MINUTE=60
# Caching
CACHE_ENABLED=true
CACHE_TTL_BASES=300
CACHE_TTL_SCHEMA=600
CACHE_TTL_TABLES=300
# Logging
LOG_LEVEL=info
# Sentry (Optional)
SENTRY_DSN=
SENTRY_DEBUG=false
SENTRY_ENVIRONMENT=production
Architecture
src/
├── index.ts # Entry point
├── server.ts # FastMCP init
├── tools/ # 21 tools
│ ├── bases.ts
│ ├── tables.ts
│ ├── fields.ts
│ ├── records.ts
│ ├── batch.ts
│ └── comments.ts
└── lib/ # Core
├── airtable/ # API client
├── retry.ts # Backoff
├── circuit-breaker.ts # Failure prevention
├── health.ts # K8s probes
├── deduplication.ts # Request dedup
└── ...
~2,500 lines · 272 unit tests · 25 e2e tests
References
| MCP Specification | modelcontextprotocol.io |
| FastMCP | github.com/punkpeye/fastmcp |
| mcp-remote | npmjs.com/package/mcp-remote |
| Airtable API | airtable.com/developers |
Installing Airtable
This server has no published package — it is built from source. Open the repository and follow its README.
▸ github.com/delta-and-beta/mcp-airtableFAQ
Is Airtable MCP free?
Yes, Airtable MCP is free — one-click install via Unyly at no cost.
Does Airtable need an API key?
No, Airtable runs without API keys or environment variables.
Is Airtable hosted or self-hosted?
Self-hosted: the server runs locally on your machine via the install command above.
How do I install Airtable in Claude Desktop, Claude Code or Cursor?
Open Airtable on unyly.org, pick your client tab (Claude Desktop, Claude Code, Cursor) and press Install — the config is generated automatically, no JSON editing.
Related MCPs
Fetch
Web content fetching and conversion for efficient LLM usage.
AWS KB Retrieval
Retrieval from AWS Knowledge Base using Bedrock Agent Runtime.
by modelcontextprotocolSpring AI MCP Server
Provides auto-configuration for setting up an MCP server in Spring Boot applications.
llm-analysis-assistant
A very streamlined mcp client that supports calling and monitoring stdio/sse/streamableHttp, and can also view request responses through the /logs page. It also
by xuzexin-hzMCP-Agent
A simple, composable framework to build agents using Model Context Protocol by [LastMile AI](https://www.lastmileai.dev)
by lastmile-aiSpring AI MCP Client
Provides auto-configuration for MCP client functionality in Spring Boot applications.
mcp.natoma.ai
A Hosted MCP Platform to discover, install, manage and deploy MCP servers by [Natoma Labs](https://www.natoma.ai)
MCPHub
Website to list high quality MCP servers and reviews by real users. Also provide online chatbot for popular LLM models with MCP server support.
MCP Servers Rating and User Reviews
Website to rate MCP servers, write authentic user reviews, and [search engine for agent & mcp](http://www.deepnlp.org/search/agent)
mkinf
An Open Source registry of hosted MCP Servers to accelerate AI agent workflows.
Compare Airtable with
Not sure what to pick?
Find your stack in 60 seconds
Author?
Embed badge for your README
Browse similar
All ai MCPs