Airtable MCP Server

1# airtable-mcp-server
2 
3A 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.
4 
5https://github.com/user-attachments/assets/c8285e76-d0ed-4018-94c7-20535db6c944
6 
7## Installation
8 
9**Step 1**: [Create an Airtable personal access token by clicking here](https://airtable.com/create/tokens/new). Details:
10- Name: Anything you want e.g. 'Airtable MCP Server Token'.
11- Scopes: `schema.bases:read`, `data.records:read`, and optionally `schema.bases:write`, `data.records:write`, `data.recordComments:read`, and `data.recordComments:write`.
12- Access: The bases you want to access. If you're not sure, select 'Add all resources'.
13 
14Keep the token handy, you'll need it in the next step. It should look something like `pat123.abc123` (but longer).
15 
16**Step 2**: Follow the instructions below for your preferred client:
17 
18- [Claude Desktop](#claude-desktop)
19- [Cursor](#cursor)
20- [Cline](#cline)
21 
22### Claude Desktop
23 
24#### (Recommended) Via the extensions browser
25 
261. Open Claude Desktop and go to Settings → Extensions
272. Click 'Browse Extensions' and find 'Airtable MCP Server'
283. Click 'Install' and paste in your API key
29 
30#### (Advanced) Alternative: Via manual .mcpb installation
31 
321. Find the latest mcpb build in [the GitHub Actions history](https://github.com/domdomegg/airtable-mcp-server/actions/workflows/mcpb.yaml?query=branch%3Amaster) (the top one)
332. In the 'Artifacts' section, download the `airtable-mcp-server-mcpb` file
343. Rename the `.zip` file to `.mcpb`
354. Double-click the `.mcpb` file to open with Claude Desktop
365. Click "Install" and configure with your API key
37 
38#### (Advanced) Alternative: Via JSON configuration
39 
401. Install [Node.js](https://nodejs.org/en/download)
412. Open Claude Desktop and go to Settings → Developer
423. Click "Edit Config" to open your `claude_desktop_config.json` file
434. Add the following configuration to the "mcpServers" section, replacing `pat123.abc123` with your API key:
44 
45```json
46{
47  "mcpServers": {
48    "airtable": {
49      "command": "npx",
50      "args": [
51        "-y",
52        "airtable-mcp-server"
53      ],
54      "env": {
55        "AIRTABLE_API_KEY": "pat123.abc123",
56      }
57    }
58  }
59}
60```
61 
625. Save the file and restart Claude Desktop
63 
64### Cursor
65 
66#### (Recommended) Via one-click install
67 
681. Click [![Install MCP Server](https://cursor.com/deeplink/mcp-install-dark.svg)](https://cursor.com/install-mcp?name=airtable&config=JTdCJTIyY29tbWFuZCUyMiUzQSUyMm5weCUyMC15JTIwYWlydGFibGUtbWNwLXNlcnZlciUyMiUyQyUyMmVudiUyMiUzQSU3QiUyMkFJUlRBQkxFX0FQSV9LRVklMjIlM0ElMjJwYXQxMjMuYWJjMTIzJTIyJTdEJTdE)
692. Edit your `mcp.json` file to insert your API key
70 
71#### (Advanced) Alternative: Via JSON configuration
72 
73Create either a global (`~/.cursor/mcp.json`) or project-specific (`.cursor/mcp.json`) configuration file, replacing `pat123.abc123` with your API key:
74 
75```json
76{
77  "mcpServers": {
78    "airtable": {
79      "command": "npx",
80      "args": ["-y", "airtable-mcp-server"],
81      "env": {
82        "AIRTABLE_API_KEY": "pat123.abc123"
83      }
84    }
85  }
86}
87```
88 
89### Cline
90 
91#### (Recommended) Via marketplace
92 
931. Click the "MCP Servers" icon in the Cline extension
942. Search for "Airtable" and click "Install"
953. Follow the prompts to install the server
96 
97#### (Advanced) Alternative: Via JSON configuration
98 
991. Click the "MCP Servers" icon in the Cline extension
1002. Click on the "Installed" tab, then the "Configure MCP Servers" button at the bottom
1013. Add the following configuration to the "mcpServers" section, replacing `pat123.abc123` with your API key:
102 
103```json
104{
105  "mcpServers": {
106    "airtable": {
107      "type": "stdio",
108      "command": "npx",
109      "args": ["-y", "airtable-mcp-server"],
110      "env": {
111        "AIRTABLE_API_KEY": "pat123.abc123"
112      }
113    }
114  }
115}
116```
117 
118## Components
119 
120### Tools
121 
122- **list_records**
123  - Lists records from a specified Airtable table
124  - Input parameters:
125    - `baseId` (string, required): The ID of the Airtable base
126    - `tableId` (string, required): The ID of the table to query
127    - `maxRecords` (number, optional): Maximum number of records to return. Defaults to 100.
128    - `filterByFormula` (string, optional): Airtable formula to filter records
129 
130- **search_records**
131  - Search for records containing specific text
132  - Input parameters:
133    - `baseId` (string, required): The ID of the Airtable base
134    - `tableId` (string, required): The ID of the table to query
135    - `searchTerm` (string, required): Text to search for in records
136    - `fieldIds` (array, optional): Specific field IDs to search in. If not provided, searches all text-based fields.
137    - `maxRecords` (number, optional): Maximum number of records to return. Defaults to 100.
138 
139- **list_bases**
140  - Lists all accessible Airtable bases
141  - No input parameters required
142  - Returns base ID, name, and permission level
143 
144- **list_tables**
145  - Lists all tables in a specific base
146  - Input parameters:
147    - `baseId` (string, required): The ID of the Airtable base
148    - `detailLevel` (string, optional): The amount of detail to get about the tables (`tableIdentifiersOnly`, `identifiersOnly`, or `full`)
149  - Returns table ID, name, description, fields, and views (to the given `detailLevel`)
150 
151- **describe_table**
152  - Gets detailed information about a specific table
153  - Input parameters:
154    - `baseId` (string, required): The ID of the Airtable base
155    - `tableId` (string, required): The ID of the table to describe
156    - `detailLevel` (string, optional): The amount of detail to get about the table (`tableIdentifiersOnly`, `identifiersOnly`, or `full`)
157  - Returns the same format as list_tables but for a single table
158  - Useful for getting details about a specific table without fetching information about all tables in the base
159 
160- **get_record**
161  - Gets a specific record by ID
162  - Input parameters:
163    - `baseId` (string, required): The ID of the Airtable base
164    - `tableId` (string, required): The ID of the table
165    - `recordId` (string, required): The ID of the record to retrieve
166 
167- **create_record**
168  - Creates a new record in a table
169  - Input parameters:
170    - `baseId` (string, required): The ID of the Airtable base
171    - `tableId` (string, required): The ID of the table
172    - `fields` (object, required): The fields and values for the new record
173 
174- **update_records**
175  - Updates one or more records in a table
176  - Input parameters:
177    - `baseId` (string, required): The ID of the Airtable base
178    - `tableId` (string, required): The ID of the table
179    - `records` (array, required): Array of objects containing record ID and fields to update
180 
181- **delete_records**
182  - Deletes one or more records from a table
183  - Input parameters:
184    - `baseId` (string, required): The ID of the Airtable base
185    - `tableId` (string, required): The ID of the table
186    - `recordIds` (array, required): Array of record IDs to delete
187 
188- **create_table**
189  - Creates a new table in a base
190  - Input parameters:
191    - `baseId` (string, required): The ID of the Airtable base
192    - `name` (string, required): Name of the new table
193    - `description` (string, optional): Description of the table
194    - `fields` (array, required): Array of field definitions (name, type, description, options)
195 
196- **update_table**
197  - Updates a table's name or description
198  - Input parameters:
199    - `baseId` (string, required): The ID of the Airtable base
200    - `tableId` (string, required): The ID of the table
201    - `name` (string, optional): New name for the table
202    - `description` (string, optional): New description for the table
203 
204- **create_field**
205  - Creates a new field in a table
206  - Input parameters:
207    - `baseId` (string, required): The ID of the Airtable base
208    - `tableId` (string, required): The ID of the table
209    - `name` (string, required): Name of the new field
210    - `type` (string, required): Type of the field
211    - `description` (string, optional): Description of the field
212    - `options` (object, optional): Field-specific options
213 
214- **update_field**
215  - Updates a field's name or description
216  - Input parameters:
217    - `baseId` (string, required): The ID of the Airtable base
218    - `tableId` (string, required): The ID of the table
219    - `fieldId` (string, required): The ID of the field
220    - `name` (string, optional): New name for the field
221    - `description` (string, optional): New description for the field
222 
223- **create_comment**
224  - Creates a comment on a record
225  - Input parameters:
226    - `baseId` (string, required): The ID of the Airtable base
227    - `tableId` (string, required): The ID of the table
228    - `recordId` (string, required): The ID of the record
229    - `text` (string, required): The comment text
230    - `parentCommentId` (string, optional): Parent comment ID for threaded replies
231  - Returns the created comment with ID, author, creation time, and text
232 
233- **list_comments**
234  - Lists comments on a record
235  - Input parameters:
236    - `baseId` (string, required): The ID of the Airtable base
237    - `tableId` (string, required): The ID of the table
238    - `recordId` (string, required): The ID of the record
239    - `pageSize` (number, optional): Number of comments to return (max 100, default 100)
240    - `offset` (string, optional): Pagination offset for retrieving additional comments
241  - Returns comments array with author, text, timestamps, reactions, and mentions
242  - Comments are returned from newest to oldest
243 
244### HTTP Transport
245 
246The server can also run in HTTP mode for use with remote MCP clients:
247 
248```bash
249MCP_TRANSPORT=http PORT=3000 npx airtable-mcp-server
250```
251 
252This starts a stateless HTTP server at `http://localhost:3000/mcp`. Note: HTTP transport has no built-in authentication - only use behind a reverse proxy or in a secured environment.
253 
254## Contributing
255 
256Pull requests are welcomed on GitHub! To get started:
257 
2581. Install Git and Node.js
2592. Clone the repository
2603. Install dependencies with `npm install`
2614. Run `npm run test` to run tests
2625. Build with `npm run build`
263  - You can use `npm run build:watch` to automatically build after editing [`src/index.ts`](./src/index.ts). This means you can hit save, reload Claude Desktop (with Ctrl/Cmd+R), and the changes apply.
264 
265## Releases
266 
267Versions follow the [semantic versioning spec](https://semver.org/).
268 
269To release:
270 
2711. Use `npm version <major | minor | patch>` to bump the version
2722. Run `git push --follow-tags` to push with tags
2733. Wait for GitHub Actions to publish to the NPM registry.
274