Airtable Integration MCP Server

Overview

The Airtable Integration MCP allows AI tools to interact with Airtable databases through a standardized interface. This integration enables seamless data access and management directly from AI applications, making it possible to query, manipulate, and analyze Airtable data using natural language.

Installation

Prerequisites

• Node.js (for JavaScript implementation)
• Python 3.8+ (for Python implementation)
• Airtable API token
• Airtable base ID

Installation Steps

1. Clone the repository

   git clone https://github.com/rashidazarang/airtable-mcp.git
   cd airtable-mcp
   

2. Install dependencies

   For JavaScript implementation:

   npm install
   

   For Python implementation:

   pip install -r requirements.txt
   

3. Get your Airtable credentials

   • Obtain your Airtable API token from your account page
   • Find your base ID from your Airtable base URL (format: appi7fWMQcB3BNzPs)

Configuration

Claude Desktop Configuration

To configure Claude Desktop to use the Airtable MCP:

1. Open the Claude Desktop configuration file:

   ~/Library/Application Support/Claude/claude_desktop_config.json
   

2. Add the Airtable MCP configuration:

   {
     "mcpServers": {
       "airtable": {
         "command": "node",
         "args": [
           "/path/to/airtable-mcp/airtable_simple.js",
           "--api-key",
           "YOUR_AIRTABLE_API_KEY",
           "--base-id",
           "YOUR_BASE_ID"
         ]
       }
     }
   }
   

3. Replace /path/to/airtable-mcp with the actual path to the cloned repository, and add your Airtable API key and base ID.

Alternative URL-based Configuration

You can also configure the MCP using a URL parameter:

{
  "mcpServers": {
    "airtable": {
      "url": "http://localhost:3333?apiKey=YOUR_AIRTABLE_API_KEY&baseId=YOUR_BASE_ID"
    }
  }
}

Python Implementation

For the Python implementation, you can run the server directly:

python simple_airtable_server.py --api-key YOUR_AIRTABLE_API_KEY --base-id YOUR_BASE_ID

Usage

Once configured, you can interact with your Airtable bases through Claude. Here are some example queries:

• "Show me all tables in my Airtable base"
• "List the first 5 records from the Projects table"
• "Create a new record in the Tasks table with title 'Review proposal' and status 'Pending'"
• "Update the status to 'Completed' for task ID rec123456"
• "Show me the schema of the Contacts table"
• "Find all projects with status 'In Progress'"

The MCP handles translating these natural language requests into appropriate Airtable API calls and returns the results in a structured format.

Advanced Configuration

Docker Deployment

The repository includes a Dockerfile for containerized deployment:

docker build -t airtable-mcp .
docker run -p 3333:3333 -e AIRTABLE_API_KEY=your_api_key -e AIRTABLE_BASE_ID=your_base_id airtable-mcp

Smithery Configuration

For Smithery users, the repository includes a smithery.yaml file that can be used to configure the MCP:

smithery deploy @rashidazarang/airtable-mcp

Troubleshooting

If you encounter issues:

1. Verify your Airtable API key and base ID are correct
2. Check that the server is running (default port is 3333)
3. Examine server logs for error messages
4. Ensure you have the necessary permissions for the Airtable base you're trying to access

For more detailed troubleshooting, refer to the repository's issue templates or create a new issue on GitHub.