airtable

This Airtable MCP Server provides a set of tools that integrate Airtable's API with MCP clients (such as Claude Desktop) to manage bases, tables, fields, and records. It includes capabilities to list bases and tables, create and update tables and fields, and perform typical record operations like listing, creating, updating, deleting, and searching records. A notable feature is its staged approach to table creation, which leverages Claude's agentic capabilities to reduce failure rates when building complex table schemas. The server also ships with a system prompt and project knowledge files to guide the LLM when handling projects within Claude Desktop.

To use the server, configure Claude Desktop (or another MCP client) to point at the Airtable MCP server. Depending on your installation method, you will either run the server via npx, or point Claude to a local build. Once connected, you can issue commands such as: list_bases, list_tables, create_table, update_table, create_field, update_field, list_records, create_record, update_record, delete_record, search_records, and get_record. Each command maps to common Airtable operations, allowing you to script or interactively manage your Airtable workspace through Claude’s interface.

Before issuing commands, ensure your Airtable API key is securely configured in the environment so the MCP server can authenticate against Airtable. The docs also include guidance on how to structure fields (e.g., singleLineText, number, date, singleSelect, multiSelect) and available colors for select fields, enabling you to prototype complex tables and data models with confidence.

Prerequisites:

• Node.js 18+ and npm installed
• An Airtable account with a personal access token (AIRTABLE_API_KEY) configured

Installation options:

Method 1 — Using npx (Recommended):

1. Ensure Node.js is installed and your environment has access to npm.
2. In Claude Desktop (or your preferred environment), configure the MCP server to use npx with the Airtable MCP server package:

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

Method 2 — Using mcp-installer (for Claude Desktop integration):

1. Install mcp-installer from its repository.
2. Use Claude Desktop to install the Airtable MCP server:

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

Method 3 — Local development installation (contribute or modify):

# Clone the repository
git clone https://github.com/felores/airtable-mcp.git
cd airtable-mcp

# Install dependencies
npm install

# Build the server
npm run build

# Run locally
node build/index.js

Then point Claude Desktop to the local server:

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

Verifying installation:

1. Start Claude Desktop
2. Verify the Airtable MCP server appears under Connected MCP Servers
3. Test with a simple command like:

List all bases

Tips and notes:

• Store your AIRTABLE_API_KEY securely and do not commit it to version control.
• If you modify environment variables, ensure Claude Desktop is reloaded to pick up changes.
• Available field types include singleLineText, multilineText, email, phoneNumber, number, currency, date, singleSelect, and multiSelect. Select field colors listed in the README can be used to customize appearance for select fields.
• When building complex tables, consider leveraging the staged table-building workflow mentioned in the README to reduce failure rates.
• If you encounter authentication or rate-limit errors from Airtable, verify token scopes and base access permissions granted by the token.