Airtable

by Domenic Rosati

v1.14.0

MIT

Repository Docs npm

Productivity

airtabledatabaseno-codeproductivity

Summary

Read and write Airtable bases from an AI client — records, schemas, fields, and views.

Features

Read and write records across bases and tables
Inspect base schemas, fields, and views
Create and modify tables and fields

Installation

Set up this MCP server in your favorite AI agent — copy a ready-made configuration below.

Any MCP-compatible agent

Most agents (Claude, Cursor, Windsurf, VS Code, and more) read a standard mcpServers configuration.

Open your agent's MCP configuration file.
Merge the snippet below into it, filling in the environment variables with your own values.
Restart the agent — the "Airtable" tools will be available.

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "pat.your-token"
      }
    }
  }
}

Claude Code

Add the server with a single CLI command.

claude mcp add airtable -e AIRTABLE_API_KEY=pat.your-token -- npx -y airtable-mcp-server

Claude Desktop

Add the server to claude_desktop_config.json (Settings → Developer → Edit Config).

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "pat.your-token"
      }
    }
  }
}

Cursor

{
  "command": "npx",
  "args": [
    "-y",
    "airtable-mcp-server"
  ],
  "env": {
    "AIRTABLE_API_KEY": "pat.your-token"
  }
}

Windsurf

{
  "command": "npx",
  "args": [
    "-y",
    "airtable-mcp-server"
  ],
  "env": {
    "AIRTABLE_API_KEY": "pat.your-token"
  }
}

VS Code

{
  "command": "npx",
  "args": [
    "-y",
    "airtable-mcp-server"
  ],
  "env": {
    "AIRTABLE_API_KEY": "pat.your-token"
  }
}

Description

This MCP server gives an assistant full read and write access to Airtable, which is unusually valuable because Airtable is where a lot of small teams keep their operational data.

What it covers

Records. List, search, create, update, and delete, with filtering by formula and view.
Schema inspection. Bases, tables, fields, and their types — so the assistant writes to the right fields with the right formats rather than guessing.
Schema modification. Create tables and fields, which means an assistant can set up a base structure from a description.

Typical uses

Bulk-updating records that would be tedious by hand; answering questions across a base without building a view for them; migrating data between tables; and generating structured records from unstructured input — turning a pile of notes into rows.

Setup

Requires an Airtable personal access token with the scopes for the bases you want reachable. Scope the token to specific bases rather than granting workspace-wide access.

Runs with npx -y airtable-mcp-server. Widely used and actively maintained.