Airtable User MCP

---

Top Features

Feature	What it does	File types
Formula Editor	Syntax highlighting, IntelliSense, beautify / minify	.formula, .min.formula
Script Editor	Completions, hover docs, diagnostics	.ats, .script
Automation Editor	Completions, hover docs, diagnostics	.ata, .automation
MCP Server (66 tools)	Full Airtable internal API — schema, views, fields, records, extensions, templates	—
Language Server (LSP)	Standalone multi-editor support — Neovim, Zed, Helix, OpenCode	All above
IDE Auto-Setup	One-click MCP config for Cursor, Windsurf, Claude Desktop, Cline, Amp	—
AI Skills	Pre-built Airtable-specific rules and workflows for AI coding assistants	—
Daemon + Tunnel	Persistent background server; optional Cloudflare or ngrok remote access	—
Tool Profiles	read-only / safe-write / full / custom permission scopes	—
OS Keychain Auth	Browser-based Airtable login with SSO/2FA — credentials in your OS keychain	—

---

Why this exists

Airtable's public Web API has never exposed some of the most common tasks builders actually need: creating a formula field, tweaking a view's filter set, installing an extension, or validating a formula before it breaks production. The official Airtable MCP server is a thin wrapper over that same REST API, so it inherits every one of those gaps.

airtable-user-mcp is an add-on to the official Airtable MCP, not a replacement. It uses Airtable's own internal API (the one the web UI uses) to cover exactly the surface area the REST API can't reach. Register both servers in your AI client and your assistant gets the full Airtable automation experience — records over HTTP via the official MCP, plus schema, formulas, views, and extensions via this one.

---

What airtable-user-mcp adds on top of the official Airtable MCP

This is a coverage map, not a "pick one" decision — the two servers are complementary and designed to run side-by-side.

Capability	Official Airtable MCP	airtable-user-mcp
Total tools	~17	66
Auth model	Personal Access Token or OAuth, per-scope setup	Log in once with your normal Airtable account (SSO/2FA supported)
Transport	HTTP (remote)	stdio (local, private)
Data never leaves your machine	❌ Requests go through mcp.airtable.com	✅ Runs locally against Airtable's API
Schema read (bases, tables, fields, views)	Partial (no view config)	Full — filters, sorts, groups, visibility, row height, descriptions
Read records with resolved field values	Partial	✅ query_records — returns lookup/rollup/formula fields fully resolved
Search records by text (incl. lookup fields)	❌ filterByFormula with FIND()/SEARCH() silently fails on lookup fields	✅ query_records.search — substring match on all resolved values
Duplicate records	❌	✅ duplicate_records
Create formula fields	❌ UNSUPPORTED_FIELD_TYPE_FOR_CREATE	✅
Create rollup fields	❌	✅
Create lookup / multipleLookupValues fields	❌	✅
Create count fields	❌	✅
Update formula text of an existing field	❌	✅
Validate a formula before applying	❌	✅
Rename / duplicate / safely delete fields	Partial (no duplicate, no dependency summary)	✅ with expectedName guard + dependency preview
Create views (grid/form/kanban/calendar/gallery/gantt/list)	❌ (API has no create-view endpoint)	✅
Set/append view filters (nested AND/OR)	❌	✅
Set view sorts	❌	✅
Set view grouping	❌	✅
Change column order	❌	✅
Show/hide columns in a view	❌	✅
Change row height	❌	✅
Duplicate a view with its full configuration	❌	✅
View descriptions, cell wrap, covers, color config, calendar dates, frozen columns	❌	✅
Sidebar sections (create, rename, move, delete)	❌	✅
Record templates (create, pre-fill, duplicate, apply, delete)	❌	✅
Form metadata (description, redirect, attribution, branding)	❌	✅
Extension / block management (install, enable, rename, duplicate, remove)	❌	✅
Create dashboard pages	❌	✅
Tool profiles & per-tool toggles	❌	✅ read-only / safe-write / full / custom
Destructive-action safety guards	Relies on token scopes	✅ expectedName match, dependency summary, force flag
Batch record create limit	10 / request	Uses the same Airtable limit; no added restriction
VS Code / Cursor / Windsurf / Cline / Amp one-click install	Manual JSON edit per IDE	✅ One click via the companion extension
Formula editor with IntelliSense	❌	✅ (VS Code extension)
Credentials storage	You manage the PAT	OS keychain, auto-refresh
Plan requirement	Airtable plan with API access + token scopes	Any plan you can log into
Price	Free	Free, MIT

Sources: Airtable's official MCP docs, Airtable Web API reference, and the UNSUPPORTED_FIELD_TYPE_FOR_CREATE rollup thread.

---

Use both MCPs together

npx -y airtable-user-mcp login          # one-time browser login
claude mcp add airtable --scope user -- npx -y airtable-user-mcp   # Claude Code

airtable-user-mcp is additive. Register the official Airtable MCP following Airtable's setup guide, then add this one alongside it in the same mcpServers block:

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

Your MCP client will expose every tool from both servers. The two entries are independent — rename the keys (airtable, airtable-official, airtable-user-mcp, etc.) however makes sense for your workflow.

---

What's In This Repo

This monorepo ships three products from one source tree:

---

Demo

---

Features

MCP Server (66 Tools)

Manage Airtable bases with capabilities not available through the official REST API:

Category	Tools	Highlights
Schema Read	11	Full schema inspection — bases, tables, fields, views, sidebar sections, record templates; download all formula fields to local files
Record Read	1	query_records — up to 1 000 records/call with resolved field values; search param works on lookup/rollup fields (REST API filterByFormula doesn't)
Record Write	1	duplicate_records — bulk copy records within a table
Table Management	3	create / rename / delete tables
Field Management	9	Create formula / rollup / lookup / count fields, validate formulas, update descriptions, delete single or bulk
View Configuration	20	Filters, sorts, grouping, columns, freezing, row height, covers, color rules, calendar dates, create / duplicate / rename / delete
Sidebar Sections	4	Create, rename, move-into-section, delete (auto-promotes contained views to ungrouped)
Record Templates	8	Create / rename / describe / set cells / set columns / duplicate / apply / delete saved row scaffolds
Form Metadata	2	Description, redirect URL, attribution, copy-to-respondent, branding (legacy form views)
Extension Management	7	Create, install, enable/disable, rename, duplicate, remove extensions
Tool Management	1	List profiles, switch profile, toggle tools/categories (meta-tool, always enabled)

See the full tool reference in packages/mcp-server/README.md.

LSP Server

airtable-user-lsp is a standalone language server for Airtable formula, script, and automation files — works in any LSP-capable editor, not just VS Code.

# stdio mode — works standalone, no daemon needed
npx airtable-user-lsp --stdio

Features: diagnostics, completions, hover documentation, and signature help for .formula, .ats, and .ata files.

When the daemon is running, it auto-spawns airtable-user-lsp --tcp so multiple editors share one language server instance. The TCP port is written to ~/.airtable-user-mcp/daemon.lock as port_lsp.

See packages/lsp-server/README.md for per-editor configuration (Neovim, Zed, OpenCode, Helix).

---

Supported IDEs

The extension auto-configures MCP for all major AI-enabled editors:

Don't use VS Code? Use the standalone MCP server directly:

npx airtable-user-mcp

---

Find Us

---

Requirements

• VS Code ^1.100.0 (or any fork exposing the McpServerDefinitionProvider API)
• Node.js — bundled via the VS Code runtime; no separate install needed
• Google Chrome (or Edge / Chromium) — the Airtable login flow uses Patchright in headless mode. Falls back to msedge on Windows and chromium on Linux. The extension shows an actionable warning if no supported browser is detected.

---

Development

This is a pnpm monorepo.

Package	Description
packages/extension	VS Code extension host (TypeScript + tsup)
packages/webview	React dashboard webview (Vite + Tailwind v4)
packages/shared	Shared types and message protocol
packages/mcp-server	airtable-user-mcp — ESM Node MCP server
packages/lsp-server	airtable-user-lsp — LSP server for formula / script / automation files
scripts/	Build tooling (esbuild bundler, dep vendoring)

pnpm install          # install all packages
pnpm build            # build shared → webview → mcp bundle → extension
pnpm package          # build + create airtable-formula-X.Y.Z.vsix
pnpm test             # run all unit tests
pnpm dev              # start webview dev server (browser preview)

How the MCP server is bundled: scripts/bundle-mcp.mjs esbuilds packages/mcp-server/src/ into packages/extension/dist/mcp/. Then scripts/prepare-package-deps.mjs vendors patchright, patchright-core, and otpauth into dist/node_modules/ before vsce package runs. The VSIX is fully self-contained.

---

Support This Project

This project is built and maintained with the help of AI coding tools. If you find it useful and want to support continued development (new tools, updates, bug fixes), you can contribute by gifting Claude Code credits — the primary tool used to build this project.

Interested? Open an issue or reach out to discuss feature requests and sponsorship.

---

License

MIT