Airtable MCP Server

What it does

This server provides a robust bridge between LLMs and Airtable, allowing AI agents to treat an Airtable base as a dynamic database. It enables the AI to inspect schemas, query records with formulas, and perform full CRUD operations on data and table structures.

Tools

• list_records: Retrieve records from a table with optional formula filtering.
• search_records: Perform text-based searches across table fields.
• list_bases & list_tables: Discover available bases and their internal structures.
• create_record & update_records: Write or modify data within a base.
• create_table & create_field: Dynamically modify the database schema.
• create_comment & list_comments: Manage record-level discussions.

Installation

Add the following to your claude_desktop_config.json:

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

Supported hosts

• Claude Desktop
• Cursor