VSCode-Airtable-Formula

mcp
Security Audit
Fail
Health Warn
  • License — License: MIT
  • Description — Repository has a description
  • Active repo — Last push 0 days ago
  • Low visibility — Only 5 GitHub stars
Code Fail
  • fs module — File system access in .github/workflows/release.yml
  • rimraf — Recursive directory removal in package.json
  • fs module — File system access in packages/extension/package.json
  • exec() — Shell command execution in packages/extension/scripts/bump-version.cjs
  • fs module — File system access in packages/extension/scripts/bump-version.cjs
  • exec() — Shell command execution in packages/extension/scripts/package-vsix.cjs
  • spawnSync — Synchronous process spawning in packages/extension/scripts/package-vsix.cjs
  • fs.rmSync — Destructive file system operation in packages/extension/scripts/package-vsix.cjs
  • fs module — File system access in packages/extension/scripts/package-vsix.cjs
Permissions Pass
  • Permissions — No dangerous permissions requested
Purpose
This tool is a Visual Studio Code extension and Model Context Protocol (MCP) server designed to help developers interact with Airtable. It provides a dedicated formula editor, schema tools, and over 30 automation utilities for managing bases, views, and fields directly within the IDE.

Security Assessment
Overall Risk: Medium. The tool relies heavily on local file system access and shell command execution. While standard for build and release scripts (like version bumping and packaging a VSIX file), the automated use of `exec()`, `spawnSync`, and destructive commands like `rimraf` and `fs.rmSync` presents a potential local attack surface. The tool does not request overtly dangerous permissions, and no hardcoded secrets were detected. However, as an Airtable integration, it inherently handles sensitive data and will require network requests to communicate with Airtable's external APIs.

Quality Assessment
The project appears to be actively maintained, with repository pushes happening as recently as today. It is properly licensed under the standard MIT license, allowing for broad usage and modification. However, community trust and visibility are currently very low. With only 5 GitHub stars, the tool has not yet been widely adopted or heavily scrutinized by the open-source community, meaning undocumented bugs or security issues are more likely to exist.

Verdict
Use with caution — the build scripts contain powerful local execution capabilities, and its very low community adoption means it has not undergone widespread peer review.
SUMMARY

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

README.md
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:

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 .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:

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


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.


License

MIT

Reviews (0)

No results found