An Airtable MCP server gives an AI client tools to search, read, create and update your bases, tables, fields and records — so you can ask Claude to query a base or update records in natural language. Here is the setup.
Step 1 — create a personal access token
Go to airtable.com/create/tokens, create a token, and grant the scopes you need (e.g. data.records:read, data.records:write, schema.bases:read) plus access to the specific bases. Copy the token.
Step 2 — configure the client
A clean npx option:
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "airtable-mcp-server"],
"env": {
"AIRTABLE_API_KEY": "your_personal_access_token"
}
}
}
}
Claude Code one-liner:
claude mcp add --transport stdio --env AIRTABLE_API_KEY=your_token airtable -- npx -y airtable-mcp-server
Restart the client; see MCP config file location.
Step 3 — verify
Ask: "List the tables in my 'CRM' base and show 5 records from Contacts." Real data back confirms it works.
Common problems
NOT_AUTHORIZED/ 403 — the token lacks access to that base, or is missing a scope. Edit the token's base list/scopes.- Can read but not write — add
data.records:writeand recreate/adjust the token. - No tools in client — Node 18+ for
npx; see Cursor MCP not working.
Security
A personal access token can read/write your bases — scope it to only the bases needed, prefer read-only when you don't need writes, and keep it out of shared config. See MCP security best practices.
Going further
Airtable works as a lightweight database for agents — compare with best MCP server for a database. Browse the databases category or curated loadouts.