Airtable MCP Server

DatabasesTypeScript

Interact with Airtable bases, tables, fields, and records

Available Tools

list_bases

List all accessible Airtable bases

list_tables

List all tables in a base

create_table

Create a new table with fields

update_table

Update a table's name or description

create_field

Add a new field to a table

update_field

Modify an existing field

list_records

Retrieve records from a table

create_record

Add a new record

update_record

Modify an existing record

delete_record

Remove a record

search_records

Find records matching criteria

get_record

Get a single record by its ID

The Airtable MCP server provides a comprehensive set of tools for programmatically managing your Airtable workspace. It enables you to create, read, update, and search across bases, tables, fields, and records through Claude Desktop or other MCP clients. This specialized implementation allows you to build tables in stages, leveraging Claude's capabilities while minimizing failure rates typically seen when building complex tables. The server supports various field types including text, email, number, date, and select fields with customizable options and colors.

Overview

The Airtable MCP server allows you to interact with Airtable's API through Claude Desktop or other MCP clients. You can manage bases, tables, fields, and records programmatically, making it easier to automate your Airtable workflows.

Requirements

Before using this MCP server, you need:

Node.js (version 18 or higher) and npm installed on your system
An Airtable account and API key

Obtaining an Airtable API Key

Log in to your Airtable account at airtable.com
Create a personal access token at Airtable's Builder Hub
Select the following scopes for your token:
- data.records:read
- data.records:write
- schema.bases:read
- schema.bases:write
Select the workspace or bases you want to give access to
Save your API key securely - you'll need it for configuration

Installation Options

Using npx (Recommended)

Navigate to the Claude configuration directory:
- Windows: C:\Users\NAME\AppData\Roaming\Claude
- macOS: ~/Library/Application Support/Claude/
Create or edit claude_desktop_config.json with the following configuration, replacing your_api_key_here with your actual Airtable API key:

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["@felores/airtable-mcp-server"],
      "env": {
        "AIRTABLE_API_KEY": "your_api_key_here"
      }
    }
  }
}

Using mcp-installer

If you have mcp-installer set up:

Open Claude Desktop
Ask Claude to install the Airtable MCP server:

Install @felores/airtable-mcp-server set the environment variable AIRTABLE_API_KEY to 'your_api_key'

Local Development Installation

For contributing or modifying the code:

Clone the repository and install dependencies:

git clone https://github.com/felores/airtable-mcp.git
cd airtable-mcp
npm install
npm run build

Configure Claude Desktop to use your local installation by editing the configuration file:

{
  "mcpServers": {
    "airtable": {
      "command": "node",
      "args": ["path/to/airtable-mcp/build/index.js"],
      "env": {
        "AIRTABLE_API_KEY": "your_api_key_here"
      }
    }
  }
}

Verifying Installation

Start Claude Desktop
Check that "Airtable" appears in the "Connected MCP Servers" section
Test with a simple command like "List all bases"

Usage Examples

Here are some examples of how to use the Airtable MCP server:

Base and Table Management

List all my Airtable bases
List all tables in base X
Create a new table called "Contacts" with fields for name, email, and phone number

Record Operations

List all records in the Contacts table
Create a new record in the Contacts table with name "John Doe" and email "john@example.com"
Search for records in the Contacts table where name contains "John"
Update the record with ID "rec123" to change the email to "newemail@example.com"

Field Management

Add a new select field called "Status" with options "Active", "Inactive", and "Pending"
Update the "Status" field to add a new option "Completed"

The server is designed to work with Claude's capabilities, allowing you to build complex tables in stages and minimize failures when working with Airtable's API.