Unified Airtable skill for AI agents. 6 access methods with a decision tree, covering MCP, REST API, internal web API, Omni AI, scripting, formulas, webhooks, and automations. Built from real production work with 60+ Airtable bases at D1DX.
| Topic | What it covers |
|---|---|
| Method Decision Tree | When to use MCP vs REST API vs Internal API vs Omni AI vs Scripting |
| MCP | Tool reference, detail levels, safe vs write operations |
| Omni AI | Capabilities the API can't do — field configs, interfaces, automations, Field Agents |
| REST API | Batch limits, upsert, webhooks (create, poll, HMAC), pagination |
| Internal Web API | Reverse-engineered endpoints — Interface Designer layout, visibility filters, automation export, ID prefixes |
| Scripting API | Standalone vs Automation context, batch limits (50 not 10), field value type differences |
| Automations | Trigger/action types, duplicate automation prevention, latency notes |
| Formulas | Text, date, regex (RE2), arrays, logic functions, filterByFormula patterns |
| Field Types | REST vs Scripting JSON differences for every field type |
| Gotchas | 18 hard-won lessons — attachment URL expiry, checkbox null, field rename breakage, msgpack responses |
git clone https://github.com/D1DX/airtable-skill.git
cp -r airtable-skill ~/.claude/skills/airtableOr as a git submodule:
git submodule add https://github.com/D1DX/airtable-skill.git path/to/skills/airtableCopy SKILL.md (and supporting files) into your agent's prompt or knowledge directory. The skill is structured markdown — works with any LLM agent that reads reference files.
airtable-skill/
├── SKILL.md — Main skill (6 methods, decision tree, gotchas)
├── interface-api.md — Full internal web API spec (Interface Designer, readQueries)
├── reference.md — Quick reference tables
└── extract_automations.py — Script to export automations via internal API
This skill works standalone but pairs well with an Airtable MCP server for live base access. The skill provides knowledge; the MCP provides record operations.
| MCP Server | What it adds |
|---|---|
| domdomegg/airtable-mcp-server | Record CRUD, schema, search, comments, attachments |
- REST API & Scripting: Verified against Airtable Web API docs and production usage (60+ bases).
- Internal Web API: Reverse-engineered from browser traffic (HAR captures, March 2026). Endpoints may change without notice.
- Omni AI: Capabilities verified from official Airtable documentation (April 2026).
- Formulas: Verified against Airtable formula reference.
Built by Daniel Rudaev at D1DX.
MIT License — Copyright (c) 2026 Daniel Rudaev @ D1DX