airtable-mcp-server
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Integrations
Provides read and write access to Airtable databases, allowing LLMs to inspect database schemas, read and write records. Features include listing bases and tables, searching and filtering records, creating/updating/deleting records, and managing table schemas.
airtable-mcp-server
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
Usage
To use this server with the Claude Desktop app, add the following configuration to the "mcpServers" section of your claude_desktop_config.json
:
Replace pat123.abc123
with your Airtable personal access token. Your token should have at least schema.bases:read
and data.records:read
, and optionally the corresponding write permissions.
Components
Tools
- list_records
- Lists records from a specified Airtable table
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the table to querymaxRecords
(number, optional): Maximum number of records to return. Defaults to 100.filterByFormula
(string, optional): Airtable formula to filter records
- search_records
- Search for records containing specific text
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the table to querysearchTerm
(string, required): Text to search for in recordsfieldIds
(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.
- list_bases
- Lists all accessible Airtable bases
- No input parameters required
- Returns base ID, name, and permission level
- list_tables
- Lists all tables in a specific base
- Input parameters:
baseId
(string, required): The ID of the Airtable basedetailLevel
(string, optional): The amount of detail to get about the tables (tableIdentifiersOnly
,identifiersOnly
, orfull
)
- Returns table ID, name, description, fields, and views (to the given
detailLevel
)
- describe_table
- Gets detailed information about a specific table
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the table to describedetailLevel
(string, optional): The amount of detail to get about the table (tableIdentifiersOnly
,identifiersOnly
, orfull
)
- Returns the same format as list_tables but for a single table
- Useful for getting details about a specific table without fetching information about all tables in the base
- get_record
- Gets a specific record by ID
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the tablerecordId
(string, required): The ID of the record to retrieve
- create_record
- Creates a new record in a table
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the tablefields
(object, required): The fields and values for the new record
- update_records
- Updates one or more records in a table
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the tablerecords
(array, required): Array of objects containing record ID and fields to update
- delete_records
- Deletes one or more records from a table
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the tablerecordIds
(array, required): Array of record IDs to delete
- create_table
- Creates a new table in a base
- Input parameters:
baseId
(string, required): The ID of the Airtable basename
(string, required): Name of the new tabledescription
(string, optional): Description of the tablefields
(array, required): Array of field definitions (name, type, description, options)
- update_table
- Updates a table's name or description
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the tablename
(string, optional): New name for the tabledescription
(string, optional): New description for the table
- create_field
- Creates a new field in a table
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the tablename
(string, required): Name of the new fieldtype
(string, required): Type of the fielddescription
(string, optional): Description of the fieldoptions
(object, optional): Field-specific options
- update_field
- Updates a field's name or description
- Input parameters:
baseId
(string, required): The ID of the Airtable basetableId
(string, required): The ID of the tablefieldId
(string, required): The ID of the fieldname
(string, optional): New name for the fielddescription
(string, optional): New description for the field
Resources
The server provides schema information for Airtable bases and tables:
- Table Schemas (
airtable://<baseId>/<tableId>/schema
)- JSON schema information for each table
- Includes:
- Base id and table id
- Table name and description
- Primary field ID
- Field definitions (ID, name, type, description, options)
- View definitions (ID, name, type)
- Automatically discovered from Airtable's metadata API
Contributing
Pull requests are welcomed on GitHub! To get started:
- Install Git and Node.js
- Clone the repository
- Install dependencies with
npm install
- Run
npm run test
to run tests - Build with
npm run build
- You can use
npm run build:watch
to automatically build after editingsrc/index.ts
. This means you can hit save, reload Claude Desktop (with Ctrl/Cmd+R), and the changes apply.
Releases
Versions follow the semantic versioning spec.
To release:
- Use
npm version <major | minor | patch>
to bump the version - Run
git push --follow-tags
to push with tags - Wait for GitHub Actions to publish to the NPM registry.
This server cannot be installed
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.