How do I install the Airtable skill?

Run npx skillmds@latest add qhkm/airtable in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

What does the Airtable skill do?

Read, create, update, and delete Airtable records via the REST API. It is listed under Integrations & APIs on SkillMD.

Is Airtable safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Airtable?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Airtable free to use?

Yes. Installing skills from SkillMD is free. This skill is licensed under MIT.

Who published Airtable?

qhkm (@qhkm) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Airtable by qhkm — Agent Skill

Name: Airtable
Author: qhkm

File contents

Airtable Skill

CRUD operations on Airtable bases using the REST API.

Setup

Go to airtable.com/create/tokens → Create Token
Grant data.records:read and data.records:write scopes
Get your Base ID from the URL: airtable.com/appXXXXXX/tblYYYYYY

export AIRTABLE_TOKEN="patXXX.xxx..."
export AIRTABLE_BASE_ID="appXXXXXX"
export AIRTABLE_TABLE_NAME="Tasks"

List Records

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

Filter with formula:

curl -s "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME" \
  -H "Authorization: Bearer $AIRTABLE_TOKEN" \
  --data-urlencode "filterByFormula={Status}='Active'" \
  | jq '.records[] | {id, name: .fields.Name, status: .fields.Status}'

Create a Record

curl -s -X POST "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME" \
  -H "Authorization: Bearer $AIRTABLE_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "records": [{
      "fields": {
        "Name": "New Item",
        "Status": "Todo",
        "Priority": "High"
      }
    }]
  }' | jq '.records[0] | {id, fields: .fields}'

Update a Record

RECORD_ID="recXXXXXX"
curl -s -X PATCH "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME" \
  -H "Authorization: Bearer $AIRTABLE_TOKEN" \
  -H "Content-Type: application/json" \
  -d "{
    \"records\": [{
      \"id\": \"$RECORD_ID\",
      \"fields\": {\"Status\": \"Done\"}
    }]
  }" | jq '.records[0].fields'

Delete a Record

RECORD_ID="recXXXXXX"
curl -s -X DELETE "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME?records[]=$RECORD_ID" \
  -H "Authorization: Bearer $AIRTABLE_TOKEN" \
  | jq '.records[0]'

Tips

Field names are case-sensitive and must match your table exactly
Batch operations: up to 10 records per create/update/delete request
Rate limit: 5 requests per second per base
Use offset from response for pagination (Airtable returns 100 records max)
Formula syntax: {FieldName}='value' (curly braces around field names)

---name: airtabledescription: Read, create, update, and delete Airtable records via the REST API.license: MIT---# Airtable SkillCRUD operations on Airtable bases using the REST API.## Setup1. Go to [airtable.com/create/tokens](https://airtable.com/create/tokens) → Create Token2. Grant `data.records:read` and `data.records:write` scopes3. Get your Base ID from the URL: `airtable.com/`**`appXXXXXX`**`/tblYYYYYY````bashexport AIRTABLE_TOKEN="patXXX.xxx..."export AIRTABLE_BASE_ID="appXXXXXX"export AIRTABLE_TABLE_NAME="Tasks"```## List Records```bashcurl -s "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME?maxRecords=20" \ -H "Authorization: Bearer $AIRTABLE_TOKEN" \ | jq '.records[] | {id, fields: .fields}'```Filter with formula:```bashcurl -s "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME" \ -H "Authorization: Bearer $AIRTABLE_TOKEN" \ --data-urlencode "filterByFormula={Status}='Active'" \ | jq '.records[] | {id, name: .fields.Name, status: .fields.Status}'```## Create a Record```bashcurl -s -X POST "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME" \ -H "Authorization: Bearer $AIRTABLE_TOKEN" \ -H "Content-Type: application/json" \ -d '{ "records": [{ "fields": { "Name": "New Item", "Status": "Todo", "Priority": "High" } }] }' | jq '.records[0] | {id, fields: .fields}'```## Update a Record```bashRECORD_ID="recXXXXXX"curl -s -X PATCH "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME" \ -H "Authorization: Bearer $AIRTABLE_TOKEN" \ -H "Content-Type: application/json" \ -d "{ \"records\": [{ \"id\": \"$RECORD_ID\", \"fields\": {\"Status\": \"Done\"} }] }" | jq '.records[0].fields'```## Delete a Record```bashRECORD_ID="recXXXXXX"curl -s -X DELETE "https://api.airtable.com/v0/$AIRTABLE_BASE_ID/$AIRTABLE_TABLE_NAME?records[]=$RECORD_ID" \ -H "Authorization: Bearer $AIRTABLE_TOKEN" \ | jq '.records[0]'```## Tips- Field names are case-sensitive and must match your table exactly- Batch operations: up to 10 records per create/update/delete request- Rate limit: 5 requests per second per base- Use `offset` from response for pagination (Airtable returns 100 records max)- Formula syntax: `{FieldName}='value'` (curly braces around field names)

Frequently asked questions

Airtable