MCP Airtable Server

MCP server for Airtable integration. Enables AI assistants to perform CRUD operations, batch processing, file uploads (S3/GCS), smart upserts, and more.

typescript

GitHub Stars

typescript

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "marchi-lau-mcp-airtable": {
      "command": "node",
      "args": [
        "/path/to/mcp-airtable/dist/index.js"
      ],
      "env": {
        "AWS_REGION": "us-east-1",
        "AWS_S3_BUCKET": "your-bucket-name",
        "AIRTABLE_API_KEY": "your_api_key_here",
        "AIRTABLE_BASE_ID": "optional_default_base_id",
        "AWS_ACCESS_KEY_ID": "your-access-key",
        "AWS_SECRET_ACCESS_KEY": "your-secret-key"
      }
    }
  }
}

You can manage Airtable data with an MCP server that exposes tools to list bases and tables, read and write records, and work with base schemas. This makes it easy for AI assistants to interact with Airtable without embedding API calls directly in your prompts.

How to use

You interact with this MCP server through an MCP client. Start the local server and load it into your client configuration to perform operations against your Airtable bases. Use the provided tools to list bases, list tables, read records with optional filtering and sorting, create new records, update existing ones, delete records, and fetch schema information for bases. When you call an operation, you supply the required parameters (for example, table name and, where applicable, record identifiers or field values) and your client handles sending the request to the server.

How to install

# Prerequisites
- Node.js (and npm) installed on your machine

# 1) Install dependencies
npm install

# 2) Build the TypeScript code
npm run build

# 3) Start the server for development with hot reload
npm run dev

# 4) Start the server for production
npm start

Configuration

Before you run the server, set up your environment file and required credentials. Create a .env file and add your Airtable API key. You can also optionally set a default base ID so you don’t have to specify it for every request.

# Copy the example to your working env
cp .env.example .env

# Add your API key
AIRTABLE_API_KEY=your_api_key_here

# Optional: set a default base ID
AIRTABLE_BASE_ID=appXXXXXXXXXXXXXX

Security and best practices

Treat your API keys and authentication tokens as secrets. Do not commit them to version control. If you deploy remotely, ensure you use HTTPS and restrict access to trusted clients.

Examples

Common usage patterns include listing available bases, listing tables within a base, retrieving filtered records, and uploading attachments to records when needed.

Development

To contribute or customize, run the standard development workflow and ensure type checks and tests pass.

Available tools

list_bases

List all available Airtable bases you can access

list_tables

List all tables within a specific base (baseId optional)

get_records

Retrieve records from a table with optional filtering, sorting, and field selection

create_record

Create a new record in a table with specified fields

update_record

Update an existing record with new field values

delete_record

Delete a specified record from a table

get_schema

Get the schema information for a base

upload_attachment

Upload a file to S3 and obtain a URL suitable for Airtable attachment fields

Built by

VeilStrat

AI signals for GTM teams