skills.rest
luckybbjason1
luckybbjason1COMMUNITY
Explore all skills by this author →
GitHub

airtable

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

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

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 records directly through curl with 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 with proper URL encoding, sorting, field selection, and named views to retrieve exactly the data you need. - 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 customer emails into an Airtable CRM table using performUpsert on the Email field, so existing contacts are updated and new ones are created idempotently. ## Quick Start Ask the assistant to list the records in your Airtable table or create a new record in a specific base and table 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 create or update records in Airtable via API?▼

Use POST to /v0/{baseId}/{table} with a records array to create up to 10 records, or PATCH with performUpsert and fieldsToMergeOn to update existing records matched on a field like Email. Include typecast: true to auto-create select options.

How do I filter Airtable records with filterByFormula?▼

Pass a formula like {Status}='Todo' as the filterByFormula query parameter, URL-encoded with Python's urllib.parse.quote. Supported patterns include AND/OR conditions, FIND for substring matching, and IS_AFTER for date comparisons.

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

Create a Personal Access Token at airtable.com/create/tokens with data.records:read, data.records:write, and schema.bases:read scopes. You must also add each base to the token's Access list, since PATs are scoped per base.

Why does my Airtable API request return 403 or 429 errors?▼

A 403 usually means the token's Access list does not include that base, not an auth failure. A 429 means you exceeded the 5 requests per second per base rate limit; back off and check the Retry-After header.

What are the Airtable API batch and pagination limits?▼

Batch create and delete endpoints accept at most 10 records per request. List endpoints return at most 100 records per page; loop with the offset parameter until the response no longer includes an offset field.

Related Skills

Explore More Product & Management Skills→
abdullahbeamabdullahbeam
2

airtable-connect

Query, create, update, and delete Airtable records via natural language.

Community
Advanced
AlvaroBianoAlvaroBiano

airtable

Automate Airtable REST API CRUD operations on bases, tables, and records via curl.

Community
Intermediate
ProyectoG007ProyectoG007

api-gateway

Call native endpoints of over 100 third-party APIs via managed OAuth connections.

Community
Advanced
TheViziusGroupTheViziusGroup
1

okta-iga-governance-api

Reference Okta Identity Governance REST API endpoints, OAuth scopes, and tooling constraints.

Official
Intermediate