airtable-mcp-server

Overview

The airtable-mcp-server provides a robust implementation of the Model Context Protocol specifically for Airtable integration. It exposes comprehensive tools for database schema inspection, record manipulation, and table management. The server supports both read and write operations, making it suitable for various automation and AI-powered workflows that need to interact with Airtable data.

Try asking AI

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

• list_records

  Lists records from a specified Airtable table

  Try:List all records from the customers tableTry:Get 50 records from the orders table with a specific filter
• search_records

  Search for records containing specific text

  Try:Search for all records containing ' urgent ' in the tasks tableTry:Find customers with email containing 'gmail.com'
• list_bases

  Lists all accessible Airtable bases

  Try:Show me all my Airtable basesTry:List all bases I have access to
• list_tables

  Lists all tables in a specific base

  Try:Show me all tables in my project baseTry:List tables with full details
• describe_table

  Gets detailed information about a specific table

  Try:Describe the structure of the products tableTry:Get full details about the customers table
• get_record

  Gets a specific record by ID

  Try:Retrieve record rec123xyz from the tasks tableTry:Get the details of order ID 45678
• create_record

  Creates a new record in a table

  Try:Create a new customer record with email john@example.comTry:Add a task with priority high due tomorrow
• update_records

  Updates one or more records in a table

  Try:Update record rec123 to set status to completedTry:Change the price for multiple products
• delete_records

  Deletes one or more records from a table

  Try:Delete records rec123 and rec456Try:Remove archived tasks
• create_table

  Creates a new table in a base

  Try:Create a new table called 'Projects' with fields for name and statusTry:Add a table for tracking inventory
• create_field

  Creates a new field in a table

  Try:Add a new 'priority' field to the tasks tableTry:Create a date field for due dates
• create_comment

  Creates a comment on a record

  Try:Add a comment on task rec123: 'Please review this'Try:Reply to a comment on the customer record

Comparable tools

Installation

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "pat123.abc123",
      }
    }
  }
}

FAQ

What permissions do I need to configure in Airtable?

You need at minimum `schema.bases:read` and `data.records:read` scopes. For write operations, also add `schema.bases:write` and `data.records:write` scopes.

Can I use this with MCP clients other than Claude Desktop?

Yes, the server supports multiple clients including Cursor and Cline, with configuration instructions provided for each in the README.

Compare airtable-mcp-server with