Airtable MCP

Airtable MCP

Airtable MCP is an integration that connects AI tools directly to Airtable databases using Anthropic's Model Context Protocol (MCP). This allows AI systems like Claude to interact with your Airtable bases through natural language.

Features

• Query, create, update, and delete Airtable records
• Manage bases and tables
• Manipulate database schemas
• Filter records with complex queries
• Migrate data between tables
• Compatible with Claude Desktop and other Claude-powered editors

Installation

Prerequisites

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

Installation Options

Option 1: Quick Setup with npm

npm install -g airtable-mcp

Option 2: Clone the Repository

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

Option 3: Python Installation

pip install -r requirements.txt

Configuration

Getting Your Airtable Credentials

1. Get your Airtable API token from your account page
2. Find your base ID in your Airtable base URL (format: appi7fWMQcB3BNzPs)

Configuring Claude Desktop

1. Open the Claude Desktop configuration file:

   • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
   • Windows: %APPDATA%\Claude\claude_desktop_config.json

2. Add the following configuration:

{
  "mcp_servers": [
    {
      "url": "http://localhost:8000?api_key=YOUR_AIRTABLE_API_KEY&base_id=YOUR_BASE_ID",
      "name": "Airtable"
    }
  ]
}

3. Replace YOUR_AIRTABLE_API_KEY and YOUR_BASE_ID with your actual credentials

Starting the Server

JavaScript Version

node airtable_simple.js

Python Version

python simple_airtable_server.py

Usage Examples

Once configured, you can interact with your Airtable bases directly through Claude:

List Tables

Can you show me all the tables in my Airtable base?

Query Records

Show me the first 5 records from the "Projects" table

Filter Records

Find all tasks in the "Tasks" table that are marked as "High Priority" and are not completed

Create Records

Add a new record to the "Contacts" table with name "John Smith", email "john@example.com", and phone "555-1234"

Update Records

Update the status of the project "Website Redesign" to "Completed"

Schema Operations

Create a new table called "Inventory" with fields for "Item Name", "Quantity", "Price", and "Category"

Troubleshooting

• Connection Issues: Ensure the server is running and the URL in your Claude configuration is correct
• Authentication Errors: Verify your Airtable API key has the necessary permissions
• Base ID Problems: Double-check that you're using the correct base ID format
• Port Conflicts: If port 8000 is already in use, modify the port in both the server script and Claude configuration

Advanced Configuration

For more advanced setups, you can use the smithery.yaml configuration file to define custom behaviors and mappings between natural language commands and Airtable operations.

Security Considerations

• Your Airtable API key provides full access to your bases. Never share it publicly.
• Consider using environment variables rather than hardcoding credentials.
• The MCP server runs locally by default, which limits exposure.

Additional Resources

• Airtable API Documentation
• Anthropic MCP Documentation
• Full Documentation on GitHub