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

Base and Schema Tools

list_bases

Retrieves the list of accessible Airtable bases.

get_base_schema

Gets table, field, and view information for a specific base.

Record Management Tools

list_records

Retrieves the list of records from a table.

get_record

Gets detailed information of a specific record.

create_record

Creates a new record.

update_records

Updates multiple records at once.

delete_records

Deletes multiple records at once.

Search and Filtering Tools

search_records

Searches records containing specific text.

Usage Examples

For example,

• When you input “Query ongoing tasks from the project management table” as a prompt,
• The LLM calls the list_records or search_records tool through MCP to retrieve related records.
• 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 list_records tool and analyzes the results.

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.