airtable-mcp-server

An MCP server for Airtable: the agent inspects base schemas, searches, creates, updates and deletes records, and handles fields and comments

MCP serverHigh risk

domdomegg/airtable-mcp-server

Install

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["-y", "airtable-mcp-server"],
      "env": {
        "AIRTABLE_API_KEY": "pat123.abc123"
      }
    }
  }
}

Config from the install-mcp generator; replace the token with yours.

This is third-party code. Review the repository files before installing.

What it does

The server connects the agent to Airtable bases with a personal access token. The agent first lists bases, tables and fields, then reads records with a formula filter or searches by text. It can create and bulk-update records, delete them, add tables and fields, and rename or describe them. It also reads and creates record comments, including threaded replies.

Who it is for. For teams that keep data in Airtable and want to query and edit it through an agent.

Good fit when

  • You need to find and update records by condition without manual filtering
  • You need to design a new table with fields from a description
  • You need a summary of data in an Airtable base

Not a fit when

  • Your data is not in Airtable
  • You need an HTTP server for remote clients without your own authenticating gateway

Example request

Find all deals in the CRM base with status pending older than a month and add a comment to each

Limitations

Requires an Airtable personal access token with schema and record read scopes, plus write scopes for changes. HTTP mode has no built-in auth; the author warns about DNS rebinding and recommends stdio for local use. Airtable availability from Russia is not guaranteed.

How to disable. Remove the airtable block from the MCP config and revoke the token on Airtable's tokens page.

MCP

Transport
stdio, http
Authentication
API key
Environment variables
Environment variables
AIRTABLE_API_KEY
required, secret
Airtable personal access token.

Security check

  • Creates, modifies and deletes records and tables in an external service
  • Uses an Airtable access token

README in short

The README points to the install-mcp config generator for various clients and explains how to create an Airtable personal access token with the right scopes. It lists tools for bases, tables, fields, records and comments with parameters. HTTP mode and its risks are covered separately. The project is TypeScript, published to npm, MIT licensed.

FAQ

Which token scopes do I need?

schema.bases:read and data.records:read for reading. Add schema.bases:write and data.records:write for changes and the data.recordComments scopes for comments.

Can it run over HTTP?

Yes, with MCP_TRANSPORT=http, but only behind an authenticating proxy, otherwise anyone reaching the port can call the tools.

Editors’ pick

166 skills for scientific work: bioinformatics, cheminformatics, clinical data, geospatial analysis and 100+ databases

SkillMedium risk44.9K
Editors’ pick

Google's open-source MCP server for databases: ready tools for Postgres, MySQL, BigQuery, Spanner and more, plus custom tools in tools.yaml

MCP serverHigh risk16.4K
Editors’ pick

Official Hugging Face skills: Hub operations via the hf CLI, datasets, model training, Spaces, evals and deployment

SkillHigh risk11K
Editors’ pick

A token-lean MCP server for PostgreSQL, MySQL, MariaDB, SQL Server and SQLite with a read-only mode

MCP serverHigh risk3.5K