Airtable User Mcp
- ide
Community Internal MCP server for Airtable - 30 tools for schema inspection, field CRUD (formula, rollup, lookup, count), view configuration, formula validation, and extension management. Not affiliated with Airtable Inc.
About
What is Airtable User Mcp?
Airtable User Mcp is a standalone Model Context Protocol (MCP) server that manages Airtable bases with capabilities not available through the official REST API. It is designed for developers using AI-enabled editors and can be run via npx airtable-user-mcp or auto-configured through the Airtable Formula VS Code extension.
How to use Airtable User Mcp?
Run npx airtable-user-mcp in a terminal to start the standalone MCP server. It requires an Airtable login via browser-based authentication (using Patchright in headless Chrome/Edge/Chromium) and stores credentials in the OS keychain. For VS Code users, the Airtable Formula extension offers one-click MCP registration for multiple IDEs.
Key features of Airtable User Mcp
- 30 tools covering schema, fields, views, and extensions
- Full base, table, field, and view schema inspection
- Create formula, rollup, lookup, and count fields
- Configure view filters, sorts, grouping, and column visibility
- Manage Airtable extensions (create, install, enable/disable, rename)
- Set or update field descriptions
Use cases of Airtable User Mcp
- Automate Airtable base schema management from AI coding assistants
- Programmatically create and validate formula fields without REST API limits
- Bulk configure view settings like filters, sorts, and grouping
- Install and enable Airtable extensions across multiple bases
- Enrich field metadata for documentation or migration scripts
FAQ from Airtable User Mcp
What IDEs does Airtable User Mcp support?
Claude Desktop, Claude Code, Cursor, Windsurf, Cline, and Amp. For VS Code and its forks, the Airtable Formula extension auto-configures MCP.
Is Airtable User Mcp affiliated with Airtable Inc.?
No. This is a community-maintained project and is not affiliated with Airtable Inc.
What is the licensing and pricing?
It is open source under the MIT license. The project is experimental and under active development; it is not intended for production use.
What are the system requirements for the standalone server?
Node.js (bundled via VS Code runtime if using the extension) and Google Chrome, Edge, or Chromium for the login flow. No separate Node.js install is needed when using the VS Code extension.
How many MCP tools does Airtable User Mcp provide?
30 tools across five categories: schema read (5), field management (8), view configuration (11), field metadata (1), and extension management (5).
Details
- Author
- Automations-Project
- Category
- ide
- Repository
- automations-project/vscode-airtable-formula
<div align="center">
Airtable Formula
Formula editor, MCP server, and AI skills for VS Code
<br />
> 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.
</div>
---
What's In This Repo
This monorepo ships two products from one source tree:
<div align="center">
| | Product | Install |
|:-:|:--------|:--------|
| 
| Airtable Formula — VS Code extension | Marketplace |
| 
| airtable-user-mcp — Standalone MCP server | npx airtable-user-mcp |
</div>
---
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
<!-- TODO: Replace with actual screenshot -->
<!-- <p align="center">
</p> -->
MCP Server (30 Tools)
Manage Airtable bases with capabilities not available through the official REST API:
| Category | Tools | Highlights |
|:---------|:-----:|:-----------|
| Schema Read | 5 | Full schema inspection — bases, tables, fields, views |
| Field Management | 8 | Create formula / rollup / lookup / count fields, validate formulas |
| View Configuration | 11 | Filters, sorts, grouping, column visibility, row height |
| Field Metadata | 1 | Set or update field descriptions |
| Extension Management | 5 | Create, 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:
<div align="center">
| 
| 
| 
| 
| 
| 
|
|:---:|:---:|:---:|:---:|:---:|:---:|
| Claude Desktop | Claude Code | Cursor | Windsurf | Cline | Amp |
</div>
Don't use VS Code? Use the standalone MCP server directly:
npx airtable-user-mcp
---
Find Us
<div align="center">
| Registry | Link |
|:---------|:-----|
| VS Code Marketplace | Nskha.airtable-formula |
| npm | airtable-user-mcp |
| Open VSX | Nskha.airtable-formula |
| MCP Registry | io.github.automations-project/airtable-user-mcp |
| Smithery | smithery.ai |
| Glama | glama.ai/mcp/servers |
| PulseMCP | pulsemcp.com |
| MCP.so | mcp.so |
</div>
---
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 |
| 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.
---
