airtable

Read and write Airtable bases, tables, and records via REST API with curl.

12|2|Updated Feb 2, 2020
One-click install
npx skills add https://github.com/servitola/dotfiles --skill airtable-servitola
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/servitola/dotfiles/tree/main/claude-code/skills/airtable
Command: npx skills add https://github.com/servitola/dotfiles --skill airtable-servitola

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Managing Airtable data from the command line eliminates the need to switch to the web UI, enabling repeatable, auditable CRUD interactions with bases, tables, and records through the REST API using curl. This Skill provides guidance on authenticating with a Personal Access Token (PAT), composing JSON payloads, and handling common tasks like listing bases, reading records, creating, updating, and deleting records, all with curl and proper error handling.

Core Features & Use Cases

  • REST API CRUD access to bases, tables, and records via curl for automation-friendly workflows.
  • Filter and pagination support with filterByFormula, sorting, and page-based retrieval to scale queries.
  • Batch upserts and updates enabling idempotent syncs across bases and tables using JSON payloads.
  • Operational safety guidance on rate limits, token scoping, and error codes to recover gracefully.

Quick Start

Export your PAT as AIRTABLE_API_KEY and run a curl command to read or modify a base, table, or record.

Frequently Asked Questions about airtable

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

FAQPage Schema
How do I use curl to read and write Airtable records via the REST API?

Use curl to send REST API requests to Airtable bases, tables, and records for CRUD operations. You need a Personal Access Token (PAT) provided as AIRTABLE_API_KEY, and you must include standard headers and JSON payloads to read or write data.

How does filterByFormula work for querying Airtable records with curl?

FilterByFormula filters Airtable records by evaluating a formula expression against each record via the REST API. When using curl, you include this parameter in your request URL to query specific records, and you can combine it with sorting and page-based pagination to scale your queries.

Can I perform batch upserts and updates across Airtable bases using curl?

Yes, you can perform batch upserts and updates across Airtable bases and tables using curl. You achieve this by sending JSON payloads to the REST API, enabling idempotent syncs for creating or updating multiple records simultaneously without manual web UI interaction.

Do I need a Personal Access Token to automate Airtable data management from the command line?

Yes, a Personal Access Token (PAT) is required to automate Airtable data management from the command line. You must export it as AIRTABLE_API_KEY to authenticate your curl requests, and you should ensure proper token scoping to maintain operational safety.

What are the limitations when automating Airtable CRUD operations with curl?

Limitations when automating Airtable CRUD operations with curl include per-base rate limits and specific error codes you must handle to recover gracefully. You need to respect these operational boundaries and manage page-based pagination to scale large data retrieval safely.

What is the best way to manage Airtable data without switching to the web UI?

The best way to manage Airtable data without the web UI is using curl REST API commands for repeatable, auditable CRUD operations. This approach allows you to list bases, query records, and batch update data directly from the command line with proper JSON payloads.