airtable

This MCP server provides full Airtable integration via the Model Context Protocol, offering CRUD operations, schema management, record comments, batch actions, webhooks, governance controls, and AI-powered analytics across Airtable bases. It exposes a wide set of tools (over 40) to list bases, query and manipulate records, manage schema and fields, handle batch operations, and retrieve analytics prompts. After configuring the server (via npx or your preferred runtime), you can interact with Airtable data using natural language prompts or structured tool calls to perform tasks such as listing bases, creating records, updating fields, managing views, and subscribing to webhooks. It also supports multi-base discovery and token-based identity verification (whoami) for secure access.

Prerequisites:

• Node.js 18 or later installed on your system
• npm (or corepack) available
• Airtable account and a Personal Access Token with the required scopes
• Base ID for dynamic discovery (optional, can be discovered via the tool)

Install and run (no local clone required):

1. Ensure Node.js is installed:

node -v
# should be >= 18.x

2. Use the MCP configuration (no global install required):

# Quick start using Claude Desktop / Claude Code example
# This adds the server config to Claude via npx
# The MCP server runs on demand and does not require a local server process

3. Run via npx with your Airtable token and base ID:

npx -y @rashidazarang/airtable-mcp

4. If you prefer manual config, add the following to your Claude config (or your MCP runner):

{
  "airtable": {
    "type": "stdio",
    "command": "/bin/bash",
    "args": ["-c", "cd /tmp && npx -y @rashidazarang/airtable-mcp"],
    "env": {
      "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN",
      "AIRTABLE_BASE_ID": "YOUR_BASE_ID"
    }
  }
}

Note: The token and base ID values must be supplied for access. The token should include all necessary scopes as described in the README.

Tips and caveats:

• Ensure your Airtable Personal Access Token includes the required scopes (data.records, data.recordComments, schema.bases, user.email, and optional webhook:manage).
• If you encounter resolution issues with npx, the quickstart wrapper (cd /tmp && npx ...) helps avoid local package.json conflicts.
• The MCP supports multi-base discovery; you can omit the BASE_ID and allow list_bases/list_bases-like tools to discover bases dynamically.
• When using Claude or other frontends, keep your AIRTABLE_TOKEN and BASE_ID secure and avoid committing them to source control.
• If you run into network or permission errors, verify that the token scopes align with the operations you attempt (read vs write operations).
• Refer to the 42 available tools in the README for the exact command names and capabilities.