skills.rest
vivekgoquest
vivekgoquestCOMMUNITY
Explore all skills by this author →
GitHub

airtable

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

Updated Aug 22, 2026
Search Tags:#database#CRUD#REST API#curl#upsert#airtable#filterByFormula
One-click install
npx skills add https://github.com/vivekgoquest/hermes-agent-stable --skill airtable-vivekgoquest
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/vivekgoquest/hermes-agent-stable/tree/main/skills/productivity/airtable
Command: npx skills add https://github.com/vivekgoquest/hermes-agent-stable --skill airtable-vivekgoquest

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Working with Airtable data from an agent or terminal normally requires an SDK, OAuth setup, or manual dashboard clicks. This Skill lets you perform full CRUD operations on Airtable records directly through the REST API using curl and a personal access token. ## Core Features & Use Cases - Records CRUD: Create, read, update (PATCH), upsert, and delete records, including batch operations of up to 10 records per request. - Filtering & Querying: Use filterByFormula, sorting, field selection, and named views to retrieve exactly the rows you need, with offset-based pagination for large tables. - Schema Inspection: List accessible bases and table schemas before mutating data to confirm field names, IDs, and select options. - Use Case: Sync a list of new leads into a CRM table by upserting on the Email field, so existing contacts are updated and new ones are created idempotently. ## Quick Start Use the airtable skill to list all records in my Tasks table where Status is Todo.

Frequently Asked Questions about airtable

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

FAQPage Schema
How do I create or update Airtable records with the REST API?▼

Create records with a POST to /v0/{baseId}/{table} containing a fields object, and update with PATCH to merge changes without clearing other fields. For idempotent syncs, use performUpsert with fieldsToMergeOn such as Email.

How to filter Airtable records using filterByFormula?▼

Pass a URL-encoded Airtable formula like {Status}='Todo' as the filterByFormula query parameter. Encode it with Python's urllib.parse.quote rather than hand-escaping, since field names with spaces or braces must be encoded.

What Airtable API token do I need and what scopes?▼

You need a Personal Access Token starting with pat, created at airtable.com/create/tokens, with data.records:read, data.records:write, and schema.bases:read scopes. Legacy key... API keys were deprecated in February 2024.

Why does my Airtable API request return a 403 error?▼

A 403 usually means the token's Access list does not include that specific base, since PATs are scoped per-base. Reopen the token settings and add the base to its Access list.

What are the Airtable API rate limits and pagination rules?▼

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 it is absent.

Should I use PATCH or PUT to update Airtable records?▼

Use PATCH, which merges only the supplied fields into the record. PUT replaces the entire record and clears any field you did not include, so it is risky for partial updates.

Related Skills

Explore More Product & Management Skills→
GreenyZAGreenyZA

airtable

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

Community
Intermediate
vctplatformvctplatform

data-engineer

Design and implement data pipelines and reporting for the VCT Platform.

Community
Advanced
Duckshot-ProductionsDuckshot-Productions

sync-debug

Diagnose failing Notion worker syncs by inspecting run logs and cross-referencing sync code.

Official
Intermediate
vikrant-projectvikrant-project
2

airtable

Manage Airtable records via curl with CRUD, filtering, and upserts.

Community
Intermediate