airtable

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

1|Updated Jun 24, 2026
One-click install
npx skills add https://github.com/maopujie10-sys/Bailongma --skill airtable-maopujie10-sys
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/maopujie10-sys/Bailongma/tree/main/skills/hermes-skills/productivity/airtable
Command: npx skills add https://github.com/maopujie10-sys/Bailongma --skill airtable-maopujie10-sys

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Working with Airtable data programmatically often requires SDKs, OAuth flows, or MCP servers. This Skill lets you perform full CRUD operations on Airtable records directly through the REST API using curl and a personal access token, with no extra infrastructure. ## Core Features & Use Cases - Records CRUD: Create, read, update (PATCH merge), upsert by merge field, and delete records individually or in batches of up to 10. - Filtering & Querying: Use filterByFormula, sorting, field selection, named views, and offset-based pagination to retrieve exactly the data you need. - Schema Inspection: List accessible bases and table schemas before mutating, confirming field names, select options, and primary fields. - Use Case: Sync a list of customer emails into an Airtable CRM table idempotently using performUpsert on the Email field, avoiding duplicate rows. ## Quick Start Ask the agent to list the records in your Airtable table or create a new record with specific field values 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?

Send a POST request to /v0/{baseId}/{table} with a JSON body containing a records array of field objects to create rows. To update, use PATCH on a specific record ID, 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 safely, since manual escaping of braces and spaces causes errors.

What authentication does the Airtable API use now?

Airtable 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 tokens must be granted access to each base individually.

Why does my Airtable API request return a 403 error?

A 403 usually means the token's Access list does not include that base, since personal access tokens are scoped per base. Revisit the token creation page and add the base to the token's access list.

What are the Airtable API rate limits and batch limits?

The API allows 5 requests per second per base, returning 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.