Airtable MCP Server

An MCP (Model Context Protocol) server that provides tools for interacting with Airtable's API. This server allows AI assistants to perform various operations on Airtable bases and tables.

Features

• List Bases: Get a list of all available Airtable bases
• List Tables: Get all tables within a specific base
• Search Records: Retrieve records with optional filtering and sorting
• Edit Record: Update existing records
• Add Record: Create new records
• Custom Query: Execute flexible Airtable API operations

Installation

npm install @makeappeasy/airtable-mcp-server

Configuration

Add the server to your MCP settings configuration file:

{
  "mcpServers": {
    "airtable": {
      "command": "node",
      "args": ["node_modules/@makeappeasy/airtable-mcp-server/dist/index.js"],
      "env": {
        "AIRTABLE_API_KEY": "your-airtable-api-key"
      }
    }
  }
}

Usage

Once configured, the following tools will be available:

list_bases

Lists all available Airtable bases.

list_tables

Lists all tables in a specific base.

• baseId (required): The ID of the base

search_records

Retrieves records from a table with optional filtering.

• baseId (required): The ID of the base
• tableName (required): The name of the table
• filterByFormula (optional): Airtable formula to filter records
• maxRecords (optional): Maximum number of records to return (default: 100)
• sort (optional): Array of sort configurations

edit_record

Updates an existing record.

• baseId (required): The ID of the base
• tableName (required): The name of the table
• recordId (required): The ID of the record to update
• fields (required): Object containing fields to update

add_record

Creates a new record.

• baseId (required): The ID of the base
• tableName (required): The name of the table
• fields (required): Object containing fields for the new record

custom_query

Executes a custom Airtable API request.

• method (required): HTTP method (GET, POST, PATCH, PUT, DELETE)
• endpoint (required): API endpoint relative to base URL
• data (optional): Request body data
• params (optional): Query parameters

License

MIT