agents-libagents-lib
AgentsMCP ServersWorkflowsTutorialsComparisonsTemplatesNewsAbout
🔌

Airtable MCP

Database•⭐ 1,100

Create, read, update, and delete Airtable records for database and spreadsheet management.

GitHubWebsite →
Claude DesktopCursorWindsurf

Overview

Create, read, update, and delete Airtable records for database and spreadsheet management.

Setup

Run with npx:

npx -y @modelcontextprotocol/server-airtable

Configuration

AIRTABLE_API_KEY environment variable

Documentation

Airtable MCP (Enhanced)

Overview

Airtable MCP provides access to Airtable API for database and spreadsheet management.

Features

  • Table CRUD operations
  • Record management
  • View management
  • Attachment handling
  • Formula support

Installation

npx -y @modelcontextprotocol/server-airtable

Configuration

Set up Airtable API key:

export AIRTABLE_API_KEY=your_api_key

Get your API key from Airtable Personal Access Tokens.

Available Operations

OperationDescription
List RecordsGet table records
Create RecordAdd new record
Update RecordModify record fields
Delete RecordRemove record
Search RecordsFind by criteria

Usage Examples

List Records

{
  "action": "list_records",
  "base_id": "app123",
  "table_name": "Projects",
  "max_records": 100
}

Create Record

{
  "action": "create_record",
  "base_id": "app123",
  "table_name": "Tasks",
  "fields": {
    "Name": "Implement feature",
    "Status": "In Progress",
    "Assignee": "Alice"
  }
}

Update Record

{
  "action": "update_record",
  "base_id": "app123",
  "table_name": "Tasks",
  "record_id": "rec123",
  "fields": {
    "Status": "Done"
  }
}

Pros

  • ✅ Flexible database structure
  • ✅ Rich field types
  • ✅ Easy collaboration
  • ✅ API-first design

Cons

  • ❌ Requires Airtable account
  • ❌ API rate limits
  • ❌ Cost for large bases

Resources