Model Context Protocol server with tools for working with the Airtable API. Programmatic management of bases, tables, fields, and records with specialized staged table building capabilities.

Installation

NPX (recommended)

npx @felores/airtable-mcp-server

MCP Installer

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

From Source

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

Configuration

Claude Desktop (NPX)

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

Claude Desktop (Local)

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

Available Tools

Tool	Description
list_bases	List all available Airtable bases
list_tables	List all tables in a base
create_table	Create a new table with fields
update_table	Update table 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	Delete a record
search_records	Search records by criteria
get_record	Retrieve a single record by ID

Features

• Specialized staged table building implementation for error minimization
• Full base and table management
• Full field management with multiple types (text, email, phone, number, currency, date, select options)
• Complex CRUD operations on records and search functionality
• Multiple colors for select fields
• System prompt and project knowledge files for enhanced LLM guidance

Environment Variables

Required

• AIRTABLE_API_KEY — personal access token from Airtable with required scopes (data.records:read/write, schema.bases:read/write)

Usage Examples

List all bases

Create a new table with fields

Add records to a table

Search for records matching specific criteria

Notes

Requires Node.js version 18 or higher. Airtable API key should be obtained from the Airtable Builder Hub with specific scopes: data.records:read, data.records:write, schema.bases:read, schema.bases:write. Includes specialized system prompts for better integration with Claude Desktop.