skills.rest
josoroma
josoromaCOMMUNITY
Explore all skills by this author →
GitHub

airtable

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

6|Updated Jul 12, 2026
Search Tags:#database#rest api#crud#curl#upsert#records#airtable
One-click install
npx skills add https://github.com/josoroma/AppLoop --skill airtable-josoroma
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/josoroma/AppLoop/tree/main/.hermes/skills/productivity/airtable
Command: npx skills add https://github.com/josoroma/AppLoop --skill airtable-josoroma

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Working with Airtable data programmatically usually requires SDKs, OAuth flows, or MCP servers. This Skill lets you perform full CRUD operations on Airtable bases, tables, and records directly through the REST API using curl and a personal access token, with no extra infrastructure. ## Core Features & Use Cases - Records CRUD and batch operations: Create, read, update (PATCH), upsert, and delete records, including batches of up to 10 records per request. - Filtering, sorting, and pagination: Query records with URL-encoded filterByFormula expressions, named views, field selection, and offset-based pagination loops. - Schema inspection: List accessible bases and table schemas before mutating data to confirm exact field names, IDs, and select options. - Use Case: Sync a list of new signups into an Airtable CRM table by upserting on the Email field, so existing contacts are patched and new ones are created idempotently. ## Quick Start Ask the agent to list the tables in your Airtable base and show the first ten records from a specific table.

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?▼

Send a POST to /v0/{baseId}/{table} with a JSON body containing a fields object to create records, or a PATCH to the record URL to merge updates. Use performUpsert with fieldsToMergeOn to create-or-update by a key field like Email.

How do I filter Airtable records with filterByFormula?▼

Pass a URL-encoded Airtable formula such as {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-prefixed API keys were deprecated in February 2024 and no longer work.

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 personal access tokens are scoped per base. Revisit the token settings at airtable.com/create/tokens and add the base to the token's access list.

What are the Airtable API rate limits and record batch limits?▼

The API allows 5 requests per second per base and returns 429 with a Retry-After header when throttled. Batch create and delete endpoints accept at most 10 records per request, and list endpoints return at most 100 records per page.

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

Use PATCH, which merges only the supplied fields and preserves everything else. 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→
mrmtsuruyamrmtsuruya

airtable

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

Community
Intermediate
vctplatformvctplatform

data-engineer

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

Community
Advanced
abdullahbeamabdullahbeam
2

airtable-master

Centralize shared Airtable resources and common logic across integration skills.

Community
Advanced
vikrant-projectvikrant-project
2

airtable

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

Community
Intermediate