Airtable Mcp Server

What is Airtable Mcp Server?

Airtable Mcp Server (package airtable-user-mcp) is a community-maintained MCP server that provides 66 tools by using Airtable’s internal API — the same one the web UI uses. It is designed to complement the official Airtable MCP server, covering schema, views, fields, extensions, and templates that the official REST API cannot access. It authenticates via a normal Airtable account with browser-based login (SSO/2FA supported) and stores credentials in the OS keychain.

How to use Airtable Mcp Server?

Run npx -y airtable-user-mcp login for a one-time browser login. Then add it to your MCP client’s mcpServers configuration, for example:

{
  "mcpServers": {
    "airtable-user-mcp": {
      "command": "npx",
      "args": ["-y", "airtable-user-mcp"]
    }
  }
}

Use it alongside the official Airtable MCP to get full coverage; the server runs locally over stdio.

Key features of Airtable Mcp Server

• 66 tools covering schema, views, fields, extensions, templates
• Browser-based login with SSO/2FA, credentials in OS keychain
• Full schema read including view filters, sorts, groups, descriptions
• Create formula, rollup, lookup, and count fields
• Create and configure all view types (grid, form, kanban, etc.)
• Duplicate records, views, and fields safely
• Validate formulas before applying them
• Tool profiles: read‑only, safe‑write, full, custom

Use cases of Airtable Mcp Server

• Extend an AI assistant’s Airtable capabilities beyond the official REST API limits
• Create or modify schema elements (fields, views) that the REST API does not support
• Validate Airtable formulas locally before deploying to a base
• Manage dashboards, extensions, sidebar sections, and record templates programmatically
• Run two complementary MCP servers side‑by‑side for complete Airtable automation

FAQ from Airtable Mcp Server

How does it differ from the official Airtable MCP?

It is an additive, complementary server that uses Airtable’s internal API for schema, views, formulas, and extensions — areas the official REST API cannot reach. The official MCP handles records over HTTP; this server handles everything else over local stdio.

What transport does it use?

Stdio (local). Data never leaves your machine; requests are made directly to Airtable’s internal API.

How do I authenticate?

Run npx -y airtable-user-mcp login in a terminal. It opens a browser window for your normal Airtable login (supports SSO and 2FA). Credentials are stored in your OS keychain and auto‑refreshed.

What are the runtime dependencies?

Node.js via npx. No separate Airtable plan is required beyond being able to log in.

Are there safety guards for destructive actions?

Yes. Tools that rename, duplicate, or delete fields/views require an expectedName parameter to confirm the target, and a dependency preview is shown. A force flag can bypass the guard when needed.