Airtable

by domdomegg

Recommended

111 stars

12k downloads

Not rated

GitHub Website

About

Provides read and write access to Airtable databases.

Details

Author: domdomegg
Repository: domdomegg/airtable-mcp-server
GitHub stars: 111
Downloads: 12,034
License: MIT License
Categories: Database, Community, Other, Search
Tags: #booking, #airtable

Setting up with Highlight

Follow these steps to add this server as a custom Highlight plugin:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below
Plugin Name Airtable

Command (node, npx, python, etc.) npx
Arguments
- Argument 1 airtable-mcp-server
Environment
- PORT 3000
- MCP_TRANSPORT http
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "/c",
                "npx",
                "airtable-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "/c",
                "npx",
                "airtable-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "/c",
                "npx",
                "airtable-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "/c",
                "npx",
                "airtable-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "/c",
                "npx",
                "airtable-mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

From the repository

Install via the generated config link or by running npx airtable-mcp-server. You must set the environment variable AIRTABLE_API_KEY to an Airtable personal access token with the appropriate scopes (at minimum schema.bases:read and data.records:read). The server exposes multiple tools for interacting with Airtable bases, tables, records, fields, and comments.

`list_records`

Lists records from a specified Airtable table. Parameters: baseId (string, required), tableId (string, required), maxRecords (number, optional), filterByFormula (string, optional)

`search_records`

Search for records containing specific text. Parameters: baseId (string, required), tableId (string, required), searchTerm (string, required), fieldIds (array, optional), maxRecords (number, optional)

`list_bases`

Lists all accessible Airtable bases. No input parameters required.

`list_tables`

Lists all tables in a specific base. Parameters: baseId (string, required), detailLevel (string, optional)

`describe_table`

Gets detailed information about a specific table. Parameters: baseId (string, required), tableId (string, required), detailLevel (string, optional)

`get_record`

Gets a specific record by ID. Parameters: baseId (string, required), tableId (string, required), recordId (string, required)

`create_record`

Creates a new record in a table. Parameters: baseId (string, required), tableId (string, required), fields (object, required)

`update_records`

Updates one or more records in a table. Parameters: baseId (string, required), tableId (string, required), records (array, required)

`delete_records`

Deletes one or more records from a table. Parameters: baseId (string, required), tableId (string, required), recordIds (array, required)

`create_table`

Creates a new table in a base. Parameters: baseId (string, required), name (string, required), description (string, optional), fields (array, required)

`update_table`

Updates a table's name or description. Parameters: baseId (string, required), tableId (string, required), name (string, optional), description (string, optional)

`create_field`

Creates a new field in a table. Parameters: baseId (string, required), tableId (string, required), name (string, required), type (string, required), description (string, optional), options (object, optional)

`update_field`

Updates a field's name or description. Parameters: baseId (string, required), tableId (string, required), fieldId (string, required), name (string, optional), description (string, optional)

`create_comment`

Creates a comment on a record. Parameters: baseId (string, required), tableId (string, required), recordId (string, required), text (string, required), parentCommentId (string, optional)

`list_comments`

Lists comments on a record. Parameters: baseId (string, required), tableId (string, required), recordId (string, required), pageSize (number, optional), offset (string, optional)

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "airtable": {
            "env": {
                "PORT": "3000",
                "MCP_TRANSPORT": "http"
            },
            "args": [
                "airtable-mcp-server"
            ],
            "command": "npx"
        }
    }
}

Linux

{
    "env": {
        "PORT": "3000",
        "MCP_TRANSPORT": "http"
    },
    "args": [
        "airtable-mcp-server"
    ],
    "command": "npx"
}

Macos

{
    "env": {
        "PORT": "3000",
        "MCP_TRANSPORT": "http"
    },
    "args": [
        "airtable-mcp-server"
    ],
    "command": "npx"
}

Windows

{
    "env": {
        "PORT": "3000",
        "MCP_TRANSPORT": "http"
    },
    "args": [
        "/c",
        "npx",
        "airtable-mcp-server"
    ],
    "command": "cmd"
}

A Model Context Protocol server that provides read and write access to Airtable databases. This server enables LLMs to inspect database schemas, then read and write records.

https://github.com/user-attachments/assets/c8285e76-d0ed-4018-94c7-20535db6c944

Follow the instructions on install-mcp, which generates the right config for your MCP client (Claude Code, Claude Desktop, Cursor, Cline, VS Code, and more).

You'll need an Airtable personal access token —create one herewith scopesschema.bases:readanddata.records:read(and optionallyschema.bases:write,data.records:write,data.recordComments:read,data.recordComments:write), and access to the bases you want to use. It looks something likepat123.abc123(but longer). Set it asAIRTABLE_API_KEY(replacing the placeholder in the generated config).

- Lists records from a specified Airtable table
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table to query
- maxRecords(number, optional): Maximum number of records to return. Defaults to 100.
- filterByFormula(string, optional): Airtable formula to filter records

- Search for records containing specific text
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table to query
- searchTerm(string, required): Text to search for in records
- fieldIds(array, optional): Specific field IDs to search in. If not provided, searches all text-based fields.
- maxRecords(number, optional): Maximum number of records to return. Defaults to 100.

- Lists all accessible Airtable bases
- No input parameters required
- Returns base ID, name, and permission level

- Lists all tables in a specific base
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- detailLevel(string, optional): The amount of detail to get about the tables (tableIdentifiersOnly,identifiersOnly, orfull)

- Gets detailed information about a specific table
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table to describe
- detailLevel(string, optional): The amount of detail to get about the table (tableIdentifiersOnly,identifiersOnly, orfull)

- Gets a specific record by ID
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- recordId(string, required): The ID of the record to retrieve

- Creates a new record in a table
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- fields(object, required): The fields and values for the new record

- Updates one or more records in a table
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- records(array, required): Array of objects containing record ID and fields to update

- Deletes one or more records from a table
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- recordIds(array, required): Array of record IDs to delete

- Creates a new table in a base
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- name(string, required): Name of the new table
- description(string, optional): Description of the table
- fields(array, required): Array of field definitions (name, type, description, options)

- Updates a table's name or description
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- name(string, optional): New name for the table
- description(string, optional): New description for the table

- Creates a new field in a table
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- name(string, required): Name of the new field
- type(string, required): Type of the field
- description(string, optional): Description of the field
- options(object, optional): Field-specific options

- Updates a field's name or description
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- fieldId(string, required): The ID of the field
- name(string, optional): New name for the field
- description(string, optional): New description for the field

- Creates a comment on a record
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- recordId(string, required): The ID of the record
- text(string, required): The comment text
- parentCommentId(string, optional): Parent comment ID for threaded replies

- Lists comments on a record
- Input parameters:

- baseId(string, required): The ID of the Airtable base
- tableId(string, required): The ID of the table
- recordId(string, required): The ID of the record
- pageSize(number, optional): Number of comments to return (max 100, default 100)
- offset(string, optional): Pagination offset for retrieving additional comments

The server can also run in HTTP mode for use with remote MCP clients:

MCP_TRANSPORT=http PORT=3000 npx airtable-mcp-server

This starts a stateless HTTP server athttp://localhost:3000/mcp.

[!WARNING] The HTTP transport has no built-in authentication, and binding to localhost or a private network isnota security boundary against browsers: a malicious website can useDNS rebindingto make a visitor's browser send requests tohttp://localhost:3000/mcpand invoke tools — including reading, writing and deleting records — using this server's Airtable token.

Only run HTTP mode where untrusted callers (including browsers on the same machine or network) cannot reach/mcpwithout authenticating. In practice that means putting it behind a reverse proxy or gateway that requires a credential a browser won't attach cross-origin, such as anAuthorizationheader.

If you just want to use this server with an MCP client on the same machine, use the default stdio transport instead — it doesn't open a port at all.

Pull requests are welcomed on GitHub! To get started:
- Install Git and Node.js
- Clone the repository
- Install dependencies withnpm install
- Runnpm run testto run tests
- Build withnpm run build

- You can usenpm run build:watchto automatically build after editing src/index.ts. This means you can hit save, reload Claude Desktop (with Ctrl/Cmd+R), and the changes apply.

Versions follow the semantic versioning spec.
- Usenpm version <major | minor | patch>to bump the version
- Rungit push --follow-tagsto push with tags
- Wait for GitHub Actions to publish to the NPM registry.

BigQuery database integration with schema inspection and query capabilities

Server implementation for Google BigQuery integration that enables direct BigQuery database access and querying capabilities

A MCP server that provides real-time cryptocurrency market data through CoinCap's public API without requiring authentication

Universal database MCP server supporting multiple database types including PostgreSQL, Redshift, CockroachDB, MySQL, RDS MySQL, Microsoft SQL Server, BigQuery, Oracle DB, and SQLite

MCP server for autonomous data exploration on .csv-based datasets, providing intelligent insights with minimal effort.

Universal database MCP server supporting mainstream databases.

MCP server for dbt-core (OSS) users as the official dbt MCP only supports dbt Cloud. Supports project metadata, model and column-level lineage and dbt documentation.

Leverages your Schemas and Access Patterns to interact with your DynamoDB Database using natural language.

MCP server acting as an interface to the Frankfurter API for currency exchange data.

MCP server for libSQL databases with comprehensive security and management tools. Supports file, local HTTP, and remote Turso databases with connection pooling, transaction support, and 6 specialized database tools.

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

list_records

search_records

list_bases

list_tables

describe_table

get_record

create_record

update_records

delete_records

create_table

update_table

create_field

update_field

create_comment

list_comments

Claude Desktop / Cursor

Linux

Macos

Windows

Install

More like this

Sequential Thinking

Redis

Filesystem

EverArt

Google Drive

Sqlite

`list_records`

`search_records`

`list_bases`

`list_tables`

`describe_table`

`get_record`

`create_record`

`update_records`

`delete_records`

`create_table`

`update_table`

`create_field`

`update_field`

`create_comment`

`list_comments`