airtable-utils
A collection of useful tools and guidance for working with Airtable. Can be used in two ways:
- As a Claude Code plugin — install once and skills + CLI tools are automatically available to Claude
- Standalone — run the
bin/ scripts directly from the command line (requires uv), or copy the airtable-scripting skill into any Claude (Code) session manually
Skills
airtable-scripting
Comprehensive guidance for writing Airtable scripts both as Scripting Extensions (manual) and Automation Scripts (triggered). Covers the Scripting API, Web API integration, all field types, batching, error handling, and common patterns.
Use this skill when writing scripts for the user to paste into Airtable.
Standalone use: You can use this skill without installing the plugin. Copy skills/airtable-scripting.md and load it manually in any Claude Code session.
For Claude to directly read or write Airtable data, use an MCP server. There are two main options:
- Official — the
airtable@claude-plugins-official plugin bundles Airtable's hosted MCP server (https://mcp.airtable.com/mcp). It uses OAuth (or a PAT), needs nothing to run locally, and is the only one that can read Interface pages and create whole bases. It also ships official agent skills. Record creation is capped at 10 per request.
- Community —
airtable-mcp-server by domdomegg is self-hosted (run via npx or its HTTP transport), authenticates with a PAT only, and is the option that can delete records and work with record comments. Note its HTTP transport has no built-in auth, so only run it behind a reverse proxy or in a secured environment.
Both cover the common ground: read/search records, create/update records, and create/update tables and fields. Pick the official one for lower-friction setup and Interface/base support; pick the community one for self-hosted control, record deletion, or comments.
airtable-schema
Runs airtable-export-schema to dump a base's full schema (tables, fields, views) to JSON and Markdown. Use this before writing scripts so you have accurate IDs.
airtable-schema-diff
Runs airtable-diff-schema to compare two schema JSON exports and produce a Markdown diff showing tables/fields/views that were added, removed, renamed, or had their type changed.
airtable-standards-check
Runs airtable-check-standards to validate a schema JSON file against the BlueDot Impact Airtable Standards. Outputs a Markdown report grouped by table, listing errors and warnings. No API token or network access needed.
airtable-user-scraping
Runs airtable-scrape-users to scrape collaborator access data from Airtable bases, grouped by workspace. Outputs per-workspace CSVs showing who has access to what.
⚠️ The user scraper violates Airtable's Acceptable Use Policy. Use at your own risk.
Utilities
Scripts live in bin/ and use PEP 723 inline script metadata so uv handles dependencies automatically — no virtualenv setup needed.
When installed as a plugin, Claude can call these scripts directly. For terminal access by you, see the note in the Installation section below.
airtable-export-schema
Exports a base's schema via the Airtable API. Writes {base_id}_{name}_{timestamp}_schema.json/.md to the current directory. Both outputs include per-table stats (field count, view count, and primary field name) plus base-wide totals, all derived from the schema with no extra API calls — the JSON carries them in a summary object and the Markdown shows them in the header and per-table headings. The Markdown output also includes an Options column summarising each field's configuration (precision, date/time format, select choices, linked tables, rollup/lookup sources, etc.), shown in full without truncation.
Dependencies: requests (installed automatically by uv)
airtable-export-schema --token YOUR_PAT --base appXXXXXXXXXX
# or use a .env with AIRTABLE_TOKEN and AIRTABLE_BASE_ID
airtable-export-schema
airtable-diff-schema
Compares two schema JSON files produced by airtable-export-schema. Outputs a Markdown diff of tables, fields, and views — detecting renames by entity ID.
Dependencies: none (stdlib only)
airtable-diff-schema old_schema.json new_schema.json
airtable-diff-schema old.json new.json --output diff.md
airtable-check-standards
Validates a schema JSON file against the BlueDot Impact Airtable Standards. Outputs a Markdown report grouped by table. Exits with code 1 if any errors are found (CI-friendly).
Dependencies: none (stdlib only)
