Airtable

List tables in a base

curl -s 'https://api.airtable.com/v0/meta/bases/BASE_ID/tables' \
  -H "Authorization: Bearer $AIRTABLE_PAT"

List records in a table

curl -s 'https://api.airtable.com/v0/BASE_ID/TABLE_NAME?maxRecords=20' \
  -H "Authorization: Bearer $AIRTABLE_PAT"

Filter records

curl -s 'https://api.airtable.com/v0/BASE_ID/TABLE_NAME?filterByFormula=FILTER_FORMULA&maxRecords=20' \
  -H "Authorization: Bearer $AIRTABLE_PAT"

Example filter: filterByFormula=%7BStatus%7D%3D%22Done%22 (URL-encoded {Status}="Done")

Search records (filter by field)

curl -s 'https://api.airtable.com/v0/BASE_ID/TABLE_NAME?filterByFormula=SEARCH%28%22SEARCH_TERM%22%2CNAME_FIELD%29' \
  -H "Authorization: Bearer $AIRTABLE_PAT"

Get a single record

curl -s 'https://api.airtable.com/v0/BASE_ID/TABLE_NAME/RECORD_ID' \
  -H "Authorization: Bearer $AIRTABLE_PAT"

Create a record

curl -s -X POST 'https://api.airtable.com/v0/BASE_ID/TABLE_NAME' \
  -H "Authorization: Bearer $AIRTABLE_PAT" \
  -H "Content-Type: application/json" \
  -d '{"fields": {"Name": "Record name", "Status": "Todo"}}'

Update a record

curl -s -X PATCH 'https://api.airtable.com/v0/BASE_ID/TABLE_NAME/RECORD_ID' \
  -H "Authorization: Bearer $AIRTABLE_PAT" \
  -H "Content-Type: application/json" \
  -d '{"fields": {"Status": "Done"}}'

Delete a record

curl -s -X DELETE 'https://api.airtable.com/v0/BASE_ID/TABLE_NAME/RECORD_ID' \
  -H "Authorization: Bearer $AIRTABLE_PAT"

Rules

• Always use web_fetch or exec with curl to make API calls.
• Base IDs start with app, record IDs start with rec.
• TABLE_NAME can be the table name (URL-encoded) or table ID (starts with tbl).
• Always list bases first if the user hasn't specified one.
• Confirm before deleting records.
• Handle pagination using the offset param returned in responses.