airtable-mcp

Overview

This MCP server provides deep integration with Airtable through 42 tools covering all aspects of the platform, including basic record operations, schema management, batch operations, webhook management, and AI-powered analytics. The server supports both Claude Desktop and Claude Code with straightforward setup processes, requiring only an Airtable personal access token for authentication. It features TypeScript implementation, recent active maintenance, and comprehensive documentation with clear examples.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• list_bases

  List all accessible Airtable bases with permissions

  Try:List all my accessible Airtable basesTry:Show me my bases
• query

  Query records with filtering, sorting, and pagination

  Try:Show me all records in the Projects tableTry:Find all active tasks
• create

  Create new records (requires dryRun diff review)

  Try:Create a new task with priority 'High'Try:Add a new customer record
• update

  Update existing records (requires dryRun diff review)

  Try:Update the status of task ID rec123 to 'Completed'Try:Change the due date
• list_tables

  Get all tables in a base with schema info

  Try:Show me all tables in this baseTry:List available tables
• create_table

  Create tables with custom field definitions

  Try:Create a new table called 'Tasks'Try:Add a Projects table
• create_field

  Add fields to existing tables

  Try:Add a Status field to the Projects tableTry:Create a new Priority field
• batch_create_records

  Create up to 10 records at once

  Try:Create 5 new tasks at onceTry:Batch add multiple records
• list_webhooks

  View all configured webhooks

  Try:List all active webhooksTry:Show my webhook configurations
• create_webhook

  Set up real-time notifications for data changes

  Try:Create a webhook for changes to my Projects tableTry:Set up notifications
• list_comments

  List comments on a record

  Try:Show me all comments on record rec123Try:What comments are on this record?
• create_comment

  Add a comment to a record

  Try:Add a comment to this record: 'Reviewed and approved'Try:Leave a note

Comparable tools

Installation

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["-y", "@rashidazarang/airtable-mcp"],
      "env": {
        "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN",
        "AIRTABLE_BASE_ID": "YOUR_BASE_ID"
      }
    }
  }
}

curl -fsSL https://raw.githubusercontent.com/rashidazarang/airtable-mcp/main/setup.sh | bash

{
  "airtable": {
    "type": "stdio",
    "command": "/bin/bash",
    "args": ["-c", "cd /tmp && npx -y @rashidazarang/airtable-mcp"],
    "env": {
      "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN"
    }
  }
}

FAQ

What permissions are required for the Airtable token?

The token needs scopes for data.records:read, data.records:write, data.recordComments:read, data.recordComments:write, schema.bases:read, schema.bases:write, user.email:read, and optionally webhook:manage if you want to use webhook functionality.

Can I use this server with multiple Airtable bases?

Yes, the server supports multi-base discovery. You can either specify a base ID in the configuration or use the 'list_bases' tool to dynamically discover and work with multiple bases.

On Hacker News

Recent discussion from the developer community.

• Show HN: Airtable MCP – Connect Airtable with Al tools using natural language▲ 1
  Story by rashidae · 2025-03-15
• Show HN: Airtable MCP – Connect Airtable with AI tools using natural language▲ 1
  Story by rashidae · 2025-03-15
• Show HN: I built a MCP server so Claude can interact with Airtable▲ 2
  Story by rashidae · 2025-03-21

Compare airtable-mcp with