Airtable MCP Server

MCP (Model Context Protocol) server implementation for Airtable API.

Tools

This server provides the following tools:

1. create_record

   • Creates a new record in an Airtable table
   • Inputs:
     • base_id (string): The ID of the Airtable base
     • table_id (string): The ID of the table within the base
     • fields (object): Field values to create in the record
   • Returns: Created record details

2. delete_record

   • Permanently deletes a record from an Airtable table
   • Inputs:
     • base_id (string): The ID of the Airtable base
     • table_id (string): The ID of the table within the base
     • record_id (string): The ID of the record to delete
   • Returns: Deleted record details

3. find_record

   • Searches for records in an Airtable table based on field value
   • Inputs:
     • base_id (string): The ID of the Airtable base
     • table_id (string): The ID of the table within the base
     • search_field (string): The field name to search in
     • search_value (string): The value to search for
     • limit_to_view (optional string): Optional view ID to limit search to
   • Returns: Matching records

4. update_record

   • Updates an existing record in an Airtable table
   • Inputs:
     • base_id (string): The ID of the Airtable base
     • table_id (string): The ID of the table within the base
     • record_id (string): The ID of the record to update
     • fields (object): Field values to update in the record
   • Returns: Updated record details

5. upload_file

   • Uploads a file to an attachment column in an Airtable record
   • Inputs:
     • base_id (string): The ID of the Airtable base
     • table_id (string): The ID of the table within the base
     • attachment_column (string): The ID of the attachment column
     • record_id (string): The ID of the record to upload the file to
     • file (object): File object with filename and base64 content
     • file_content_type (string): The MIME type of the file
     • filename (optional string): Optional custom filename for the uploaded file
   • Returns: Upload result details

Environment Variables

The following environment variables are required:

• AIRTABLE_ACCESS_TOKEN: Personal access token for Airtable API authentication

License

This project is licensed under the MIT License - see the LICENSE file for details.