home / mcp / airtable mcp server

Airtable MCP Server

Search, create and update Airtable bases, tables, fields, and records using Claude Desktop and MCP (Model Context Protocol) clients

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "felores-airtable-mcp": {
      "command": "npx",
      "args": [
        "@felores/airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "your_api_key_here"
      }
    }
  }
}

The Airtable MCP Server provides programmatic access to Airtable bases, tables, fields, and records through MCP clients like Claude Desktop. It enables you to manage Airtable resources via simple MCP operations, supporting reliable table-building workflows and guided prompts for project knowledge.

How to use

Connect your MCP client to the Airtable MCP Server using a local stdio configuration. You will supply your Airtable API key and then issue operations such as listing bases, creating tables, and managing records. Common workflows include listing bases, creating tables with fields, adding records, and updating or deleting records. You can also search for records that match criteria and fetch individual records by ID.

How to install

Prerequisites: Node.js 18 or higher and npm. Ensure you have a valid Airtable API key before running the server.

node --version
npm --version

Method 1: Using npx (Recommended) Create or edit your Claude configuration to include the Airtable MCP Server.

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["@felores/airtable-mcp-server"],
      "env": {
        "AIRTABLE_API_KEY": "your_api_key_here"
      }
    }
  }
}

Method 2: Using mcp-installer. Install mcp-installer, then install the Airtable MCP server through Claude Desktop by specifying the environment variable AIRTABLE_API_KEY. Claude will install the server and configure it for you.

Method 3: Local development installation. You can contribute or modify the server locally.

Verifying installation

Open Claude Desktop and ensure the Airtable MCP server appears in the Connected MCP Servers list.

Test with a simple command such as: List all bases.

Available tools

list_bases

List all Airtable bases accessible with the provided API key.

list_tables

List all tables within a specified base.

create_table

Create a new table in a base with defined fields.

update_table

Update a table's name or description.

create_field

Add a new field to a specified table.

update_field

Modify properties of an existing field.

list_records

Retrieve records from a table, with optional filters.

create_record

Add a new record to a table.

update_record

Modify an existing record by ID.

delete_record

Remove a record by its ID.

search_records

Find records matching specific criteria.

get_record

Get a single record by its ID.