Airtable
14 actions for bases, tables, and records. Supports batch operations.
Discovery
search
Search across all accessible bases and tables.
| Parameter | Type | Required | Description |
|---|---|---|---|
query | string | yes | Search query |
list_bases
List all accessible Airtable bases.
get_base
Get base metadata including tables.
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
Tables
list_tables
List tables in a base.
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
get_table
Get table schema (fields, views).
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
create_table
Create a new table in a base.
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
name | string | yes | Table name |
fields | array | yes | Field definitions |
Records
list_records
List records from a table.
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
maxRecords | number | no | Max records to return |
filterByFormula | string | no | Airtable formula filter |
sort | array | no | Sort configuration |
view | string | no | View name or ID |
exec("airtable.list_records", {
baseId: "appXXXXXX",
tableId: "Tasks",
filterByFormula: "{Status} = 'In Progress'",
maxRecords: 50
})get_record
Get a single record by ID.
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
recordId | string | yes | Record ID |
create_record
Create a record.
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
fields | object | yes | Field values |
exec("airtable.create_record", {
baseId: "appXXXXXX",
tableId: "Tasks",
fields: { "Name": "New task", "Status": "To Do", "Assignee": "Alice" }
})update_record
Update a record.
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
recordId | string | yes | Record ID |
fields | object | yes | Fields to update |
delete_record
Delete a record.
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
recordId | string | yes | Record ID |
Batch Operations
batch_create_records
Create multiple records at once (max 10).
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
records | array | yes | Array of { fields: {...} } objects |
batch_update_records
Update multiple records at once (max 10).
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
records | array | yes | Array of { id, fields } objects |
batch_delete_records
Delete multiple records at once (max 10).
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | yes | Base ID |
tableId | string | yes | Table ID or name |
recordIds | array | yes | Array of record IDs |