Airtable MCP Server

About

## Airtable MCP Server: Flexible Database Platform The **Airtable MCP Server** integrates Airtable into Google Antigravity, enabling spreadsheet-database hybrid operations with custom views, automations, and API access directly from your development environment. ### Why Airtable MCP? - **Spreadsheet + Database**: Best of both worlds - **Visual Interface**: Drag-and-drop interface building - **Automations**: Trigger-based workflows - **Apps**: Build custom interfaces - **API-First**: Comprehensive REST API ### Key Features #### 1. Record Operations ```python # List records records = await mcp.list_records( base_id="appXXXXXX", table_name="Projects", view="Active Projects", filter_by_formula="{Status} = 'In Progress'", sort=[{"field": "Due Date", "direction": "asc"}], max_records=100 ) for record in records["records"]: print(f"Project: {record['fields']['Name']}") # Get single record record = await mcp.get_record( base_id="appXXXXXX", table_name="Projects", record_id="recXXXXXX" ) ``` #### 2. Record Management ```python # Create record record = await mcp.create_record( base_id="appXXXXXX", table_name="Projects", fields={ "Name": "New Project", "Status": "Planning", "Owner": ["recUSER123"], # Linked record "Due Date": "2024-03-15", "Priority": "High" } ) # Update record await mcp.update_record( base_id="appXXXXXX", table_name="Projects", record_id=record["id"], fields={"Status": "In Progress"} ) # Delete record await mcp.delete_record( base_id="appXXXXXX", table_name="Projects", record_id="recXXXXXX" ) ``` #### 3. Batch Operations ```python # Batch create records = await mcp.batch_create( base_id="appXXXXXX", table_name="Tasks", records=[ {"fields": {"Name": "Task 1", "Project": ["recPROJ1"]}}, {"fields": {"Name": "Task 2", "Project": ["recPROJ1"]}}, {"fields": {"Name": "Task 3", "Project": ["recPROJ1"]}} ] ) # Batch update await mcp.batch_update( base_id="appXXXXXX", table_name="Tasks", records=[ {"id": "rec1", "fields": {"Status": "Done"}}, {"id": "rec2", "fields": {"Status": "Done"}} ] ) ``` #### 4. Schema Operations ```python # Get base schema schema = await mcp.get_base_schema(base_id="appXXXXXX") for table in schema["tables"]: print(f"Table: {table['name']}") for field in table["fields"]: print(f" - {field['name']}: {field['type']}") ``` ### Configuration ```json { "mcpServers": { "airtable": { "command": "npx", "args": ["-y", "@anthropic/mcp-airtable"], "env": { "AIRTABLE_API_KEY": "your-api-key" } } } } ``` ### Use Cases **Project Management**: Track projects and tasks with custom views. **CRM Alternative**: Simple CRM for small teams. **Content Calendar**: Manage content publishing schedules. **Inventory Tracking**: Track inventory and assets. The Airtable MCP enables flexible database operations within your development environment.

Installation

{
  "mcpServers": {
    "airtable": {
      "mcpServers": {
        "airtable": {
          "env": {
            "AIRTABLE_API_KEY": "your-api-key"
          },
          "args": [
            "-y",
            "@airtable/mcp-server"
          ],
          "command": "npx"
        }
      }
    }
  }
}

How to Use

1. 11. Get Personal Access Token from Airtable account settings
2. 22. Replace YOUR_AIRTABLE_PAT with your token (format: patXXX.XXX)
3. 33. Provides read/write access to bases