skills.rest
perasyudha
perasyudhaCOMMUNITY
Explore all skills by this author →
Website𝕏@Nyxora_AIGitHub

airtable

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

5|2|Updated May 26, 2026
Search Tags:#productivity#database#rest api#crud#curl#upsert#airtable
One-click install
npx skills add https://github.com/perasyudha/Nyxora --skill airtable-perasyudha
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/perasyudha/Nyxora/tree/main/packages/core/playbooks/productivity/airtable
Command: npx skills add https://github.com/perasyudha/Nyxora --skill airtable-perasyudha

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 provides direct REST API access via curl so you can read, create, update, upsert, and delete Airtable records with nothing more than a personal access token. ## Core Features & Use Cases - Full Records CRUD: List, get, create, update (PATCH), upsert by merge field, and delete records, including batch operations of up to 10 records per request. - Schema Discovery & Filtering: List bases and table schemas via the meta API, and query records with URL-encoded filterByFormula, sorting, field selection, and named views. - Pagination & Rate-Limit Handling: Loop through offset-based pagination (100 records per page) while respecting the 5 requests/second/base rate limit. - Use Case: Sync a list of new signups into an Airtable CRM table idempotently using performUpsert on the Email field, without creating duplicates. ## 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 via the API?▼

Send a POST to /v0/{baseId}/{table} with a JSON body containing a fields object to create records, or a PATCH to the same URL with a record ID to update. Use performUpsert with fieldsToMergeOn to insert-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 percent-encoded.

What Airtable token do I need for the REST API?▼

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, and each token must be granted access to specific bases.

Why does the Airtable API return 403 on one base but not another?▼

Airtable PATs are scoped per base, so a 403 means the token's Access list does not include that base, not that authentication failed. Edit the token at airtable.com/create/tokens 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; back off when you receive a 429.

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→
HKU-MMLabHKU-MMLab
39

airtable-pat-rest

Read Airtable bases, tables, and records via the official REST API using a personal access token.

Official
Basic
vctplatformvctplatform

data-engineer

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

Community
Advanced
MoCapOnlineMoCapOnline

MCO Airtable → Shopify Sync Skill

Generate Node.js sync scripts to push Airtable product data to Shopify metaobjects and metafields.

Community
Advanced
firebasefirebase
402

firebase-data-connect

Manage and deploy Firebase PostgreSQL databases with GraphQL schemas and SDK generation.

Official
Advanced