Airtable MCP Server

Airtable MCP Server

Connect Claude to your Airtable bases through Airtable's official MCP server.

The Airtable MCP Server enables Claude to query tables, create records, update data, and manage your Airtable bases using natural language commands.

Official Airtable MCP setup guide explains the current server flow, and Airtable's developer hub is the live entry point for creating a PAT when you are not using OAuth.

What Can Claude Do with the Airtable MCP Server?

The Airtable MCP Server exposes Airtable API functionality to Claude through the Model Context Protocol.

Core capabilities:

• Query Tables — Retrieve records from tables with filtering and sorting
• Create Records — Add new records to tables with field values
• Update Records — Modify existing record data
• Delete Records — Remove records from tables
• List Bases & Tables — View available bases, tables, and field schemas

Access scope: Claude can only access Airtable bases and tables authorized through OAuth or your Personal Access Token (PAT). The integration respects Airtable workspace permissions and sharing settings.

How to Install the Airtable MCP Server

Airtable provides an official MCP server with OAuth and PAT authentication options.

For Claude Code

Recommended: OAuth via Connector

Connect through Airtable's pre-configured connector interface if available in Claude Code. This uses OAuth for secure authorization.

Alternative: HTTP Transport with PAT

claude mcp add airtable \
              --transport http \
              --url https://mcp.airtable.com/mcp \
              --header "Authorization: Bearer YOUR_PERSONAL_ACCESS_TOKEN"

Replace YOUR_PERSONAL_ACCESS_TOKEN with your actual Airtable PAT.

For Claude Desktop

OAuth via Connector:

If your Claude Desktop version supports Airtable connectors, use the connector interface to complete OAuth authorization.

Manual Configuration with PAT:

Add to your claude_desktop_config.json file:

{
  "mcpServers": {
    "airtable": {
      "transport": "http",
      "url": "https://mcp.airtable.com/mcp",
      "headers": {
        "Authorization": "Bearer YOUR_PERSONAL_ACCESS_TOKEN"
      }
    }
  }
}

Configuration file locations:

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

Replace YOUR_PERSONAL_ACCESS_TOKEN with your actual PAT.

Important: Keep your PAT secure. Do not commit it to version control.

Restart Claude Desktop after saving the configuration file.

Airtable API Key Setup for MCP

Airtable's MCP server supports two authentication methods.

OAuth (Recommended)

Best for:

• Interactive use in supported clients
• Team environments with user-specific access
• Granular permission control

How it works:

1. Your MCP client initiates OAuth connection to Airtable
2. You're redirected to Airtable's authorization page
3. You select which bases to share
4. Airtable generates access credentials
5. Your client stores these credentials securely

Personal Access Token (Alternative)

Best for:

• Clients that don't support OAuth
• Automation and CI/CD scenarios
• Legacy compatibility

Creating a Personal Access Token:

1. Log in to Airtable

• Go to airtable.com and sign in to your account

1. Access Developer Settings

• Click your account icon in the top-right corner
• Select "Account" → "Developer"

1. Generate Personal Access Token

• Click "Create new token"
• Give your token a descriptive name (e.g., "Claude MCP")
• Select required scopes:
• data.records:read — Read records from tables
• data.records:write — Create and update records
• schema.bases:read — View base and table schemas
• Choose which bases the token can access

1. Copy and Secure Your Token

After creating the token, copy it immediately. Airtable only displays the full token once.

Important: Airtable API keys are deprecated and no longer work. PATs are the supported token-based authentication method.

Airtable MCP Use Cases & Query Examples

Example workflows that become possible with the Airtable MCP Server.

Query Table Records

Example prompt:

> "Show me all records from the 'Projects' table where Status is 'In Progress'."

Claude can retrieve filtered records from your Airtable tables.

Create New Records

Example prompt:

> "Add a new record to the 'Tasks' table with Name: 'Update documentation', Status: 'To Do', and Priority: 'High'."

Claude can create records with specified field values.

Update Existing Records

Example prompt:

> "In the 'Contacts' table, update the record for John Smith and change his email to john.smith@newcompany.com."

Claude can modify record data in your tables.

Search and Filter

Example prompt:

> "Find all records in the 'Orders' table from the last 7 days with Amount greater than $1000."

Claude can search and filter records based on multiple criteria.

List Table Schema

Example prompt:

> "What fields are in the 'Customers' table and what are their types?"

Claude can retrieve table structure and field information.

Note: These are example use cases. Actual capabilities depend on your OAuth authorization or PAT permissions and base access settings.

Use Airtable MCP in Verdent

Verdent provides streamlined Airtable integration with simplified authentication. This is Verdent's platform-level integration flow, not the default setup path from Airtable's official documentation.

Connect your Airtable account once and access base operations across all Verdent projects without manual configuration.

Connect Airtable in Verdent