home / mcp / airtable mcp server

Airtable MCP Server

An Airtable MCP Server that supports SSE

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "am1010101-airtable-mcp-sse": {
      "url": "http://localhost:8080/sse"
    }
  }
}

You can run an Airtable MCP Server that lets large language models inspect Airtable schemas and safely read and write records. It exposes a browseable schema surface and a range of record-level operations so you can build intelligent workflows that interact with Airtable data.

How to use

Start the server locally to expose an MCP interface over HTTP or use the local runtime to run it directly. You can then configure your MCP client to connect to the server, enabling your AI workflows to list bases, describe tables, read and write records, and perform schema discovery.

How to install

Prerequisites you need before installing: install Node.js (version 14 or newer) and npm on your machine.

Install the project dependencies and start the server.

Configure and run the server

You have two recommended ways to run and connect to the server. Use the HTTP connection for remote clients and the local runtime command for development or testing.

{
  "mcpServers": {
    "airtable": {
      "url": "http://localhost:8080/sse",
      "headers": {
        "Authorization": "Bearer pat123.abc123"
      }
    }
  }
}

Runtime usage and commands

Run the server locally with Node.js using the standard runtime command shown in the setup flow.

npm start
```
This starts the server on port 8080 by default.

Available tools

list_records

Lists records from a specified Airtable table. Requires baseId and tableId; supports maxRecords and filterByFormula to constrain results.

search_records

Searches for records containing specific text within a base/table. Supports field filtering and a maximum record limit.

list_bases

Lists all accessible Airtable bases with their IDs, names, and permission levels.

describe_base

Fetches the complete schema for a base, including its tables. Detail level can be tableIdentifiersOnly, identifiersOnly, or full.

describe_all_bases

Fetches complete schemas for all accessible bases with configurable detail level.

list_tables

Lists all tables in a base along with details such as fields and views, controlled by detail level.

describe_table

Gets detailed information about a single table, with selectable detail depth.

get_record

Retrieves a specific record by its ID from a given base and table.

create_record

Creates a new record in a specified table with provided fields.

update_records

Updates one or more records in a table with new field values.

delete_records

Deletes one or more records from a table by their IDs.

create_table

Creates a new table in a base with specified name, description, and field definitions.

update_table

Updates a table's name or description.

create_field

Creates a new field within a table with a given name, type, and optional description and options.

update_field

Updates a field's name or description within a table.