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.

🛠️ Key Features

Read and write access to Airtable database schemas, tables, and records
Model Context Protocol (MCP) compatibility for structured context exchange
Lightweight readme excerpt provided for quick familiarity
Topics: airtable, mcp-server, model-context-protocol

🚀 Use Cases

Inspect Airtable schemas to inform LLM reasoning
Retrieve and modify records within Airtable via MCP
Integrate Airtable data access into AI-powered workflows

⚡ Developer Benefits

Clear MCP-driven interface for model-context operations
Reusable server component with focused Airtable integration
Snippet of setup guidance and config guidance in readme excerpt

⚠️ Limitations

Based on the provided readme excerpt; broader feature support may require official documentation
Requires proper authentication and Airtable API access outside this snippet
Details on installation/configuration are referenced in linked materials and may vary by environment

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:

bash

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

This starts a stateless HTTP server at http://localhost:3000/mcp.

WARNING

The HTTP transport has no built-in authentication, and binding to localhost or a private network is not a security boundary against browsers: a malicious website can use DNS rebinding to make a visitor's browser send requests to http://localhost:3000/mcp and invoke tools — including reading, writing and deleting records — using this server's Airtable token.

Only run HTTP mode where untrusted callers (including browsers on the same machine or network) cannot reach /mcp without authenticating. In practice that means putting it behind a reverse proxy or gateway that requires a credential a browser won't attach cross-origin, such as an Authorization header.

If you just want to use this server with an MCP client on the same machine, use the default stdio transport instead — it doesn't open a port at all.

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.

Install

Configuration

Environment variables

AIRTABLE_API_KEYrequiredsecret

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.

Add to VS Code Add to Cursor

claude_desktop_config.json

json

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

Airtable