home / mcp / airtable mcp server

Airtable MCP Server

Provides full Airtable API access via MCP for bases, tables, fields, records, views, and webhooks with enterprise features.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "loticdigital-airtable-mcp": {
      "command": "npx",
      "args": [
        "@loticdigital/airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "YOUR_API_KEY"
      }
    }
  }
}

You set up and run an MCP server that exposes Airtable’s web API through a scalable, automated interface. This server lets you manage bases, tables, fields, records, views, and webhooks, with enterprise features for large organizations. You can use it from MCP clients to perform common data operations efficiently and securely.

How to use

You connect an MCP client to the Airtable MCP Server to perform create, read, update, and delete operations across bases, tables, and records. Start the server locally or remotely, then use your client to list bases, fetch schemas, manage records in batches, and subscribe to webhooks for real-time changes. You can also create and manage views, fields, and tables, as well as configure webhooks for notifications.

How to install

Prerequisites: you need Node.js and npm installed on your system. Verify Node.js and npm are available in your shell.

node -v
npm -v

Install the Airtable MCP Server package globally or in your project using npm.

npm install @loticdigital/airtable-mcp-server

Set your Airtable API key as an environment variable to authorize requests.

export AIRTABLE_API_KEY=your_airtable_api_key_here

Additional setup and usage notes

To run and connect from an MCP client, you typically start the server via a standard MCP invocation and ensure your API key is available in the environment. When you configure your MCP client, point it at the local or remote MCP endpoint provided by the Airtable MCP Server. Expect rate limits, pagination handling, and batch operations to optimize performance when working with large datasets. Security features include token management, input validation, and audit logging for enterprise deployments.

Configuration and security notes

Environment variables control access and behavior. Keep your API key secure and avoid exposing it in client-side code. Use audit logs and access controls to manage who can read, write, or delete resources. If you operate at an enterprise scale, leverage the built-in bulk operations, data validation, and change tracking to maintain data integrity across teams.

Troubleshooting tips

If you encounter authentication errors, verify that AIRTABLE_API_KEY is correctly set in the environment where the MCP Server runs. If you see rate limit errors, respect the per-base rate limit and consider batching requests to reduce call frequency. For missing resources, check your base/table/record identifiers and permissions.

Tools and capabilities overview

This server exposes a wide range of operations to manage Airtable resources. Core capabilities include: Base Management, Table Management, Field Management, Record Operations, View Management, Webhook Management, and Enterprise Features. You can list, create, update, and delete resources where permissions allow, perform advanced record queries, and receive real-time updates via webhooks.

Available tools

List Bases

Retrieve all bases accessible in a workspace for initial navigation and planning.

Get Base Schema

Fetch the complete structure of a base, including tables and fields.

Delete Base

Remove a base (enterprise permissions required).

List Tables

List all tables within a base.

Create Table

Create a new table with full field configurations.

Update Table

Modify table properties and metadata.

Delete Table

Delete a table with proper permissions.

List Fields

List all fields in a table.

Create Field

Add new fields across 25+ supported field types.

Update Field

Modify existing field properties and options.

Delete Field

Remove a field while considering data implications.

List Records

Retrieve records with basic options.

Advanced List Records

Apply filtering, sorting, pagination, and field selection.

Get Record

Fetch a single record by its identifier.

Create Record

Create new records.

Update Record

Modify existing records.

Delete Record

Remove records.

Batch Create Records

Create multiple records in a single request.

Batch Update Records

Update multiple records efficiently.

Batch Delete Records

Delete multiple records in one operation.

Search Records

Find records using field-based search criteria.

List Views

List all views in a table.

Get View

Retrieve a view configuration.

Create View

Create new views (grid, form, calendar, gallery, kanban, timeline, gantt).

Update View

Modify view properties, filters, and sorting.

Delete View

Remove views.

List Webhooks

Get all webhooks for a base.

Create Webhook

Set up real-time notifications.

Update Webhook

Modify webhook configuration.

Delete Webhook

Remove webhook subscriptions.

Get Webhook Payloads

Retrieve webhook notification history.