Create and manage databases and projects with Airtable
The Airtable integration enables comprehensive database management including listing bases, exploring table schemas, retrieving records with advanced filtering, and creating new records. You can work with different field types including text, select options, collaborators, and more. The integration supports powerful filtering with formulas, pagination for large datasets, and bulk record creation. Perfect for teams managing structured data, project tracking, and collaborative databases with rich field types and relationships.
Required:
action
- The operation you want to perform (list_bases, get_schema, list_records, create_records, filter_records)Optional:
base_id
- Base identifier for base-specific operationstable_name
- Table name or ID for table operationsfilter_formula
- Formula for filtering recordsRetrieve all accessible Airtable bases
Parameters:
action
(required) - Set to “list_bases”Example:
Response:
Retrieve the schema for a specific base including tables and fields
Parameters:
action
(required) - Set to “get_schema”base_id
(required) - Base identifierExample:
Response:
Retrieve records from a specific table
Parameters:
action
(required) - Set to “list_records”base_id
(required) - Base identifiertable_name
(required) - Table name or IDpage_size
(optional) - Number of records per page (max 100, default 100)max_records
(optional) - Maximum total records to returnview
(optional) - Specific view name or IDsort
(optional) - Array of sort criteria with field and directionfields
(optional) - Specific field names to includeExample:
Response:
Retrieve records using a filter formula
Parameters:
action
(required) - Set to “filter_records”base_id
(required) - Base identifiertable_name
(required) - Table name or IDfilter_formula
(required) - Airtable formula for filtering (e.g., ”=‘In progress’”)Example:
Response:
Create one or more new records in a table
Parameters:
action
(required) - Set to “create_records”base_id
(required) - Base identifiertable_name
(required) - Table name or IDrecords
(required) - Array of record objects with fieldstypecast
(optional) - Boolean for automatic data conversion (default: false)Example:
Response:
Airtable uses app-prefixed base IDs (appXXXXXXXXXXXXXX) and rec-prefixed record IDs. Table names and table IDs can be used interchangeably. Field types include singleLineText, multilineText, singleSelect, multipleSelect, singleCollaborator, and many others. Filter formulas use Airtable’s formula syntax with field names in curly braces like =‘Done’. The typecast option enables automatic data conversion from strings to appropriate field types. Pagination is supported with pageSize (max 100) and offset parameters. Views can filter and sort records according to predefined configurations. All field names are case-sensitive and must match exactly as defined in the base schema.