Airtable MCP Server

A Model Context Protocol (MCP) server for Airtable with full CRUD operations, schema management, webhooks, batch operations, and AI-powered analytics.

Version 3.2.6 | MCP Protocol 2024-11-05

Overview

This server provides comprehensive Airtable integration through the Model Context Protocol, enabling natural language interactions with your Airtable data. It includes 33 tools for data operations and 10 AI prompt templates for intelligent analytics.

Key Features

• Full CRUD Operations — Create, read, update, and delete records with filtering and pagination
• Schema Management — Create and modify tables, fields, and views programmatically
• Batch Operations — Process up to 10 records per operation for improved performance
• Webhook Management — Set up real-time notifications for data changes
• AI Analytics — Predictive analytics, natural language queries, and automated insights
• Multi-Base Support — Discover and work with multiple bases dynamically
• Type Safety — Full TypeScript support with comprehensive type definitions

Prerequisites

• Node.js 14 or later
• An Airtable account with a Personal Access Token
• Your Airtable Base ID (optional—can be discovered via the list_bases tool)

Installation

Option 1: NPM (Recommended)

npm install -g @rashidazarang/airtable-mcp

Option 2: Clone from GitHub

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

Configuration

Step 1: Get Your Airtable Credentials

1. Personal Access Token: Go to Airtable Account Settings and create a token with these scopes:

   • data.records:read — Read records
   • data.records:write — Create, update, delete records
   • schema.bases:read — View table schemas
   • schema.bases:write — Create and modify tables and fields
   • webhook:manage — Manage webhooks (optional)

2. Base ID: Open your Airtable base and copy the ID from the URL: https://airtable.com/[BASE_ID]/...

Step 2: Environment Variables

Create a .env file in your project directory:

AIRTABLE_TOKEN=your_personal_access_token
AIRTABLE_BASE_ID=your_base_id  # Optional in v3.2.5+

Note: The Base ID is optional. You can start without one and use the list_bases tool to discover accessible bases, or specify base IDs per tool call.

Step 3: Configure Your MCP Client

Add to your Claude Desktop configuration:

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

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["@rashidazarang/airtable-mcp"],
      "env": {
        "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN",
        "AIRTABLE_BASE_ID": "YOUR_BASE_ID"
      }
    }
  }
}

To start without a base ID (and discover bases dynamically):

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["@rashidazarang/airtable-mcp"],
      "env": {
        "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN"
      }
    }
  }
}

Step 4: Restart Your MCP Client

Restart Claude Desktop or your MCP client to load the server.

Usage

Once configured, interact with your Airtable data using natural language:

Basic Operations

• "List all my accessible Airtable bases"
• "Show me all records in the Projects table"
• "Create a new task with priority 'High' and due date tomorrow"
• "Update the status of task ID rec123 to 'Completed'"
• "Search for records where Status equals 'Active'"

Schema Management

• "Show me the complete schema for this base"
• "Create a new table called 'Tasks' with Name, Priority, and Due Date fields"
• "Add a Status field to the Projects table"

Batch Operations

• "Create 5 new records at once in the Tasks table"
• "Update multiple records with new status values"
• "Delete these 3 records in one operation"

Webhooks

• "Create a webhook for my table that notifies https://my-app.com/webhook"
• "List all active webhooks in my base"

TypeScript Usage

import {
  AirtableMCPServer,
  ListRecordsInput,
  AnalyzeDataPrompt
} from '@rashidazarang/airtable-mcp/types';

const server = new AirtableMCPServer();

const params: ListRecordsInput = {
  table: 'Tasks',
  maxRecords: 10,
  filterByFormula: "Status = 'Active'"
};

const records = await server.handleToolCall('list_records', params);

Available Tools

Data Operations (7 tools)

Schema Discovery (6 tools)

Table Management (3 tools)

Field Management (3 tools)

Batch Operations (4 tools)

Webhook Management (5 tools)

Views and Attachments (3 tools)

Base Management (3 tools)

AI Intelligence Suite

Ten AI prompt templates for advanced analytics:

Advanced Configuration

Smithery Cloud

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "@smithery/cli",
        "run",
        "@rashidazarang/airtable-mcp",
        "--token", "YOUR_TOKEN",
        "--base", "YOUR_BASE_ID"
      ]
    }
  }
}

Direct Node.js Execution

{
  "mcpServers": {
    "airtable": {
      "command": "node",
      "args": [
        "/path/to/airtable-mcp/airtable_simple.js",
        "--token", "YOUR_TOKEN",
        "--base", "YOUR_BASE_ID"
      ]
    }
  }
}

Testing

TypeScript

npm install
npm run test:types    # Type checking
npm run test:ts       # Full test suite
npm run build && npm run start:ts

JavaScript

export AIRTABLE_TOKEN=your_token
export AIRTABLE_BASE_ID=your_base_id
node airtable_simple.js &
./test_v1.6.0_comprehensive.sh

Troubleshooting

Connection Refused

• Verify the MCP server is running
• Check that port 8010 is available
• Restart your MCP client

Invalid Token

• Verify your Personal Access Token is correct
• Confirm the token has the required scopes
• Check for extra whitespace in credentials

Base Not Found

• Confirm your Base ID is correct
• Verify your token has access to the base

Port Conflicts

lsof -ti:8010 | xargs kill -9

Project Structure

airtable-mcp/
├── src/
│   ├── typescript/       # TypeScript implementation (primary)
│   └── javascript/       # JavaScript implementation
├── dist/                 # Compiled output
├── docs/                 # Documentation
├── tests/                # Test files
├── examples/             # Usage examples
├── types/                # TypeScript definitions
└── bin/                  # CLI executables

Documentation

• Installation Guide
• Quick Start
• Type Definitions
• Release Notes
• Changelog

Contributing

Contributions are welcome. Please open an issue first to discuss major changes.

License

MIT License — see LICENSE for details.

Support

• GitHub Issues
• GitHub Discussions