skills.rest
jamsdoescode
jamsdoescodeCOMMUNITY
Explore all skills by this author →
GitHub

airtable

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

Updated Jul 7, 2026
Search Tags:#database#rest api#crud#curl#upsert#records#airtable
One-click install
npx skills add https://github.com/jamsdoescode/Erik-s-Portfolio --skill airtable-jamsdoescode
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/jamsdoescode/Erik-s-Portfolio/tree/main/openclicky/AppResources/OpenClicky/OpenClickyBundledSkills/airtable
Command: npx skills add https://github.com/jamsdoescode/Erik-s-Portfolio --skill airtable-jamsdoescode

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 with curl and a personal access token, with no extra tooling. ## 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. - Schema Inspection: List bases and table schemas before mutating data to confirm field names, IDs, and select options. - Use Case: Sync a list of new customers into an Airtable CRM table by upserting on the Email field, so existing contacts are updated and new ones are created in a single idempotent call. ## Quick Start Set the AIRTABLE_API_KEY environment variable to your personal access token, then ask the assistant to list the records in your Airtable 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 API?▼

Send a POST request to /v0/{baseId}/{table} with a JSON body containing a fields object to create records. To update, use PATCH on the record URL, which merges only the supplied fields while preserving the rest.

How do I filter Airtable records with filterByFormula?▼

Pass a URL-encoded Airtable formula such as {Status}='Todo' as the filterByFormula query parameter. Use Python's urllib.parse.quote to encode the formula rather than hand-escaping special characters.

What authentication does the Airtable API require?▼

The Airtable API requires a personal access token starting with pat, sent as a Bearer token in the Authorization header. 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 the base you are querying, since personal access tokens are scoped per base. Add the base to the token at airtable.com/create/tokens to resolve it.

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

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

Related Skills

Explore More Product & Management Skills→
josoromajosoroma
6

airtable

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

Community
Intermediate
hmzainjamilhmzainjamil
1

airtable-automation

Design and automate Airtable bases with schemas, views, formulas, and automations.

Community
Advanced
Greenmamba29Greenmamba29

airtable-etl

Extract, transform, and load data between Airtable bases and external systems.

Community
Intermediate
Monjyu1101Monjyu1101
1

airtable

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

Community
Intermediate