skills.rest
JamesFincher
JamesFincherCOMMUNITY
Explore all skills by this author →
GitHub

airtable

Perform CRUD operations and schema discovery on Airtable via REST API.

Updated May 4, 2026
Search Tags:#rest api#pagination#upsert#airtable#database automation#filterbyformula#records crud
One-click install
npx skills add https://github.com/JamesFincher/gengar --skill airtable-jamesfincher
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/JamesFincher/gengar/tree/main/skills/productivity/airtable
Command: npx skills add https://github.com/JamesFincher/gengar --skill airtable-jamesfincher

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve?

This Skill removes the friction of manually interacting with Airtable by letting you perform reliable CRUD operations on Bases, Tables, and Records directly through the Airtable REST API.

Core Features & Use Cases

  • Bases, Tables & Records via API: Discover available bases and table schemas, then list, read, create, update, upsert, and delete records.
  • Safe querying and updates: Use filterByFormula (properly URL-encoded) to resolve record IDs before patching, and batch writes for throughput.
  • Production-friendly handling: Supports rate-limit awareness, pagination with offset, and common Airtable pitfalls like single-select option mismatches.

Quick Start

Use the airtable skill to list the first records from your table in the base you have granted access to.

Frequently Asked Questions about airtable

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

FAQPage Schema
How do I create and update Airtable records using the REST API?▼

Perform CRUD operations on Airtable records via curl calls by sending JSON requests with a valid AIRTABLE_API_KEY personal access token. The API supports create, patch update, upsert, and delete operations for batch writes.

What is the best way to query Airtable records with filterByFormula?▼

Querying Airtable records with filterByFormula requires proper URL-encoding of formula values to resolve record IDs. You can combine this with sorting, selecting specific fields, and listing records with pagination offset.

Do I need a specific token to automate Airtable database operations via curl?▼

Yes, automating Airtable database operations requires a valid AIRTABLE_API_KEY personal access token. You must include this token in your curl calls to handle JSON requests and responses for record CRUD operations.

How does pagination work when listing Airtable records through the API?▼

Pagination when listing Airtable records works by using an offset parameter returned in the API response. This production-friendly handling allows you to retrieve subsequent pages of records until all data is listed.

Why does my Airtable API patch update fail with single-select option mismatches?▼

Airtable API patch updates can fail due to single-select option mismatches when the submitted value does not match existing table schema options. Safe querying and proper schema discovery help avoid these common pitfalls.

Related Skills

Explore More Data & Analytics Skills→
carterwayneskhizeinecarterwayneskhizeine
19

airtable

Perform Airtable CRUD and filtered queries via the REST API with curl.

Community
Intermediate
matthew-johnsonmatthew-johnson

airtable

Automate Airtable REST API CRUD operations with curl.

Community
Intermediate
davpatel605-beepdavpatel605-beep

airtable

Manage Airtable records and schemas via authenticated REST API requests.

Community
Intermediate
zaiyemeiyou404zaiyemeiyou404

airtable

Automate Airtable record CRUD operations via curl against the REST API.

Community
Advanced