MCP Hub Logo

Airtable Connector

Read, create, and update records in your Airtable bases from your AI. The database anyone can understand.

airtabledatabasespreadsheetcrmno-code
CuratedLast reviewed: Dec 11, 2024API Key Required

About

Airtable Connector

Use your Airtable bases as a live data source for your AI. Query records with filters, create new rows, update fields, and work with linked tables — all through conversation.

Setup

  1. Get your Airtable personal access token at https://airtable.com/account (API section)
  2. Add to your MCP config:
{
  "mcpServers": {
    "airtable-connector": {
      "command": "npx",
      "args": ["-y", "@mcphub/airtable-connector"],
      "env": {
        "AIRTABLE_TOKEN": "pat...",
        "AIRTABLE_BASE_ID": "app..."
      }
    }
  }
}

Example Prompts

  • "List all leads in the CRM base where status is 'Qualified'"
  • "Add a new row to the Contacts table"
  • "Update the status of record recXXX to Closed Won"

Permissions & Access

Permissions Required

read:recordswrite:records

⚠ This tool requires write or destructive access. Review permissions carefully before installing.

External Systems Accessed

Airtable