Airtable API MCP MCP Server

About

## Airtable API MCP Server: Connected Spreadsheets The **Airtable API MCP Server** integrates Airtable's low-code database platform into Google Antigravity, enabling developers to build, query, and automate connected spreadsheet applications through AI-assisted workflows. ### Why Airtable API MCP? - **Relational Data**: Link records across tables for connected, relational data structures - **Rich Field Types**: Support for attachments, lookups, rollups, formulas, and more - **Automations**: Trigger workflows based on record changes and conditions - **Views & Filters**: Create filtered, sorted, and grouped views of your data - **Real-Time Sync**: Changes sync instantly across all connected applications ### Key Features #### 1. Record Management ```javascript // Create records with linked data const record = await airtable.createRecord({ baseId: "appXXXXXX", table: "Projects", fields: { "Name": "Website Redesign", "Status": "In Progress", "Due Date": "2024-12-31", "Assigned To": ["recUSER123"], "Budget": 50000 } }); // Query with filters const activeProjects = await airtable.listRecords({ baseId: "appXXXXXX", table: "Projects", filterByFormula: "AND({Status} = 'In Progress', {Budget} > 10000)", sort: [{ field: "Due Date", direction: "asc" }] }); ``` #### 2. Schema and Automation ```javascript // Get table schema const schema = await airtable.getTableSchema({ baseId: "appXXXXXX", table: "Projects" }); // Bulk update records await airtable.updateRecords({ baseId: "appXXXXXX", table: "Projects", records: [ { id: "recXXX", fields: { "Status": "Completed" } }, { id: "recYYY", fields: { "Status": "Completed" } } ] }); ``` ### Configuration ```json { "mcpServers": { "airtable-api": { "command": "npx", "args": ["-y", "@anthropic/mcp-airtable"], "env": { "AIRTABLE_API_KEY": "your-api-key", "AIRTABLE_BASE_ID": "your-default-base" } } } } ``` ### Use Cases **Project Management**: Build custom project trackers with linked tasks, team members, and resources. **CRM Systems**: Create customer databases with interaction history and sales pipelines. **Content Calendars**: Manage editorial workflows with scheduled content and approval processes. The Airtable API MCP Server brings flexible, relational database capabilities to your development workflow.

Installation

{
  "mcpServers": {
    "airtable-api": {}
  }
}

How to Use