kayforkind/skill-slice/airtable
Claude Code and agent skill by kayforkind/skill-slice
- community
Checking that the SKILL.md file is still in the repository.
Talks to Airtable's REST API with curl and a personal access token: list/filter records, schema inspect, batch CRUD, and performUpsert syncs. Use when the user wants to read, create, update, delete, or idempotently sync rows in an Airtable base (app/tbl/rec IDs). Not for the Airtable web UI, OAuth MCP servers, or the Python SDK; do not use deprecated key-prefixed API keys.
Install
npx vskill@latest install kayforkind/skill-slice/airtableSKILL.md
The same SKILL.md was published earlier as kayforkind/skill-slice/airtable.
Airtable — Bases, Tables & Records
Work with Airtable's REST API directly via curl using the terminal tool. No MCP server, no OAuth flow, no Python SDK — just curl and a personal access token.
When to Use
- User asks to read, list, filter, or search Airtable records.
- User asks to create, update, upsert, or delete records in an Airtable base.
- User asks to inspect base/table schema (field names, types, select options).
- User asks to sync data into or out of Airtable (idempotent upserts, batch inserts).
- User mentions "Airtable", "base", "table", "records", or references an
app.../tbl.../rec...ID.
Prerequisites
- Create a Personal Access Token (PAT) at https://airtable.com/create/tokens (tokens start with
pat...). - Grant these scopes (minimum):
data.records:read— read rowsdata.records:write— create / update / delete rowsschema.bases:read— list bases and tables
- Important: in the same token UI, add each base you want to access to the token's Access list. PATs are scoped per-base — a valid token on the wrong base returns
403. - Store the token in
${HERMES_HOME:-~/.hermes}/.env(or viahermes setup):
`` AIRTABLE_API_KEY=pat_your_token_here ` On Windows PowerShell, the equivalent home path is $env:USERPROFILE\.hermes\.env`.
Note: legacykey...API keys were deprecated Feb 2024. Only PATs and OAuth tokens work now.
API Basics
- Endpoint:
https://api.airtable.com/v0 - Auth header:
Authorization: Bearer $AIRTABLE_API_KEY - All requests use JSON (
Content-Type: application/jsonfor any POST/PATCH/PUT body). - Object IDs: bases
app..., tablestbl..., recordsrec..., fieldsfld.... IDs never change; names can. Prefer IDs in automations. - Rate limit: 5 requests/sec/base.
429→ back off. Burst on a single base will be throttled.
Base curl pattern (bash):
PowerShell equivalent:
-s suppresses curl's progress bar — keep it set for every call so the tool output stays clean. Pipe through python3 -m json.tool (always present) or jq (if installed) for readable JSON.
Field Types (request body shapes)
| Field type | Write shape | |
|---|---|---|
| Single line text | "Name": "hello" | |
| Long text | "Notes": "multi\nline" | |
| Number | "Score": 42 | |
| Checkbox | "Done": true | |
| Single select | "Status": "Todo" (name must already exist unless typecast: true) | |
| Multi-select | "Tags": ["urgent", "bug"] | |
| Date | "Due": "2026-04-01" | |
| DateTime (UTC) | "At": "2026-04-01T14:30:00.000Z" | |
| URL / Email / Phone | "Link": "https://…" | |
| Attachment | "Files": [{"url": "https://…"}] (Airtable fetches + rehosts) | |
| Linked record | "Owner": ["recXXXXXXXXXXXXXX"] (array of record IDs) | |
| User | "AssignedTo": {"id": "usrXXXXXXXXXXXXXX"} |
Pass "typecast": true at the top level of a create/update body to let Airtable auto-coerce values (e.g. create a new select option on the fly, convert "42" → 42).
Procedure
Step 1 — Confirm auth
Expect 200. If 401, the token is invalid or expired. If 403, the token lacks schema.bases:read scope or the base isn't in the token's Access list.
Step 2 — Find the base
List bases the token can see:
If the token lacks schema.bases:read, ask the user for the app... ID directly.
Step 3 — Inspect the schema (always before mutating)
Use this BEFORE mutating — confirms exact field names and IDs, surfaces options.choices for select fields, and shows primary-field names. Cache these locally in the session.
Step 4 — Read before you write
For "update X where Y", use filterByFormula first to resolve the rec... ID, then PATCH. Never guess record IDs.
Step 5 — Execute the operation
Choose from the common queries and mutations below.
Common Queries
List records (first 10)
Get a single record
Filter records (filterByFormula)
Airtable formulas must be URL-encoded. Let Python stdlib do it — never hand-encode:
Useful formula patterns:
- Exact match:
{Email}='user@example.com' - Contains:
FIND('bug', LOWER({Title})) - Multiple conditions:
AND({Status}='Todo', {Priority}='High') - Or:
OR({Owner}='alice', {Owner}='bob') - Not empty:
NOT({Assignee}='') - Date comparison:
IS_AFTER({Due}, TODAY())
Sort + select specific fields
Square brackets in query params MUST be URL-encoded (%5B / %5D).
Use a named view
Views apply their saved filter + sort server-side.
Common Mutations
Create a record
Create up to 10 records in one call
Batch endpoints are capped at 10 records per request. For larger inserts, loop in batches of 10 with a short sleep to respect 5 req/sec/base.
Update a record (PATCH — merges, preserves unchanged fields)
Upsert by a merge field (no ID needed)
performUpsert creates records whose merge-field values are new, patches records whose merge-field values already exist. Great for idempotent syncs.
Delete a record
Delete up to 10 records in one call
Pagination
List endpoints return at most 100 records per page. If the response includes "offset": "...", pass it back on the next call. Loop until the field is absent:
Typical Workflow
- Confirm auth.
curl -s -o /dev/null -w "%{http_code}\n" https://api.airtable.com/v0/meta/bases -H "Authorization: Bearer $AIRTABLE_API_KEY"— expect200. - Find the base. List bases (step above) OR ask the user for the
app...ID directly if the token lacksschema.bases:read. - Inspect the schema.
GET /v0/meta/bases/$BASE_ID/tables— cache the exact field names and primary-field name locally in the session before mutating anything. - Read before you write. For "update X where Y",
filterByFormulafirst to resolve therec...ID, thenPATCH /v0/$BASE_ID/$TABLE/$RECORD_ID. Never guess record IDs. - Batch writes. Combine related creates into one 10-record POST to stay under the 5 req/sec budget.
- Destructive ops. Deletions can't be undone via API. If the user says "delete all Xs", echo back the filter + record count and confirm before firing.
Pitfalls
This is the start of the file. Read the full SKILL.md on GitHub.
Security
- Security scanPassed, 95 of 100Pattern checks on the skill's files.
- Model reviewPassed
Quality evaluation
- Task evaluationNot runNo evaluation yet. Run one in Skill Studio.
Source
- SKILL.md in the repositoryCheckingskills/airtable/SKILL.md
Popularity
- 7-day trend score
- 5
Not refreshed yet.
Works with
Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.
- Claude Code
- Cursor
- GitHub Copilot
- Windsurf
- Codex
- Gemini CLI
- Cline
- Amp
- Roo Code
- Goose
- Continue
- Kilo Code
- Junie
- Trae
- OpenHands
- Qwen Code
- AI Agent
- Tabnine Chat
- Sourcegraph Cody
- Amazon Q
- Firebase Genkit
- Sweep
- Devin
- Phind
- Mentat
- Claude Desktop
- Aider
- GPT Pilot
- Plandex
- bolt.new
- v0
- Replit Agent
- Anse
- TypingMind
- BetterChatGPT
- LibreChat
- Warp AI
- Pieces
- Fig AI
Embed badge
[](https://verified-skill.com/skills/kayforkind/skill-slice/airtable)