airtable

Manage Airtable bases, tables, and records via REST API curl commands.

Updated May 4, 2026
One-click install
npx skills add https://github.com/Junkfooooood/hermes-governance --skill airtable-junkfooooood
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/Junkfooooood/hermes-governance/tree/main/skills/productivity/airtable
Command: npx skills add https://github.com/Junkfooooood/hermes-governance --skill airtable-junkfooooood

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Working with Airtable data programmatically often requires SDKs, OAuth flows, or MCP servers. This Skill lets you perform full CRUD operations on Airtable records directly through curl with just a personal access token, covering filtering, sorting, upserts, batch operations, and pagination. ## Core Features & Use Cases - Records CRUD: Create, read, update (PATCH), upsert, and delete records individually or in batches of up to 10 per request. - Filtering & Querying: Use filterByFormula, sorting, field selection, and named views with proper URL encoding handled via Python stdlib. - Schema Inspection: List accessible bases and table schemas before mutating data to confirm exact field names and select options. - Use Case: Sync a list of customer emails into an Airtable CRM table using performUpsert on the Email field, creating new rows and updating existing ones idempotently in a single batch call. ## Quick Start Ask the assistant to list the records in your Airtable table or update a specific record's status using your AIRTABLE_API_KEY.

Frequently Asked Questions about airtable

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I update an Airtable record via the REST API?

Send a PATCH request to https://api.airtable.com/v0/$BASE_ID/$TABLE/$RECORD_ID with a JSON body containing the fields to change. PATCH merges only the supplied fields, while PUT replaces the entire record and clears omitted fields.

How to filter Airtable records with filterByFormula?

Pass a URL-encoded Airtable formula as the filterByFormula query parameter, such as {Status}='Todo' or AND({Status}='Todo', {Priority}='High'). Always encode the formula with a tool like Python's urllib.parse.quote rather than hand-escaping.

Why does my Airtable API token return a 403 error?

A 403 usually means the personal access token's Access list does not include that specific base, since PATs are scoped per-base. Add the base to the token at airtable.com/create/tokens rather than changing scopes.

Does the Airtable API support upserting records?

Yes, send a PATCH request to the table endpoint with performUpsert specifying fieldsToMergeOn, such as Email. Records with new merge-field values are created while existing matches are updated, enabling idempotent syncs.

What are the Airtable API rate limits and pagination limits?

The API allows 5 requests per second per base and returns at most 100 records per page. When a response includes an offset field, pass it back on the next request and loop until the field is absent.