Airtable MCP Server
Provides comprehensive access to the Airtable Web API for managing bases, tables, fields (25+ types), records, views, and webhooks. Supports batch operations, advanced filtering, sorting, pagination, and enterprise features including user management, workspace management, and audit logs.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Airtable MCP Server list all tasks with status 'pending' from the 'Projects' table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Airtable MCP Server
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.
Features
ποΈ Base Management
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)
π Table Management
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)
π§ Field Management
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)
Supported Field Types
Basic Fields:
singleLineText,multilineText,email,phoneNumber,richText,urlNumeric Fields:
number,currency,percentDate/Time Fields:
date,dateTime,durationSelection Fields:
singleSelect,multipleSelectsInteractive Fields:
rating,checkboxAdvanced Fields:
formula,rollup,lookup,multipleRecordLinksSpecialized Fields:
attachment,barcode,button,count,autoNumber
π Record Operations
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
ποΈ View Management
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
π Webhook Management
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
Related MCP server: Airtable MCP Server
Installation
npm install @loticdigital/airtable-mcp-serverConfiguration
Set your Airtable API key as an environment variable:
export AIRTABLE_API_KEY=your_airtable_api_key_hereUsage
With Claude Desktop
Add to your Claude Desktop configuration:
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["@loticdigital/airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "your_airtable_api_key_here"
}
}
}
}With MCP Inspector
npx @modelcontextprotocol/inspector npx @loticdigital/airtable-mcp-serverAPI Capabilities
Rate Limits & Best Practices
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
Pagination: Automatic handling of paginated responses
Batch Operations: Efficient bulk processing for multiple records
Error Handling: Comprehensive error recovery with exponential backoff
Advanced Features
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
Security Features
Token Management: Secure PAT handling
Data Protection: Input validation and sanitization
Enterprise Security: Audit logging and compliance support
Access Controls: Proper permission handling
Field Configuration Examples
Basic Fields
{
"name": "Title",
"type": "singleLineText",
"description": "Main title field"
}Numeric Fields
{
"name": "Price",
"type": "currency",
"options": {
"precision": 2,
"symbol": "$"
}
}Selection Fields
{
"name": "Status",
"type": "singleSelect",
"options": {
"choices": [
{ "name": "Active", "color": "greenBright" },
{ "name": "Pending", "color": "yellowBright" },
{ "name": "Inactive", "color": "redBright" }
]
}
}Advanced Fields
{
"name": "Full Name",
"type": "formula",
"options": {
"formula": "CONCATENATE({First Name}, ' ', {Last Name})"
}
}Webhook Configuration
{
"notificationUrl": "https://your-server.com/webhook",
"specification": {
"options": {
"filters": {
"dataTypes": ["tableData"],
"recordChangeScope": "tblXXXXXXXXXXXXXX"
}
}
}
}Error Handling
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
Development
# 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 inspectorContributing
Contributions are welcome! Please feel free to submit a Pull Request.
License
MIT License - see LICENSE file for details.
Support
For issues and questions:
GitHub Issues: https://github.com/loticdigital/airtable-mcp/issues
Documentation: Airtable Web API
Changelog
v0.6.0 (Latest)
β¨ Major Feature Expansion: Added comprehensive Airtable Web API support
π§ 25+ Field Types: Support for all Airtable field types including advanced fields
ποΈ View Management: Complete view CRUD operations
π Webhook Support: Real-time notifications and webhook management
π Advanced Record Operations: Batch operations, advanced filtering, pagination
π’ Enterprise Features: User management, audit logs, workspace management
π‘οΈ Enhanced Security: Comprehensive validation and error handling
β‘ Performance: Optimized batch operations and caching strategies
v0.5.1
Basic table and field management
Simple record CRUD operations
Limited field type support
Available Tools
32 toolsadvanced_list_recordsB
List records with advanced filtering, sorting, and pagination
Inputs: base_id (required), table_name (required), filter_by_formula, sort, +8 more.
batch_create_recordsC
Create multiple records in a single request
Inputs: base_id (required), table_name (required), records (required), typecast.
batch_delete_recordsB
Delete multiple records in a single request
Inputs: base_id (required), table_name (required), record_ids (required).
batch_update_recordsB
Update multiple records in a single request
Inputs: base_id (required), table_name (required), records (required), typecast.
create_fieldB
Create a new field in a table
Inputs: base_id (required), table_id (required), field (required).
create_recordB
Create a new record in a table
Inputs: base_id (required), table_name (required), fields (required).
create_tableC
Create a new table in a base
Inputs: base_id (required), table_name (required), description, fields.
create_viewC
Create a new view in a table
Inputs: base_id (required), table_id (required), view (required).
create_webhookC
Create a new webhook for real-time notifications
Inputs: base_id (required), notification_url (required), specification (required).
delete_baseB
Delete a base (Enterprise only)
Inputs: base_id (required).
delete_fieldA
Delete a field from a table
Inputs: base_id (required), table_id (required), field_id (required).
delete_recordC
Delete a record from a table
Inputs: base_id (required), table_name (required), record_id (required).
delete_viewB
Delete a view from a table
Inputs: base_id (required), table_id (required), view_id (required).
delete_webhookB
Delete a webhook
Inputs: base_id (required), webhook_id (required).
get_base_schemaA
Get complete base schema including all tables and fields. For large schemas, returns a cache ID to fetch data in chunks.
Inputs: base_id, cache_id, chunk_offset, table_ids, +1 more.
get_base_summaryA
Get a lightweight summary of all tables in a base (names, IDs, and field counts only)
Inputs: base_id (required).
get_recordB
Get a single record by its ID
Inputs: base_id (required), table_name (required), record_id (required).
get_viewC
Get view configuration
Inputs: base_id (required), table_id (required), view_id (required).
get_webhook_payloadsC
Get webhook notification history
Inputs: base_id (required), webhook_id (required), cursor, limit.
list_basesA
List all accessible Airtable bases
Inputs: no named parameters.
list_cached_schemasA
List all cached schemas with their cache IDs and metadata
Inputs: no named parameters.
list_fieldsB
List all fields in a table
Inputs: base_id (required), table_id (required).
list_recordsC
List records in a table
Inputs: base_id (required), table_name (required), max_records.
list_tablesB
List all tables in a base
Inputs: base_id (required).
list_viewsB
List all views in a table
Inputs: base_id (required), table_id (required).
list_webhooksB
List all webhooks for a base
Inputs: base_id (required).
search_recordsB
Search for records in a table
Inputs: base_id (required), table_name (required), field_name (required), value (required).
update_fieldC
Update a field in a table
Inputs: base_id (required), table_id (required), field_id (required), updates (required).
update_recordB
Update an existing record in a table
Inputs: base_id (required), table_name (required), record_id (required), fields (required).
update_tableC
Update a table's schema
Inputs: base_id (required), table_id (required), name, description.
update_viewC
Update an existing view
Inputs: base_id (required), table_id (required), view_id (required), updates (required).
update_webhookB
Update an existing webhook
Inputs: base_id (required), webhook_id (required), updates (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
TDQS
Scored across 32 tools
Each tool targets a distinct resource and action (e.g., record, field, table, view, webhook) with clear purposes. Even similar operations like list_records, search_records, and advanced_list_records are well-differentiated through descriptions.
All tool names follow a consistent verb_noun pattern in snake_case (e.g., create_record, list_tables, delete_view), with no mixing of conventions.
32 tools is on the higher side but justified by the broad coverage of Airtable's API (bases, tables, fields, records, views, webhooks) with CRUD and batch operations. The count is slightly excessive but still reasonable for the domain.
The tool surface covers most major operations including CRUD for records, tables, fields, views, and webhooks. Notable gaps include missing update_base, delete_table, and get_field, but core workflows are well covered.
Related MCP Connectors
Query and update Teable records, manage tables, and access the Teable API with AI agents.
Unofficial Airtable MCP Pack β wraps the Airtable REST API v0
Hosted Airtable MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Teable is an AI spreadsheet for business that combines a familiar spreadsheet interface with a structured database. Its remote MCP server lets AI agents inspect project and table structure, read and update records, and access the Teable API through OAuth with existing project permissions. Website: [teable.ai](https://teable.ai)
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceProvides tools for AI assistants to interact with Airtable databases, enabling CRUD operations on Airtable bases and tables.7 npmMIT
- AlicenseNot gradedqualityCmaintenanceProvides read and write access to Airtable databases, enabling LLMs to inspect schemas, search, create, update, and delete records, tables, and fields, as well as manage comments on records.3,343 npmMIT
- AlicenseNot gradedqualityDmaintenanceEnables comprehensive interaction with Airtable bases including record management with automatic type conversion for all field types. It supports batch operations, schema discovery, and secure authentication using Personal Access Tokens.18 npmMIT
- AlicenseNot gradedqualityNot gradedmaintenanceEnables comprehensive interaction with the Airtable Web API to manage bases, tables, and records. It supports advanced features like batch record operations, CSV import/export, attachment uploads, and webhook management.-