MCP Server

Active

MIT

Airtable MCP Server

io.github.domdomegg/airtable-mcp-server

Read and write access to Airtable databases, tables, records, and comments via Claude and other AI agents.

What is the Airtable MCP server?

The Airtable MCP server provides read and write access to Airtable databases through the Model Context Protocol. It enables LLMs to inspect database schemas, query records, create and update tables and fields, and manage comments—all via a unified set of tools.

This server connects Claude, Cursor, and other AI agents directly to your Airtable bases. You can list bases and tables, search and retrieve records, create or modify data, manage table schemas, and collaborate through comments. It's useful for automating data workflows, querying information, and letting AI agents interact with your Airtable workspace.

How to install Airtable

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

AIRTABLE_API_KEY
required
secret
Airtable personal access token (e.g., pat123.abc123). Create at https://airtable.com/create/tokens/new with scopes: schema.bases:read, data.records:read, and optionally schema.bases:write and data.records:write.

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "airtable-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "<YOUR_AIRTABLE_API_KEY>"
      }
    }
  }
}

Tools & capabilities

Tools this server exposes to the agent.

list_records — Lists records from a specified Airtable table with optional filtering and record limits.
search_records — Search for records containing specific text across all or selected fields.
list_bases — Lists all accessible Airtable bases with ID, name, and permission level.
list_tables — Lists all tables in a specific base with configurable detail levels.
describe_table — Gets detailed information about a specific table including fields and views.
get_record — Retrieves a specific record by ID from a table.
create_record — Creates a new record in a table with specified field values.
update_records — Updates one or more existing records in a table.
delete_records — Deletes one or more records from a table.
create_table — Creates a new table in a base with specified fields and metadata.
update_table — Updates a table's name or description.
create_field — Creates a new field in a table with specified type and options.
update_field — Updates a field's name or description.
create_comment — Creates a comment on a record, with optional threading support.
list_comments — Lists comments on a record with pagination support.

Use cases

Query and retrieve data from Airtable bases to inform AI decisions or generate reports.
Automate data entry by having Claude create or update Airtable records based on external information.
Build collaborative workflows where AI agents can comment on records and track discussions.
Manage database schemas dynamically by creating tables and fields programmatically.
Search Airtable records by text content to find relevant information for AI-assisted tasks.

Airtable MCP server FAQ

What is the Airtable MCP server?

It's a Model Context Protocol server that gives Claude, Cursor, and other AI agents full read and write access to your Airtable bases, including records, tables, fields, and comments.

Is it free to use?

The server itself is open-source and free. You need an Airtable account and a personal access token (free to create), and Airtable's standard pricing applies to your base usage.

How do I install it in Claude Desktop or Cursor?

Use the install-mcp tool at adamjones.me/install-mcp with the config for 'airtable'. It generates the correct configuration for your client. Alternatively, install via npm (airtable-mcp-server), Docker, or download the compiled binary.

What authentication is required?

You need an Airtable personal access token with at least `schema.bases:read` and `data.records:read` scopes. Set it as the `AIRTABLE_API_KEY` environment variable. Write access requires additional scopes.

Can I use this to modify my Airtable data?

Yes, with the appropriate token scopes. You can create, update, and delete records; create and modify tables and fields; and manage comments.

Does it support filtering and searching?

Yes. You can filter records using Airtable formulas, search for text across fields, and paginate results with configurable limits.

README (reference)

Source of truth, from the repository.

airtable-mcp-server

A Model Context Protocol server that provides read and write access to Airtable databases. This server enables LLMs to inspect database schemas, then read and write records.

https://github.com/user-attachments/assets/c8285e76-d0ed-4018-94c7-20535db6c944

Installation

Follow the instructions on install-mcp, which generates the right config for your MCP client (Claude Code, Claude Desktop, Cursor, Cline, VS Code, and more).

You'll need an Airtable personal access token — create one here with scopes schema.bases:read and data.records:read (and optionally schema.bases:write, data.records:write, data.recordComments:read, data.recordComments:write), and access to the bases you want to use. It looks something like pat123.abc123 (but longer). Set it as AIRTABLE_API_KEY (replacing the placeholder in the generated config).

Components

Tools

list_records
- Lists records from a specified Airtable table
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table to query
  - maxRecords (number, optional): Maximum number of records to return. Defaults to 100.
  - filterByFormula (string, optional): Airtable formula to filter records
search_records
- Search for records containing specific text
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table to query
  - searchTerm (string, required): Text to search for in records
  - fieldIds (array, optional): Specific field IDs to search in. If not provided, searches all text-based fields.
  - maxRecords (number, optional): Maximum number of records to return. Defaults to 100.
list_bases
- Lists all accessible Airtable bases
- No input parameters required
- Returns base ID, name, and permission level
list_tables
- Lists all tables in a specific base
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - detailLevel (string, optional): The amount of detail to get about the tables (tableIdentifiersOnly, identifiersOnly, or full)
- Returns table ID, name, description, fields, and views (to the given detailLevel)
describe_table
- Gets detailed information about a specific table
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table to describe
  - detailLevel (string, optional): The amount of detail to get about the table (tableIdentifiersOnly, identifiersOnly, or full)
- Returns the same format as list_tables but for a single table
- Useful for getting details about a specific table without fetching information about all tables in the base
get_record
- Gets a specific record by ID
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - recordId (string, required): The ID of the record to retrieve
create_record
- Creates a new record in a table
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - fields (object, required): The fields and values for the new record
update_records
- Updates one or more records in a table
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - records (array, required): Array of objects containing record ID and fields to update
delete_records
- Deletes one or more records from a table
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - recordIds (array, required): Array of record IDs to delete
create_table
- Creates a new table in a base
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - name (string, required): Name of the new table
  - description (string, optional): Description of the table
  - fields (array, required): Array of field definitions (name, type, description, options)
update_table
- Updates a table's name or description
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - name (string, optional): New name for the table
  - description (string, optional): New description for the table
create_field
- Creates a new field in a table
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - name (string, required): Name of the new field
  - type (string, required): Type of the field
  - description (string, optional): Description of the field
  - options (object, optional): Field-specific options
update_field
- Updates a field's name or description
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - fieldId (string, required): The ID of the field
  - name (string, optional): New name for the field
  - description (string, optional): New description for the field
create_comment
- Creates a comment on a record
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - recordId (string, required): The ID of the record
  - text (string, required): The comment text
  - parentCommentId (string, optional): Parent comment ID for threaded replies
- Returns the created comment with ID, author, creation time, and text
list_comments
- Lists comments on a record
- Input parameters:
  - baseId (string, required): The ID of the Airtable base
  - tableId (string, required): The ID of the table
  - recordId (string, required): The ID of the record
  - pageSize (number, optional): Number of comments to return (max 100, default 100)
  - offset (string, optional): Pagination offset for retrieving additional comments
- Returns comments array with author, text, timestamps, reactions, and mentions
- Comments are returned from newest to oldest

HTTP Transport

The server can also run in HTTP mode for use with remote MCP clients:

MCP_TRANSPORT=http PORT=3000 npx airtable-mcp-server

This starts a stateless HTTP server at http://localhost:3000/mcp. Note: HTTP transport has no built-in authentication - only use behind a reverse proxy or in a secured environment.

Contributing

Pull requests are welcomed on GitHub! To get started:

Install Git and Node.js
Clone the repository
Install dependencies with npm install
Run npm run test to run tests
Build with npm run build

You can use npm run build:watch to automatically build after editing src/index.ts. This means you can hit save, reload Claude Desktop (with Ctrl/Cmd+R), and the changes apply.

Releases

Versions follow the semantic versioning spec.

To release:

Use npm version <major | minor | patch> to bump the version
Run git push --follow-tags to push with tags
Wait for GitHub Actions to publish to the NPM registry.

Related MCP servers

Barcode Scanner

Active

Scan and generate barcodes and QR codes.

TypeScript

MIT

View repository →

Computer Use

Active

Lets Claude control your computer via screenshots, mouse, and keyboard automation.

318

TypeScript

MIT

View repository →

Defuddle Fetch

Active

Fetch content from the web, cleaned up nicely for LLMs (using Defuddle).

TypeScript

MIT

View repository →

Downdetector

Active

Check service status and outage information via Downdetector.

TypeScript

MIT

View repository →

Filesystem

Active

Read, create, and edit files.

TypeScript

View repository →

Gmail

Active

Allow AI systems to read, send, archive, and manage emails via Gmail.

TypeScript

View repository →