Airtable

A comprehensive Model Context Protocol (MCP) server that provides full access to the Airtable Web API, including enterprise features. This server enables AI assistants to create, manage, and interact with Airtable bases, tables, fields, records, views, and webhooks.

- List Bases: Get all accessible bases in a workspace
- Get Base Schema: Retrieve complete base structure with tables and fields
- Delete Base: Remove bases (Enterprise only)

- List Tables: Get all tables in a base
- Create Table: Create new tables with comprehensive field configurations
- Update Table: Modify table properties and metadata
- Delete Table: Remove tables (with proper permissions)

- List Fields: Get all fields in a table
- Create Field: Add new fields with 25+ field types supported
- Update Field: Modify existing field properties and options
- Delete Field: Remove fields (with data considerations)

- Basic Fields:singleLineText,multilineText,email,phoneNumber,richText,url
- Numeric Fields:number,currency,percent
- Date/Time Fields:date,dateTime,duration
- Selection Fields:singleSelect,multipleSelects
- Interactive Fields:rating,checkbox
- Advanced Fields:formula,rollup,lookup,multipleRecordLinks
- Specialized Fields:attachment,barcode,button,count,autoNumber

- List Records: Basic record retrieval
- Advanced List Records: Full filtering, sorting, pagination, and field selection
- Get Record: Fetch individual record details
- Create Record: Add single records
- Update Record: Modify existing records
- Delete Record: Remove records
- Batch Create Records: Create multiple records efficiently
- Batch Update Records: Update multiple records in one request
- Batch Delete Records: Delete multiple records efficiently
- Search Records: Find records using field-based search

- List Views: Get all views in a table
- Get View: Retrieve view configuration
- Create View: Create new views (grid, form, calendar, gallery, kanban, timeline, gantt)
- Update View: Modify view properties, filters, and sorting
- Delete View: Remove views

- List Webhooks: Get all webhooks for a base
- Create Webhook: Set up real-time notifications
- Update Webhook: Modify webhook configuration
- Delete Webhook: Remove webhook subscriptions
- Get Webhook Payloads: Retrieve webhook notification history

🏢Enterprise Features(Enterprise Scale Plans)

- User Management: Create, update, and deactivate users
- Workspace Management: Manage workspace access and permissions
- Audit Logs: Create and retrieve comprehensive audit logs
- Share Link Management: Control base sharing across organization
- Collaborator Management: Add/remove users from bases and workspaces
- Bulk Operations: Perform enterprise-scale batch operations

npm install @loticdigital/airtable-mcp-server

Set your Airtable API key as an environment variable:

export AIRTABLE_API_KEY=your_airtable_api_key_here

Add to your Claude Desktop configuration:

{ "mcpServers": { "airtable": { "command": "npx", "args": ["@loticdigital/airtable-mcp-server"], "env": { "AIRTABLE_API_KEY": "your_airtable_api_key_here" } } } }

npx @modelcontextprotocol/inspector npx @loticdigital/airtable-mcp-server

- Rate Limit: 5 requests per second per base
- API Call Limits:

- Free: 1,000 calls per workspace per month
- Team: 100,000 calls per workspace per month
- Business/Enterprise: Unlimited calls

- External ID Mapping: Support for upsert operations
- Data Validation: Comprehensive field validation
- Conflict Resolution: Handle concurrent updates gracefully
- Change Tracking: Monitor and log all data modifications
- Performance Optimization: Caching and selective field requests

- Token Management: Secure PAT handling
- Data Protection: Input validation and sanitization
- Enterprise Security: Audit logging and compliance support
- Access Controls: Proper permission handling

{ "name": "Title", "type": "singleLineText", "description": "Main title field" }

{ "name": "Price", "type": "currency", "options": { "precision": 2, "symbol": "$" } }

{ "name": "Status", "type": "singleSelect", "options": { "choices": [ { "name": "Active", "color": "greenBright" }, { "name": "Pending", "color": "yellowBright" }, { "name": "Inactive", "color": "redBright" } ] } }

{ "name": "Full Name", "type": "formula", "options": { "formula": "CONCATENATE({First Name}, ' ', {Last Name})" } }

{ "notificationUrl": "https://your-server.com/webhook", "specification": { "options": { "filters": { "dataTypes": ["tableData"], "recordChangeScope": "tblXXXXXXXXXXXXXX" } } } }

The server implements comprehensive error handling:

- 401 Unauthorized: Invalid or expired token
- 403 Forbidden: Insufficient permissions
- 404 Not Found: Resource doesn't exist
- 422 Unprocessable Entity: Invalid field configuration
- 429 Too Many Requests: Rate limit exceeded
- 500 Internal Server Error: Airtable service issue

# Clone the repository git clone https://github.com/loticdigital/airtable-mcp # Install dependencies npm install # Build the project npm run build # Run with inspector npm run inspector

Contributions are welcome! Please feel free to submit a Pull Request.

MIT License - see LICENSE file for details.

- GitHub Issues:https://github.com/loticdigital/airtable-mcp/issues
- Documentation:Airtable Web API

An MCP server for accessing and managing data on the kintone low-code platform.