VSCode-Airtable-Formula
Health Uyari
- License — License: MIT
- Description — Repository has a description
- Active repo — Last push 0 days ago
- Low visibility — Only 5 GitHub stars
Code Basarisiz
- 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 Gecti
- Permissions — No dangerous permissions requested
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.
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
Yorumlar (0)
Yorum birakmak icin giris yap.
Yorum birakSonuc bulunamadi