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 Formula
Formula editor, MCP server, and AI skills for VS Code
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:
| Product | Install | |
|---|---|---|
| Airtable Formula — VS Code extension | Marketplace | |
| airtable-user-mcp — Standalone MCP server | npx airtable-user-mcp |
Features
VS Code Extension
- Formula Editor — Syntax highlighting, IntelliSense, beautify / minify for
.formulafiles - 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:
| 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:
| Claude Desktop | Claude Code | Cursor | Windsurf | Cline | Amp |
Don't use VS Code? Use the standalone MCP server directly:
npx airtable-user-mcp
Find Us
| 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 |
| Glama | glama.ai/mcp/servers |
| PulseMCP | pulsemcp.com |
| MCP.so | mcp.so |
Requirements
- VS Code ^1.100.0 (or any fork exposing the
McpServerDefinitionProviderAPI) - 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
msedgeon Windows andchromiumon 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.
License
संबंधित सर्वर
Binance Cryptocurrency MCP
Access real-time Binance cryptocurrency market data, including prices, order books, and trading history.
pharma-signal
Drug safety intelligence API with 19 MCP tools. Covers 358 drugs across 1M+ FDA adverse event reports with real-time risk scoring, pharmacovigilance signal detection (PRR/ROR), company portfolio analysis by ticker, and AI-powered analyst briefs. Free tier: 100 calls/day.
Azure Data Explorer
An MCP server for integrating with Azure Data Explorer, allowing for data querying and management.
Mina Archive Node API
Access Mina blockchain data, including events, actions, and network state, through the Mina Archive Node API.
MongoDB
Interact with MongoDB databases using natural language. Query collections, inspect schemas, and manage data.
MySQL
Interact with and manage MySQL databases. Requires connection details configured via environment variables.
Gunsnation MCP
MCP server that gives assistants real-time access to the Gunsnation firearms catalog
HubDB MCP Server by CData
A read-only MCP server by CData that enables LLMs to query live data from HubDB.
DART MCP Server
Access corporate disclosure information, financial data, and reports from the Korean electronic disclosure system (DART) API.
D&D 5E MCP Server
Access Dungeons & Dragons 5th Edition content, including spells, classes, and monsters, via the Open5e API.