Airtable User MCP

VS Code extension and MCP server for Airtable, formula editor, schema tools, and 30+ automation utilities for bases, views, and fields.

Airtable

Airtable Formula

Formula editor, MCP server, and AI skills for VS Code

VS Code version Open VSX version npm version MCP Registry listing

VS Code installs Open VSX downloads npm downloads per week GitHub stars

CI status Latest release Last commit License


Not affiliated with Airtable Inc. This is a community-maintained project.

Experimental — This project is under active development and not intended for production use. APIs, tools, and behavior may change without notice.


What's In This Repo

This monorepo ships two products from one source tree:

ProductInstall
Airtable Formula — VS Code extensionMarketplace
airtable-user-mcp — Standalone MCP servernpx airtable-user-mcp

Features

VS Code Extension

  • Formula Editor — Syntax highlighting, IntelliSense, beautify / minify for .formula files
  • MCP Server — One-click MCP registration for multiple IDEs
  • AI Skills — Auto-install Airtable-specific skills, rules, and workflows for AI coding assistants
  • Airtable Login — Credentials in OS keychain, browser-based auth with auto-refresh
  • Dashboard — React webview with Overview, Setup, and Settings tabs

MCP Server (30 Tools)

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

CategoryToolsHighlights
Schema Read5Full schema inspection — bases, tables, fields, views
Field Management8Create formula / rollup / lookup / count fields, validate formulas
View Configuration11Filters, sorts, grouping, column visibility, row height
Field Metadata1Set or update field descriptions
Extension Management5Create, install, enable/disable, rename, remove extensions

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


Supported IDEs

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

Claude DesktopClaude CodeCursorWindsurfClineAmp

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.

PackageDescription
packages/extensionVS Code extension host (TypeScript + tsup)
packages/webviewReact dashboard webview (Vite + Tailwind v4)
packages/sharedShared types and message protocol
packages/mcp-serverairtable-user-mcp — ESM Node MCP server
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

Related Servers

NotebookLM Web Importer

Import web pages and YouTube videos to NotebookLM with one click. Trusted by 200,000+ users.

Install Chrome Extension