Airtable

Airtable REST API via curl — records CRUD, filters, upserts, pagination, and schema inspection with Personal Access Tokens.

Features

• Full CRUD operations for records (create, read, update, delete)
• Batch operations up to 10 records per request
• Filter formulas with URL encoding (exact match, contains, AND/OR)
• Sort, select specific fields, and named views
• Upsert by merge field for idempotent syncs
• Schema inspection: list bases, tables, and field types
• Pagination handling for large datasets (100 records/page)
• All operations via curl — no SDK, no MCP server, no OAuth flow

Installation

hermes skills install productivity/airtable

Or manually clone into ~/.hermes/skills/productivity/airtable/.

Usage

# List accessible bases
curl -s "https://api.airtable.com/v0/meta/bases" -H "Authorization: Bearer $AIRTABLE_API_KEY"

# List records with filter
curl -s "https://api.airtable.com/v0/$BASE_ID/$TABLE?filterByFormula=$ENC" -H "Authorization: Bearer $AIRTABLE_API_KEY"

# Create a record
curl -s -X POST "https://api.airtable.com/v0/$BASE_ID/$TABLE" -H "Authorization: Bearer $AIRTABLE_API_KEY" -H "Content-Type: application/json" -d '{"fields":{"Name":"New task","Status":"Todo"}}'

# Upsert by email
curl -s -X PATCH "https://api.airtable.com/v0/$BASE_ID/$TABLE" -H "Authorization: Bearer $AIRTABLE_API_KEY" -H "Content-Type: application/json" -d '{"performUpsert":{"fieldsToMergeOn":["Email"]},"records":[{"fields":{"Email":"user@example.com","Status":"Active"}}]}'

Configuration

• AIRTABLE_API_KEY: Required — create a Personal Access Token at https://airtable.com/create/tokens
• Token must have scopes: data.records:read, data.records:write, schema.bases:read
• Each base must be added to the token's Access list in the Airtable UI
• Store in ~/.hermes/.env as AIRTABLE_API_KEY=pat_your_token_here

Requirements

• curl
• Python 3 (for python3 -m json.tool pretty-printing and URL encoding)
• Airtable Personal Access Token with appropriate scopes and base access

License

MIT

Related Hermes Skills

• hermes-budget-tracker — Personal budget tracking and analysis
• hermes-consensus-engine — Multi-model consensus and decision engine
• hermes-nano-pdf — Lightweight PDF processing and manipulation
• hermes-notion — Notion integration and management
• hermes-ocr-and-documents — OCR and document processing