Airtable

You can run an AI-powered MCP server for Airtable that provides natural language queries, CRUD operations, webhooks, and enterprise-grade AI analytics. It supports optional dynamic base discovery, multi-base workflows, and STDIO-based local execution so you can connect from Claude Desktop or other MCP clients with ease.

How to use

Interact with your Airtable data using natural language or structured prompts. You can discover bases, select a base per tool call, and perform full CRUD operations across tables. The AI intelligence suite adds predictive analytics, data quality auditing, and smart schema design to help you optimize your data architecture and automate workflows. Use webhooks for real-time notifications, manage table structures, and leverage batch operations for efficiency.

How to install

Prerequisites: you need Node.js 14+ installed on your system. You also need an Airtable account and a Personal Access Token with the appropriate scopes.

Install the MCP server client package. You have options depending on your preferred language and setup.

Then configure environment variables and set up your MCP client to start the server.

Additional setup and configuration

You can run the MCP server from multiple configurations. The following examples are intended to be copied as-is into your Claude Desktop or MCP client configuration.

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

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

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

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

Available tools

list_tables

Get all tables in your base with schema information

list_records

Query records with filtering and pagination

get_record

Retrieve a single record by ID

create_record

Add new records to any table

update_record

Modify existing record fields

delete_record

Remove records from a table

search_records

Advanced search with Airtable formulas

list_bases

List all accessible bases with permissions

get_base_schema

Get complete schema for any base

describe_table

Get detailed table and field specifications

list_field_types

Reference guide for available field types

get_table_views

List all views for a table

create_table

Create tables with custom field definitions

update_table

Modify table names and descriptions

delete_table

Remove tables (requires confirmation)

create_field

Add fields to existing tables

update_field

Modify field properties and options

delete_field

Remove fields (requires confirmation)

batch_create_records

Create up to 10 records at once

batch_update_records

Update up to 10 records simultaneously

batch_delete_records

Delete up to 10 records in one operation

batch_upsert_records

Update or create records based on key fields

list_webhooks

View all configured webhooks

create_webhook

Set up real-time notifications

delete_webhook

Remove webhook configurations

get_webhook_payloads

Retrieve notification history

refresh_webhook

Extend webhook expiration

create_view

Create views (grid, form, calendar, etc.)

get_view_metadata

Get view details including filters

upload_attachment

Attach files from URLs

create_base

Create new bases with initial structure

list_collaborators

View collaborators and permissions

list_shares

List shared views and configurations