Airtable Integration

The Airtable MCP server allows you to interact directly with your Airtable databases. Create, read, update, and delete data in your Airtable workspace.

Setup

Prerequisites

1. An Airtable account
2. An Airtable Personal Access Token or API Key
   • Create a token at: https://airtable.com/create/tokens
   • Required permissions:
     • data.records:read - for reading records
     • data.records:write - for creating/updating records
     • schema.bases:read - for reading database structure
     • schema.bases:write - for creating/modifying tables

Configuration

The server requires your Airtable API Key as a header:

• Header Name: X-Airtable-API-Key
• Header Value: Your Personal Access Token

Main Functions

Database Operations

• list_bases: Lists all accessible Airtable databases
• list_tables: Shows all tables in a database with optional detail level
• describe_table: Returns detailed information about a specific table

Record Operations

• list_records: Lists records from a table with filter options
  • Supports filter formulas, sorting, and views
  • Pagination for large data sets
• search_records: Searches text fields for specific terms
• get_record: Retrieves a specific record by ID
• create_record: Creates a new record
• update_records: Updates up to 10 records simultaneously
• delete_records: Deletes up to 10 records simultaneously

Schema Operations

• create_table: Creates a new table with defined fields
• update_table: Changes name or description of a table
• create_field: Adds a new field to a table
• update_field: Changes name or description of a field

Usage Examples

Search and Filter Records

"Find all customers in Berlin"
"Show me tasks with status 'Open' sorted by priority"
"Search for products with 'Premium' in the name"

Manage Data

"Create a new customer entry with name and email"
"Update the status of task ID xyz to 'Done'"
"Delete all entries with status 'Archived'"

Adjust Table Structure

"Create a new table 'Projects' with fields for name, status, and deadline"
"Add a number field 'Budget' to the project table"

Filter Formulas

Airtable supports complex filter formulas:

• {Status} = "Active" - Exact match
• AND({Price} > 100, {Category} = "Premium") - Multiple conditions
• OR(FIND("important", {Notes}), {Priority} = "High") - OR connection
• NOT({Archived}) - Negation

Advantages

• Real-time Data: Direct access to current data
• No Synchronization Needed: Changes are immediately visible
• Full API Functionality: All Airtable features available
• Batch Operations: Efficient processing of multiple records

Limitations

• Maximum 10 records per update/delete operation
• API rate limits: 5 requests per second
• Filter formulas must follow Airtable syntax
• Search function only available for text fields