Airtable MCP Server

Advanced AI-powered Airtable MCP server with TypeScript support, intelligent analytics, predictive modeling, and enterprise automation capabilities

Remote serverstreamable-httpTypeScript

What is the Airtable MCP Server?

Advanced AI-powered Airtable MCP server with TypeScript support, intelligent analytics, predictive modeling, and enterprise automation capabilities

What the server does

A Model Context Protocol (MCP) server for Airtable with full CRUD operations, schema management, record comments, webhooks, batch operations, governance controls, and AI-powered analytics.

This server provides comprehensive Airtable integration through the Model Context Protocol, enabling natural language interactions with your Airtable data. It includes 42 tools covering every Airtable PAT scope and 10 AI prompt templates for intelligent analytics.

  • Full CRUD Operations — — Create, read, update, and delete records with filtering and pagination
  • Record Comments — — List, create, update, and delete comments on records
  • Schema Management — — Create and modify tables, fields, and views programmatically
  • Batch Operations — — Process up to 10 records per operation for improved performance
  • Webhook Management — — Set up real-time notifications for data changes
  • Governance & Compliance — — Allow-list governance, PII masking, and exception tracking

Credentials and setup notes

  • Node.js 18 or later - An Airtable account with a Personal Access Token - Your Airtable Base ID (optional — can be discovered via the list_bases tool) ---

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
list_basesList all accessible bases with permissions
describeDescribe base or table schema (supports detail levels)
queryQuery records with filtering, sorting, and pagination
search_recordsAdvanced search with Airtable formulas
list_recordsList records with field selection and pagination
get_recordRetrieve a single record by ID
createCreate new records (requires dryRun diff review)
updateUpdate existing records (requires dryRun diff review)
delete_recordRemove a record from a table
upsertUpdate or create records based on merge fields
batch_upsert_recordsBatch upsert with merge-on fields
list_tablesGet all tables in a base with schema info
get_base_schemaGet complete schema for any base
list_field_typesReference guide for available field types

How to install the Airtable MCP Server

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

Configuration as documented by the project. Restart the client after saving.

Configuration

  • Node.js 18 or later - An Airtable account with a Personal Access Token - Your Airtable Base ID (optional — can be discovered via the list_bases tool) ---
VariableDescriptionRequired
AIRTABLE_TOKENCredential the server authenticates with.Yes
AIRTABLE_BASE_IDConfiguration value read at startup.Optional
BASE_IDConfiguration value read at startup.Optional

Example prompts to try

  • “Use Airtable to list bases.”
  • “Use Airtable to describe.”
  • “Use Airtable to query.”

Frequently asked questions

Advanced AI-powered Airtable MCP server with TypeScript support, intelligent analytics, predictive modeling, and enterprise automation capabilities Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.