Airtable User MCP

NPM · AIRTABLE-USER-MCP · SCANNED AUG 3

Manage Airtable bases: schema, field CRUD, views, formula validation, extensions

Available components

+34 this week 80 80 Trust /100

Trust breakdown (6 categories)

How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score →

Supply Chain Security87

No malware found by supply-chain analysis.Pass
Only part of the dependency tree could be resolved (140 of 145), so this covers what we could see, not the whole tree.Partial
No install/post-install scripts declared.Pass
Only part of the dependency tree could be resolved (140 of 145), so this covers what we could see, not the whole tree. View diagnostics → Partial

Provenance & Transparency97

Source repository is publicly reachable at the declared URL. View diagnostics → Pass
Cryptographically verified build provenance (signed, bound to Automations-Project/VSCode-Airtable-Formula). View diagnostics → Pass
Clear OSI-approved license (MIT).Pass
Actively maintained (last published 3 days ago).Pass
Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail

Schema Quality & AI Usability77

AI-judged instruction clarity (excellent).Pass
Context-footprint check failed: tool/resource definitions use about 3459 tokens (~104/item across 33 items; 33 tools + 0 resources), over budget; trim descriptions and params. See how to fix → Fail
Usage-examples check failed: none of the tools include examples. See how to fix → Fail

Stability & Change Management27

Stability observed for 8 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial

Tool Coverage100

100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
100% of tool parameters carry a description.Pass

Capabilities100

Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass

Install

Add this component to your MCP client. Where a client-specific snippet is available, pick your client below and copy it straight into your config; otherwise use the connection detail shown.

npm · airtable-user-mcp

Claude Codex opencode OpenClaw Hermes Other

# add to Claude Code

claude mcp add automations-project-airtable-user-mcp -- npx -y airtable-user-mcp

# add to Codex CLI

codex mcp add automations-project-airtable-user-mcp -- npx -y airtable-user-mcp

// opencode.json

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "automations-project-airtable-user-mcp": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "airtable-user-mcp"
      ],
      "enabled": true
    }
  }
}

# add to OpenClaw

openclaw mcp add automations-project-airtable-user-mcp --command npx --arg -y --arg airtable-user-mcp

# ~/.hermes/config.yaml

mcp_servers:
  automations-project-airtable-user-mcp:
    command: "npx"
    args: ["-y", "airtable-user-mcp"]

// mcp.json

{
  "mcpServers": {
    "automations-project-airtable-user-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-user-mcp"
      ]
    }
  }
}

Changelog

Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.

3 Aug 26 +4
- Stability: unverified → 0.27 ▲ functional
2 Aug 26 +70
- Install scripts: unverified → pass ▲ security
- Provenance: unverified → pass ▲ security
- Known CVEs: unverified → partial ▲ security
- Malware scan: unverified → pass ▲ security
- Stability: Stability not yet verified: not enough scan history yet (needs a 30-day window). security
- The attested source repository moved: Automations-Project/VSCode-Airtable-Formula security
- Dependency health: partial → unverified ▼ functional
- Schema quality: unverified → excellent ▲ functional
- License: unverified → pass ▲ functional
- Maintenance: unverified → pass ▲ functional
- MCP protocol: unverified → pass ▲ functional
- Tool coverage: unverified → 100 ▲ functional
- Licence: MIT functional
1 Aug 26 −15
- Tool coverage: 100 → unverified ▼ functional
- Dependency health: unverified → partial ▲ functional
- First check of Schema quality: unverified functional
31 Jul 26 −7
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
30 Jul 26 −18
- Malware scan: pass → unverified ▼ security
27 Jul 26 46

First indexed and scored.

Show 3 earlier entries Hide earlier entries

Diagnostics

Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.

Captured 3 Aug 2026 · Analysed npm/[email protected]

Provenance verified

Ecosystem: npm · Outcome: verified

Reason: verified

Source repo:: Automations-Project/VSCode-Airtable-Formula
Certificate issuer:: https://token.actions.githubusercontent.com
Certificate SAN:: https://github.com/Automations-Project/VSCode-Airtable-Formula/.github/workflows/publish-mcp-server.yml@refs/tags/mcp-server/v2.1.1
Rekor log index:: 1279829963
Predicate type:: https://slsa.dev/provenance/v1
Subject digest:: sha512:3ecbe11079dda0957b629441dfcd538c284554787aa2721add84519091e45723cca0f78569aa64750aa1af264aa53e47453249656799cf90449653ac0
Discovery method:: attestation_endpoint

Dependencies 140 packages

140 packages in the resolved dependency tree · 139 deprecated · 40 stale.

The dependency tree was only partially resolved, so these counts may be incomplete.

MCP tools — 33 exposed · ~3,459 tokens

The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability.

Tool Tokens

apply_view_sorts ~96

Apply sort conditions to a view. Pass an empty array to clear all sorts.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
sorts	array	yes	Array of sort conditions. Empty array [] clears all sorts.
viewId	string	yes	The view ID (e.g. "viwXXX")

No output schema declared.

No examples provided.

create_extension ~104

Create a new extension (block) in an Airtable base. Returns the block ID needed for installation. Use this to register custom extensions before installing them.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
name	string	yes	Name for the extension
releaseId	string	yes	The release ID of the extension (e.g. "blrXXX")

No output schema declared.

No examples provided.

create_extension_dashboard ~71

Create a new extension dashboard page in a base. Extensions are installed onto dashboard pages.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
name	string	yes	Name for the dashboard page

No output schema declared.

No examples provided.

create_field ~250

Create a new field in an Airtable table. Supports all field types including computed fields (formula, rollup, lookup, count) that are not available via the official API.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
description	string	—	Optional field description
fieldType	string	yes	The field type: "formula", "rollup", "lookup", "count", "text", "number", "checkbox", etc.
insertAfterFieldId	string	—	Optional: field ID to insert after. Omit to append at end.
name	string	yes	Name for the new field
tableId	string	yes	The table ID to create the field in (e.g. "tblXXX")
typeOptions	object	—	Type-specific config. For formula: { formulaText: "..." }. For rollup: { fieldIdInLinkedTable, recordLinkFieldId, resultType, referencedFieldIds }. For lookup: { recordLinkFieldId, fieldIdInLinkedTab…

No output schema declared.

No examples provided.

create_formula_field ~103

Create a new formula field in a table. Shorthand for create_field with type "formula".

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
formulaText	string	yes	The formula expression
name	string	yes	Name for the new formula field
tableId	string	yes	The table ID (e.g. "tblXXX")

No output schema declared.

No examples provided.

create_view ~184

Create a new view in an Airtable table. Optionally copy configuration from an existing view. View types: "grid", "form", "kanban", "calendar", "gallery", "gantt", "levels" (list view).

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
copyFromViewId	string	—	Optional: view ID to copy configuration from (creates a fresh view with same settings).
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
name	string	yes	Name for the new view
tableId	string	yes	The table ID to create the view in
type	string	—	View type: "grid", "form", "kanban", "calendar", "gallery", "gantt", "levels" (list). Default: "grid".

No output schema declared.

No examples provided.

delete_field ~160

Delete a field from an Airtable table. Requires both fieldId AND the expected field name as a safety guard. First checks for downstream dependencies — if found, returns dependency info instead of deleting. Set force=true to delete even with dependencies.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
expectedName	string	yes	The expected name of the field. Must match exactly or deletion is refused.
fieldId	string	yes	The field/column ID to delete (e.g. "fldXXX")
force	boolean	—	When true, delete even if the field has downstream dependencies (other fields referencing it). Default: false.

No output schema declared.

No examples provided.

delete_view ~79

Delete a view from a table. Cannot delete the last remaining view in a table.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
viewId	string	yes	The view ID to delete (e.g. "viwXXX")

No output schema declared.

No examples provided.

duplicate_extension ~80

Duplicate an installed extension on a dashboard page.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
pageId	string	yes	The dashboard page to place the duplicate on
sourceInstallationId	string	yes	The installation ID to duplicate

No output schema declared.

No examples provided.

duplicate_field ~100

Duplicate (clone) a field in a table. Optionally also duplicate the cell values.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
duplicateCells	boolean	—	Also copy cell values. Default: false
sourceFieldId	string	yes	The field ID to duplicate
tableId	string	yes	The table ID

No output schema declared.

No examples provided.

duplicate_view ~109

Duplicate an existing view with all its configuration (filters, sorts, field visibility, etc).

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
newName	string	yes	Name for the duplicated view
sourceViewId	string	yes	The view ID to duplicate (e.g. "viwXXX")
tableId	string	yes	The table ID the view belongs to

No output schema declared.

No examples provided.

get_base_schema ~67

Get the full schema of an Airtable base including all tables, fields, and views.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID (e.g. "appXXX")
debug	boolean	—	When true, include raw Airtable response in output for diagnostics

No output schema declared.

No examples provided.

get_table_schema ~81

Get the full schema for a single table including all fields and views.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
tableIdOrName	string	yes	The table ID (e.g. "tblXXX") or exact table name

No output schema declared.

No examples provided.

install_extension ~118

Install an extension onto a dashboard page. Requires a block ID (from create_extension) and a page ID (from create_extension_dashboard).

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
blockId	string	yes	The block ID (e.g. "blkXXX")
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
name	string	yes	Display name for this installation
pageId	string	yes	The dashboard page ID (e.g. "bipXXX")

No output schema declared.

No examples provided.

list_fields ~76

List all fields (columns) in a specific table of an Airtable base.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
tableIdOrName	string	yes	The table ID or name to list fields for

No output schema declared.

No examples provided.

list_tables ~61

List all tables in an Airtable base with their IDs and names. Uses lightweight scaffolding data.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics

No output schema declared.

No examples provided.

list_views ~72

List all views in a specific table with their IDs, names, and types.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
tableIdOrName	string	yes	The table ID or name

No output schema declared.

No examples provided.

manage_tools ~157

Control which tools are available. Actions: list_profiles, switch_profile, get_tool_status, toggle_tool, toggle_category. Use this to switch between read-only, safe-write, full, or custom profiles, or enable/disable individual tools.

Input Output Examples

Name	Type	Req	Description
action	string	yes	The action to perform
category	string	—	Category name for toggle_category action (read, field-write, field-destructive, view-write, view-destructive, extension)
enabled	boolean	—	Enable (true) or disable (false) for toggle_tool / toggle_category actions
profile	string	—	Profile name for switch_profile action (read-only, safe-write, full, custom)
tool	string	—	Tool name for toggle_tool action

No output schema declared.

No examples provided.

remove_extension ~70

Remove an installed extension from a dashboard.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
installationId	string	yes	The block installation ID to remove (e.g. "bliXXX")

No output schema declared.

No examples provided.

rename_extension ~77

Rename an installed extension.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
installationId	string	yes	The block installation ID (e.g. "bliXXX")
name	string	yes	New name for the extension

No output schema declared.

No examples provided.

rename_field ~92

Rename a field (column) in an Airtable table. Pre-validates the field exists before mutating.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
fieldId	string	yes	The field/column ID to rename
newName	string	yes	The new name for the field

No output schema declared.

No examples provided.

rename_view ~80

Rename a view.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
newName	string	yes	The new name for the view
viewId	string	yes	The view ID to rename (e.g. "viwXXX")

No output schema declared.

No examples provided.

reorder_view_fields ~138

Reorder the fields (columns) displayed in a view. Provide a mapping of field IDs to their desired column index positions.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
fieldOrder	object	yes	Map of field IDs to target column indices: { "fldXXX": 0, "fldYYY": 1, "fldZZZ": 2 }. Index 0 is the leftmost position after the primary field.
viewId	string	yes	The view ID (e.g. "viwXXX")

No output schema declared.

No examples provided.

show_or_hide_view_columns ~116

Show or hide specific fields (columns) in a view. Unlike show_or_hide_all, this targets individual columns.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
columnIds	array	yes	Array of field IDs to show or hide
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
viewId	string	yes	The view ID (e.g. "viwXXX")
visibility	boolean	yes	true to show, false to hide

No output schema declared.

No examples provided.

update_extension_state ~81

Enable or disable an extension installation.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
installationId	string	yes	The block installation ID (e.g. "bliXXX")
state	string	yes	"enabled" or "disabled"

No output schema declared.

No examples provided.

update_field_config ~139

Update the configuration of any computed field (formula, rollup, lookup, count, etc). Use this to change formula text, rollup settings, etc.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
fieldId	string	yes	The field/column ID (e.g. "fldXXX")
fieldType	string	yes	The field type: "formula", "rollup", "lookup", "count"
typeOptions	object	yes	Type-specific options. For formula: { formulaText: "..." }

No output schema declared.

No examples provided.

update_field_description ~81

Update the description text of a field.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
description	string	yes	The new description text
fieldId	string	yes	The field/column ID (e.g. "fldXXX")

No output schema declared.

No examples provided.

update_formula_field ~95

Update the formula text of an existing formula field. Shorthand for update_field_config with type "formula".

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
fieldId	string	yes	The field/column ID (e.g. "fldXXX")
formulaText	string	yes	The new formula text

No output schema declared.

No examples provided.

update_view_description ~86

Update the description text of a view.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
description	string	yes	The new description text. Use empty string to clear.
viewId	string	yes	The view ID (e.g. "viwXXX")

No output schema declared.

No examples provided.

update_view_filters ~135

Update the filter configuration of a view. Supports AND/OR conjunctions with field-level filter conditions.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
filters	object	yes	Filter config: { filterSet: [{ columnId: "fldXXX", operator: "contains"\|"isEmpty"\|"isNot"\|..., value: "..." }], conjunction: "and"\|"or" }
viewId	string	yes	The view ID to update filters on (e.g. "viwXXX")

No output schema declared.

No examples provided.

update_view_group_levels ~94

Set grouping on a view. Pass an empty array to clear grouping.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
groupLevels	array	yes	Array of group levels. Empty array [] clears grouping.
viewId	string	yes	The view ID (e.g. "viwXXX")

No output schema declared.

No examples provided.

update_view_row_height ~95

Change the row height of a grid view.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
rowHeight	string	yes	Row height: "small", "medium", "large", or "xlarge"
viewId	string	yes	The view ID (e.g. "viwXXX")

No output schema declared.

No examples provided.

validate_formula ~112

Validate a formula expression before creating or updating a formula field. Returns whether the formula is valid and what result type it produces (text, number, etc). Use this before create/update to catch errors early.

Input Output Examples

Name	Type	Req	Description
appId	string	yes	The Airtable base/application ID
debug	boolean	—	When true, include raw Airtable response in output for diagnostics
formulaText	string	yes	The formula expression to validate
tableId	string	yes	The table ID where the formula will be used

No output schema declared.

No examples provided.

On this page

Handy links

Scoring key

80+ high trust
60–79 medium
below 60 low

How we score

Score history · last 30 days

27 Jul 3 Aug