Claude
Skills
Sign in
Back

airtable

Included with Lifetime
$97 forever

Manage Airtable bases, tables, and records via the REST API.

Backend & APIs

What this skill does


# Airtable

Manage Airtable bases and records via the REST API.

## Environment Variables

- `AIRTABLE_ACCESS_TOKEN` - Personal access token (generate at https://airtable.com/create/tokens)

## List records

```bash
curl -s -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME?maxRecords=20" | jq '.records[] | {id, fields}'
```

## Get record

```bash
curl -s -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME/RECORD_ID" | jq '{id, fields}'
```

## Create record

```bash
curl -s -X POST -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME" \
  -d '{"records":[{"fields":{"Name":"New record","Status":"Active"}}]}' | jq '.records[] | {id, fields}'
```

## Update record

```bash
curl -s -X PATCH -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME" \
  -d '{"records":[{"id":"RECORD_ID","fields":{"Status":"Done"}}]}' | jq '.records[] | {id, fields}'
```

## Delete record

```bash
curl -s -X DELETE -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/BASE_ID/TABLE_NAME/RECORD_ID" | jq '{id, deleted}'
```

## List bases

```bash
curl -s -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/meta/bases" | jq '.bases[] | {id, name, permissionLevel}'
```

## Get base schema

```bash
curl -s -H "Authorization: Bearer $AIRTABLE_ACCESS_TOKEN" \
  "https://api.airtable.com/v0/meta/bases/BASE_ID/tables" | jq '.tables[] | {id, name, fields: [.fields[] | {id, name, type}]}'
```

Related in Backend & APIs