Airtable
Airtable merges spreadsheet functionality with database power, enabling teams to organize projects, track tasks, and collaborate through customizable views, automation, and integrations for data management
Tools (26)
Create base
Creates a new Airtable base with specified tables and fields within a workspace.
Inputs: name, tables, workspaceId
Create Comment
Tool to create a comment on a specific Airtable record. Use when adding comments to records, mentioning collaborators using @[userId] syntax, or creating threaded comment replies. Supports optional parentCommentId for threaded conversations.
Inputs: text, baseId, recordId, tableIdOrName, parentCommentId
Create Field
Creates a new field within a specified table in an Airtable base.
Inputs: name, type, baseId, options, description, tableIdOrName
Create multiple records (Deprecated)
DEPRECATED: Use AIRTABLE_CREATE_RECORDS instead. Creates multiple new records in a specified Airtable table.
Inputs: baseId, records, typecast, tableIdOrName, returnFieldsByFieldId
Create a record (Deprecated)
DEPRECATED: Use CreateRecords instead. Creates a new record in a specified Airtable table; field values must conform to the table's column types.
Inputs: baseId, fields, typecast, tableIdOrName, returnFieldsByFieldId
Create Record From Natural Language
Creates a new record in an Airtable table from a natural language description. Fetches the table schema, uses an LLM to generate the correct field payload, and creates the record with typecast enabled for automatic type conversion.
Inputs: baseId, nl_query, typecast, tableIdOrName
Create records
Tool to create multiple records (up to 10) in a specified Airtable table. Use when you need to add new rows to a table with field values. Rate limit: 5 requests per second per base.
Inputs: baseId, records, typecast, tableIdOrName, returnFieldsByFieldId
Create table
Creates a new table within a specified existing Airtable base, allowing definition of its name, description, and field structure.
Inputs: name, fields, base_id, if_exists, description, reorder_message
Delete Comment
Tool to delete a comment from a record in an Airtable table. Use when you need to remove an existing comment. Non-admin users can only delete their own comments; Enterprise Admins can delete any comment.
Inputs: baseId, recordId, rowCommentId, tableIdOrName
Delete multiple records
Tool to delete up to 10 specified records from a table within an Airtable base. Use when you need to remove multiple records in a single operation.
Inputs: baseId, recordIds, tableIdOrName
Delete Record
Permanently deletes a specific record from an existing table within an existing Airtable base.
Inputs: baseId, recordId, tableIdOrName
Get Attachment Info
Retrieves attachment information from a specific field in an Airtable record. Returns metadata including file URLs, sizes, types, and thumbnails for all attachments in the specified field. Use this action when you need to access file metadata or download URLs for attachments stored in Airtable. Note that attachment URLs expire 2 hours after being retrieved from the API.
Inputs: baseId, recordId, tableIdOrName, attachmentFieldIdOrName
Get Base Schema
Retrieves the detailed schema for a specified Airtable base, including its tables, fields, field types, and configurations, using the `baseId`.
Inputs: baseId, include
Get Record
Retrieves a specific record from an Airtable table by its record ID. Requires a known, valid record ID obtained from listing records or another API call - this tool cannot search or list records. Use the list records tool to find record IDs. Empty field values are not returned in the response.
Inputs: baseId, recordId, timeZone, cellFormat, userLocale, tableIdOrName, returnFieldsByFieldId
Get user information
Retrieves information, such as ID and permission scopes, for the currently authenticated Airtable user from the `/meta/whoami` endpoint.
List bases
Retrieves all Airtable bases accessible to the authenticated user, which may include an 'offset' for pagination.
Inputs: offset
List Comments
Tool to list comments on a specific Airtable record. Use when retrieving comments for a record, with optional pagination support for large comment threads.
Inputs: baseId, offset, pageSize, recordId, tableIdOrName
List records
Tool to list records from an Airtable table with filtering, sorting, and pagination. Use when you need to retrieve multiple records from a table with optional query parameters.
Inputs: sort, view, baseId, fields, offset, pageSize, timeZone, cellFormat, maxRecords, userLocale, tableIdOrName, recordMetadata, filterByFormula, returnFieldsByFieldId
Update Comment
Tool to update an existing comment on a specific Airtable record. Use when modifying comment text or updating user mentions using @[userId] syntax. API users can only update comments they have created.
Inputs: text, baseId, recordId, rowCommentId, tableIdOrName
Update Field
Updates a field's name or description in an Airtable table. Use this action to modify field metadata without changing the field's type or options. At least one of 'name' or 'description' must be provided.
Inputs: name, baseId, fieldId, tableId, description
Update multiple records
Tool to update up to 10 records in an Airtable table with selective field modifications. Use when you need to modify multiple existing records or perform upsert operations. Updates are not performed atomically.
Inputs: baseId, records, typecast, performUpsert, tableIdOrName, returnFieldsByFieldId
Update multiple records (PUT)
Tool to destructively update multiple records in Airtable using PUT, clearing unspecified fields. Use when you need to fully replace record data or perform upsert operations. Supports up to 10 records per request.
Inputs: baseId, records, typecast, performUpsert, tableIdOrName, returnFieldsByFieldId
Update record
Modifies specified fields of an existing record in an Airtable base and table; the base, table, and record must exist.
Inputs: baseId, fields, recordId, typecast, tableIdOrName, returnFieldsByFieldId
Update record (PUT)
Updates an existing record in an Airtable base using PUT method. Use when you want to replace all field values, clearing any unspecified fields. For partial updates that preserve unspecified fields, use the PATCH-based update action instead.
Inputs: baseId, fields, recordId, typecast, tableIdOrName, returnFieldsByFieldId
Update Table
Updates the name, description, and/or date dependency settings of a table in Airtable. Use this action to modify table metadata without changing the table's fields or views. At least one of 'name', 'description', or 'dateDependencySettings' must be provided.
Inputs: name, baseId, description, tableIdOrName, dateDependencySettings
Upload attachment
Uploads a file attachment to a specified field in an Airtable record. Use when you need to add a file to an attachment field. The file must be provided as a base64-encoded string.
Inputs: file, baseId, filename, recordId, contentType, attachmentFieldIdOrName