Airtable

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.