Run any Skill in Manus with one click

airtable-cli

Stars37

Forks2

UpdatedJune 9, 2026 at 15:34

Lists bases, reads and writes records, manages tables and fields, filters and searches data in Airtable via the `airtable-mcp` CLI. Use when the task involves Airtable data or the user mentions airtable-mcp, bases, tables, records, or fields.

Installation

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

Run Skill in Manus

Source

Airtable

Airtable/skills

View GitHub Repository View Creator Repositories

Download

Run Skill in Manus

Related occupationsSOC

Based on SOC occupation classification

Software DevelopersComputer and Mathematical Occupations·SOC 15-1252

SKILL.md

readonly

More from this repository

same repository

agent-activity-log

Airtable/skills

Scaffold and operate an opt-in `Agent activity log` table that records what the agent did, decided, and got blocked on across a long-running or multi-session Airtable workflow. Use whenever a workflow skill (product-ops, sales-ops, marketing-ops, etc.) is being set up for an agent-driven motion (recurring triage, multi-step plan, automated monitoring, agentic workflow), or when the user explicitly asks for "agent activity tracking," "audit log of agent decisions," "agent memory," "track what the agent did," or similar. The pattern is opt-in (front-load the offer, frame as auditability for the user's benefit, not surveillance). Composes into workflow skills the same way `show-airtable-link` does — workflow skills point at this skill rather than re-implementing the schema inline.

2026-06-0937

airtable-filters

Airtable/skills

Builds Airtable filters parameters for the MCP tools that list or display records — field-type-aware comparison operators, choice and collaborator IDs, date ranges, and nested AND/OR logic. Use when the user wants to find, filter, narrow down, or search Airtable records by field values, even when they don't explicitly say "filter."

2026-06-0937

marketing-ops

Airtable/skills

Set up and run Airtable-based marketing operations workflows — request intake, campaign orchestration, creative production, content calendars, brand and compliance review, events, localization, budgets and ROI, capacity planning. Use when the user wants a marketing request "front door," to manage campaigns, coordinate briefs and assets, build a content calendar, plan launches or events, track budgets, measure ROI, or set up agency multi-client delivery. Adapts to org size (solo marketer to enterprise multi-brand or agency) and integrates with or displaces tools like HubSpot, Marketo, Mailchimp, Klaviyo, Workfront, Asana, Monday, and Wrike. Asks scope first.

2026-06-0937

product-ops

Airtable/skills

Set up and run Airtable-based product operations workflows — roadmap management, customer feedback synthesis, launch coordination, OKR cascading, sprint planning, release tracking. Use when the user wants to track product work, manage feature requests, build a roadmap, set up a feedback intake portal, prioritize initiatives, run launch checklists, or align OKRs across teams. Adapts to org size (solo founder, small team, mid-size product org, enterprise product portfolio) and existing tooling (Jira / Linear / Productboard / Aha integration; Salesforce / Zendesk / Gong feedback ingestion). Can scaffold either as a pure-Airtable workspace or as Airtable backing a custom branded UI on Vercel for public-facing portals. Asks scope questions first; doesn't impose framework. Focuses on cross-functional product operations.

2026-06-0937

sales-ops

Airtable/skills

Set up and run Airtable-based sales operations and CRM workflows — pipeline management, account and renewal management, deal desk, RFP / tender pipelines, partner CRMs, sales forecasting, vertical CRMs (real estate, mortgage, brokerage, capital markets, public works, nonprofit), and AI-native lean stacks (Clay-equivalent enrichment, AI-assisted outbound, conversation-intel ingestion). Use when the user wants to track deals, manage accounts, build a pipeline, run a deal desk, coordinate partners, manage RFPs, or build an AI-forward GTM stack. Defaults to augmenting existing CRMs (Salesforce / HubSpot); also supports Airtable-as-CRM and AI-native stacks. Asks scope first. Commercial workflows only; post-sale support belongs to a future customer-success skill.

2026-06-0937

show-airtable-link

Airtable/skills

Provides a clickable Airtable link whenever the agent has touched user-visible Airtable content. Use after every MCP call that creates, updates, lists, searches, or returns records, schema, or interface pages — bases, tables, fields, records, or pages. Hand off the most-specific URL the agent's tool calls have proven access to — prefer single-record URLs over table URLs, table URLs over base URLs, and interface page URLs when the user's access is restricted to pages. Format as a markdown link with a descriptive label. Construct URLs only from IDs the tools actually returned — never synthesize IDs to round out a URL. Compose this skill from any workflow skill that affects Airtable content.

2026-06-0937

name	airtable-cli
description	Lists bases, reads and writes records, manages tables and fields, filters and searches data in Airtable via the `airtable-mcp` CLI. Use when the task involves Airtable data or the user mentions airtable-mcp, bases, tables, records, or fields.
license	MIT
metadata	{"version":"1.0.0","author":"airtable"}

airtable-mcp

Self-discovery

Tools are fetched from the MCP server at runtime, so the CLI never has a hardcoded command list. Discover what's available:

airtable-mcp tools            # human-readable list
airtable-mcp tools --json     # machine-parseable list
airtable-mcp <tool> --help    # show flags and descriptions for a tool

Run airtable-mcp tools before assuming a tool exists. Tool names, arguments, and output shapes can change between server releases without a CLI update.

Install

npm install -g @airtable/mcp-cli

Auth

The CLI needs an Airtable personal access token (PAT). Two paths:

Environment variable (preferred for scripts/agents):

export AIRTABLE_TOKEN=pat_xxx

Interactive configure (stores token in ~/.airtable/cli.json with 0600 permissions):

airtable-mcp configure

Create tokens at https://airtable.com/create/tokens. Ensure the token has the scopes required by the tools being called.

AIRTABLE_TOKEN takes precedence over saved profiles when no --profile flag is set. Never log or echo tokens.

Quick reference

Task	Command
Set up credentials	`airtable-mcp configure`
Add a named profile	`airtable-mcp configure --profile work`
Check auth status	`airtable-mcp whoami`
Remove credentials	`airtable-mcp logout`
Remove all profiles	`airtable-mcp logout --all`
List available tools	`airtable-mcp tools`
Run a tool	`airtable-mcp <tool> --flagName value`
Get tool help	`airtable-mcp <tool> --help`
Pass args via stdin	`echo '{"key":"val"}' \| airtable-mcp <tool> --input -`
Bypass tool cache	`airtable-mcp <tool> --refresh`
Suppress status msgs	`airtable-mcp <tool> -q`
Raw text output	`airtable-mcp <tool> --output raw`
Use a specific profile	`airtable-mcp <tool> --profile work`

Tool names use hyphens on the CLI (list-records) but underscores in MCP (list_records). The CLI translates automatically.

Workflow

Auth — set AIRTABLE_TOKEN or run airtable-mcp configure
Discover — run airtable-mcp tools to see available tools
Inspect — run airtable-mcp <tool> --help for flags and descriptions
Check access — in tools --json output, check the access field: read-only, write, or destructive. Confirm with the user before running destructive tools.
Execute — run airtable-mcp <tool> --flagName value

Output & automation

Default output is formatted JSON to stdout. Status messages go to stderr.
--json on tools gives a JSON array of {name, title, access}.
-q / --quiet suppresses stderr status messages (cache warnings, etc).
--output raw returns the raw server response text instead of parsed JSON.
--input - reads tool arguments as a JSON object from stdin, bypassing flag parsing.
Exit codes: 0 success, 1 error (auth, tool failure, not found), 2 usage error (bad flags, bad input).

Common tasks

Find a base and list its tables:

airtable-mcp search-bases --searchQuery "Project Tracker" -q
airtable-mcp list-tables-for-base --baseId appEXAMPLEbase001 -q

List records with specific fields:

airtable-mcp list-records-for-table \
  --baseId appEXAMPLEbase001 --tableId tblEXAMPLEtable01 \
  --fieldIds '["Name","Status"]' --pageSize 10 -q

Filter records — filters use structured JSON, not formula strings. Wrap conditions in an operands array; the top-level operator defaults to and if omitted:

airtable-mcp list-records-for-table \
  --baseId appEXAMPLEbase001 --tableId tblEXAMPLEtable01 \
  --filters '{"operator":"and","operands":[{"operator":"=","operands":["Status","Done"]}]}' -q

For select fields, filter by choice ID (from get-table-schema), not the display name. The airtable-filters skill covers compound filters, date filters, and operator-by-field-type details.

Search records — use search-records for free-text/fuzzy queries on large tables. Use list-records-for-table with --filters when filtering by exact field values:

airtable-mcp search-records \
  --baseId appEXAMPLEbase001 --table tblEXAMPLEtable01 \
  --query "acme" --fields '["Name","Notes"]' -q

Pass --fields ALL_SEARCHABLE_FIELDS to search across every indexed field. Date, rating, checkbox, and button fields are not searchable.

Update records — complex args are easier via --input -:

echo '{"baseId":"appEXAMPLEbase001","tableId":"tblEXAMPLEtable01","records":[{"id":"recEXAMPLErecord1","fields":{"fldEXAMPLEfield01":"Done"}}]}' \
  | airtable-mcp update-records-for-table --input - -q

Select field values are returned as objects ({"id":"sel...","name":"Done"}) but must be written as plain strings ("Done"). Record field keys in create/update currently require field IDs (fldEXAMPLEfield02) — use get-table-schema to resolve names to IDs before writing. Note that fieldIds, sort, and filters accept both names and IDs.

Gotchas

Problem	Cause	Fix
`Unknown tool: X`	Tool name doesn't exist on the server or cache is stale	Run `airtable-mcp tools --refresh` to refresh, then retry
`Authentication failed`	Token expired, revoked, or wrong	Run `airtable-mcp configure` or check `AIRTABLE_TOKEN`
`Access denied`	Token missing required scopes	Add scopes at https://airtable.com/create/tokens
`Connection timed out`	Server unreachable (10s timeout)	Check network; CLI falls back to stale cache if available
Boolean flags take no value	`--dryRun true` passes `"true"` as next arg	Use `--dryRun` alone (booleans are presence-based)
Array/object args fail	Value isn't valid JSON	Pass as JSON string: `--fieldMappings '{"a":"b"}'`
Filter rejected at top level	Single condition passed without `operands` wrapper	Wrap in `{"operands":[...]}` (`operator` defaults to `and`)
Sort key is `fieldId` not `field`	`--sort '[{"field":"Name"}]'` silently ignored	Use `{"fieldId":"Name","direction":"asc"}` — accepts field IDs or names
Select filter returns no matches	Filtering by display name instead of choice ID	Run `get-table-schema` first to get `sel...` choice IDs
`INVALID_RECORDS` on batch write	Batch limit is 10 records per request (default; varies by account)	Split into chunks of ≤10 and check `<tool> --help` for the current limit
Permission error on `list-records-for-table`	User has interface-only access to the base	Use `list-records-for-page` / `get-record-for-page` instead
Endpoints restricted	CLI only allows HTTPS on `*.airtable.com`	Cannot point at arbitrary servers (security constraint)