rashidazarang/airtable-mcp
Free将 AI 工具直接连接到 Airtable。使用自然语言查询、创建、更新和删除记录。功能包括库管理、表操作等。
FreeFree tier
About rashidazarang/airtable-mcp
A Model Context Protocol (MCP) server for Airtable providing full CRUD operations, schema management, record comments, webhooks, batch operations, governance controls, and AI-powered analytics. It includes 42 tools covering every Airtable PAT scope and 10 AI prompt templates for intelligent analytics.
Key Features
Full CRUD operations with filtering and pagination
Record comments (list, create, update, delete)
Schema management (tables, fields, views)
Batch operations up to 10 records
Webhook management for real-time notifications
Governance compliance with allow-list and PII masking
User identity verification via whoami tool
AI analytics with 10 prompt templates
Easy setup via npx for Claude Desktop and Claude Code
Open source and free
Pros & Cons
Pros
- Comprehensive CRUD and schema operations covering all major Airtable features
- Supports advanced capabilities like webhooks, batch ops, and governance
- AI analytics with pre-built prompt templates for insights
- Easy installation via npx with no manual setup required for Claude Desktop
- Open source with active development (version 4.0.0)
- Includes 42 tools covering every Airtable PAT scope
Cons
- Requires an Airtable account and API token to use
- Batch operations limited to 10 records per operation
- Dependent on npx and Node.js runtime
- No built-in GUI; operates through MCP-compatible clients only
Best For
Natural language querying of Airtable data through AI assistantsAutomating Airtable record management (create, update, delete)Programmatic schema changes to tables and fieldsReal-time data change notifications via webhooksAI-powered predictive analytics on Airtable dataGovernance and compliance for sensitive data in Airtable
FAQ
How do I install the Airtable MCP server?
For Claude Desktop, add the configuration to claude_desktop_config.json with npx command and environment variables (AIRTABLE_TOKEN and AIRTABLE_BASE_ID). For Claude Code, run the setup script or manually configure ~/.claude.json.
What are the prerequisites?
You need an Airtable account, an API token with appropriate scopes, and the Base ID of your Airtable base. Node.js is required if not using npx.
Does it support batch operations?
Yes, the server supports batch operations processing up to 10 records per operation for improved performance.
Is the server open source?
Yes, it is open source and free to use under the license on GitHub.