Airtable MCP Server

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"]
    }
  }
}

list_tables

Get all tables in your base with schema information

list_records

Query records with optional 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 and sorting

list_webhooks

View all webhooks configured for your base

create_webhook

Set up real-time notifications for data changes

delete_webhook

Remove webhook configurations

get_webhook_payloads

Retrieve webhook notification history

refresh_webhook

Extend webhook expiration time

list_bases

List all accessible Airtable bases with permissions

get_base_schema

Get complete schema information for any base

describe_table

Get detailed table info including all field specifications

list_field_types

Reference guide for all available Airtable field types

get_table_views

List all views for a specific table with configurations

create_table

Create new tables with custom field definitions

update_table

Modify table names and descriptions

delete_table

Remove tables (with safety confirmation required)

create_field

Add new fields to existing tables with all field types

update_field

Modify field properties, names, and options

delete_field

Remove fields (with safety confirmation required)

batch_create_records

Create up to 10 records at once for better performance

batch_update_records

Update up to 10 records simultaneously

batch_delete_records

Delete up to 10 records in a single operation

batch_upsert_records

Update existing or create new records based on key fields

upload_attachment

Attach files from public URLs to attachment fields

create_view

Create new views (grid, form, calendar, etc.) with custom configurations

get_view_metadata

Get detailed view information including filters and sorts

analyze_data

Advanced statistical analysis with ML insights

create_report

Intelligent report generation with recommendations

data_insights

Business intelligence and pattern discovery

optimize_workflow

AI-powered automation recommendations

smart_schema_design

Database optimization with best practices

data_quality_audit

Comprehensive quality assessment and fixes

predictive_analytics

Forecasting and trend prediction

natural_language_query

Process human questions intelligently

smart_data_transformation

AI-assisted data processing

automation_recommendations

Workflow optimization suggestions