Tools

Upsert Records

Find, create, or update records in a single operation. Records are matched using the specified merge fields. If a matching record is found it will be updated; otherwise a new record is created. This is useful for syncing data from external sources.

List Bases

List all Airtable bases the authenticated user has access to. Useful for discovering available bases and their IDs.

Manage Field

Create a new field or update an existing field in a table within the configured Airtable base. Supports setting field type, name, description, and type-specific options.

Get Base Schema

Retrieve the full schema of the configured Airtable base, including all tables, their fields (with types and options), and views. Useful for understanding the structure of a base before querying or modifying data.

List Records

List records from a table in the configured Airtable base. Supports filtering with Airtable formulas, sorting by fields, scoping to a specific view, selecting specific fields, and pagination.

Manage Comment

List, create, update, or delete comments on a record in the configured Airtable base. Use this to read the conversation thread on a record or add new comments.

Get Record

Retrieve a single record by its ID from a table in the configured Airtable base. Returns all field values for the specified record.

Update Records

Update one or more existing records in a table in the configured Airtable base. By default performs a partial update (PATCH) that only modifies specified fields. Set **replaceAllFields** to true to perform a full replacement (PUT) which clears unspecified fields.

Create Records

Create one or more records in a table in the configured Airtable base. Provide field values for each record. Enable typecast to automatically convert string values to the appropriate field types.

Manage Table

Create a new table or update an existing table in the configured Airtable base. When creating, provide the table name and initial fields. When updating, provide the table ID and new name or description.

Delete Records

Delete one or more records from a table in the configured Airtable base. This action is **irreversible** and permanently removes the specified records.