AirTable

Connect with AirTable to utilize a database-based collaboration platform.

Key Features

• Table and record management
• Field and view management
• Attachment and image processing
• Automation and workflow integration
• Team collaboration and permission management
• API-based data manipulation

Basic Information

Authentication Method

Uses API Token for authentication.

Input Parameters

• api_key (Required): AirTable API key
• base_id (Required): AirTable base ID
• table_name (Required): Table name to work with

Supported MCP Tools

Record Management Tools

get_records

Retrieves all records from a table.

get_record

Gets detailed information of a specific record.

create_record

Creates a new record.

update_record

Modifies an existing record.

delete_record

Deletes a record.

batch_create_records

Creates multiple records at once.

batch_update_records

Updates multiple records at once.

batch_delete_records

Deletes multiple records at once.

Table Management Tools

list_tables

Retrieves list of all tables in a base.

get_table_schema

Gets schema information of a table.

create_table

Creates a new table.

update_table

Modifies table properties.

delete_table

Deletes a table.

Field Management Tools

list_fields

Retrieves list of all fields in a table.

create_field

Creates a new field.

update_field

Modifies field properties.

delete_field

Deletes a field.

View Management Tools

list_views

Retrieves list of all views in a table.

get_view

Gets detailed information of a specific view.

create_view

Creates a new view.

update_view

Modifies view properties.

delete_view

Deletes a view.

Attachment Management Tools

upload_attachment

Uploads a file and attaches it as an attachment.

download_attachment

Downloads an attachment.

delete_attachment

Deletes an attachment.

Search and Filtering Tools

search_records

Searches records based on conditions.

filter_records

Retrieves records using filter conditions.

sort_records

Retrieves records using sort conditions.

Usage Examples

For example,

• When you input “Query ongoing tasks from the project management table” as a prompt,
• The LLM calls the filter_records tool through MCP to filter and retrieve records with “In Progress” status.
• Then, it responds in the chat based on the tool call results.

Record Creation and Modification

• Prompt: “Add new customer information to the project table”
• The LLM creates a new record using the create_record tool and inputs necessary field information.

Data Analysis and Summary

• Prompt: “Show statistics of completed tasks this month”
• The LLM queries completed tasks using the filter_records tool and analyzes detailed data using the get_records tool.

API Token Generation Method

1. Log in to your AirTable account.
2. Navigate to the Account page.
3. Click “Create new token” in the Personal access tokens section.
4. Enter a token name and select required permissions.
5. Click the “Create token” button to generate the token.
6. Save the generated token in a secure location.

Notes

• API Token is sensitive information and must be stored securely.
• Table schema changes may affect existing data.
• Be careful of API limits when processing large amounts of data.
• Check file size limits when uploading attachments.