home / mcp / airtable mcp server

Airtable MCP Server

Provides read and write access to Airtable bases, tables, records, and comments for MCP-enabled clients.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "domdomegg-airtable-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "pat123.abc123"
      }
    }
  }
}

You can use this MCP server to access Airtable databases programmatically, allowing your large language model workflows to read schemas, query bases and tables, and create or update records with structured, rule-based interactions.

How to use

To leverage Airtable in your MCP-enabled workflow, connect the server to your MCP client using a local stdio configuration (npx) and your Airtable API key. You will gain endpoints for listing bases, listing tables, describing tables, and performing CRUD operations on records as described in the Tools section.

How to install

Prerequisites: Node.js installed on your machine.

# Install dependencies and prepare the MCP server (example steps)
npm install
npm run build

Available tools

list_records

Lists records from a specified Airtable table with optional max count and filter.

search_records

Searches for records containing specific text across one or more fields.

list_bases

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

list_tables

Lists all tables in a base with varying levels of detail.

describe_table

Gets detailed information about a specific table.

get_record

Retrieves a single record by ID.

create_record

Creates a new record in a table with specified fields.

update_records

Updates one or more records in a table.

delete_records

Deletes one or more records from a table.

create_table

Creates a new table within a base with specified fields.

update_table

Updates a table's name or description.

create_field

Creates a new field in a table.

update_field

Updates a field's name or description.

create_comment

Creates a comment on a record and returns the created comment details.

list_comments

Lists comments on a record with pagination and ordering.