Airtable MCP Server

An MCP server implementation that provides read and write access to Airtable databases, enabling Claude to interact with your Airtable bases.

Installation

npm install @microagents/server-airtable
# or
yarn add @microagents/server-airtable

Usage

Direct Execution

# Set your API token and run
AIRTABLE_API_KEY=pat123.abc123 npx @microagents/server-airtable

With Claude Desktop

Add this to your claude_desktop_config.json:

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["@microagents/server-airtable"],
      "env": {
        "AIRTABLE_API_KEY": "pat123.abc123"
      }
    }
  }
}

Setup

Airtable Personal Access Token

To use this server, you'll need an Airtable Personal Access Token:

1. Go to your Airtable account page
2. Navigate to the "API" section
3. Create a Personal Access Token with the following permissions:
   • schema.bases:read - Required to read base and table schemas
   • data.records:read - Required to read records
   • data.records:write - Required to create or update records (optional)
4. Copy the generated token (it starts with "pat")

Features

• Schema Exploration: Inspect Airtable base and table schemas
• Record Management: Read, create, and update records in Airtable tables
• View Integration: Access data through different Airtable views

Tools

Schema Operations

• list_bases: List all accessible Airtable bases
• get_base_schema: Get schema information for a specific base
• get_table_schema: Get schema information for a specific table

Record Operations

• list_records: List records from a table, with optional filtering
• get_record: Get a specific record by ID
• create_record: Create a new record in a table
• update_record: Update an existing record
• delete_record: Delete a record from a table

License

MIT

Credits

Based on the original MCP server by Adam Jones (domdomegg): domdomegg/airtable-mcp-server