An Airtable Model Context Protocol Server
npm install @felores/airtable-mcp-serverbash
Run directly (will install latest version)
npx airtable-server
Or specify a version
npx airtable-server@0.2.0
`
$3
After you have mcp-installer installed, you can install the Airtable MCP server by prompting Claude Desktop:
`bash
Install the MCP server: airtable-server. Set the environment variable AIRTABLE_API_KEY to 'your_airtable_api_key_here'
`
Claude will install the server, modify the configuration file and set the environment variable AIRTABLE_API_KEY to your Airtable API key.
$3
If you want to contribute or modify the code:
`bash
Clone the repository
git clone https://github.com/felores/airtable-mcp.git
cd airtable-mcp
Install dependencies
npm install
Build the server
npm run build
Run locally
node build/index.js
`
$3
1. Log in to your Airtable account at airtable.com
2. Create a personal access token at Airtable's Builder Hub
3. In the Personal access token section select these scopes:
- data.records:read
- data.records:write
- schema.bases:read
- schema.bases:write
4. Select the workspace or bases you want to give access to the personal access token
5. Keep this key secure - you'll need it for configuration
$3
1. Navigate to the Claude configuration directory:
- Windows: C:\Users\NAME\AppData\Roaming\Claude
- macOS: ~/Library/Application Support/Claude/
(You can also find these directories in Claude Desktop > Settings > Developer > Edit Config)
2. Create or edit claude_desktop_config.json:
For npx installation:
`json
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["airtable-server"],
"env": {
"AIRTABLE_API_KEY": "your_api_key_here"
}
}
}
}
`
For local installation:
`json
{
"mcpServers": {
"airtable": {
"command": "node",
"args": ["path/to/airtable-mcp/build/index.js"],
"env": {
"AIRTABLE_API_KEY": "your_api_key_here"
}
}
}
}
`
Note: For Windows paths, use double backslashes (\\) or forward slashes (/).
$3
1. Start Claude Desktop
2. The Airtable MCP server should be listed in the "Connected MCP Servers" section
3. Test with a simple command:
`
List all bases
`
Features
$3
#### Base Management
- list_bases: List all accessible Airtable bases
- list_tables: List all tables in a base
- create_table: Create a new table with fields
- update_table: Update a table's name or description
#### Field Management
- create_field: Add a new field to a table
- update_field: Modify an existing field
#### Record Operations
- list_records: Retrieve records from a table
- create_record: Add a new record
- update_record: Modify an existing record
- delete_record: Remove a record
- search_records: Find records matching criteria
- get_record: Get a single record by its ID
$3
- singleLineText: Single line text field
- multilineText: Multi-line text area
- email: Email address field
- phoneNumber: Phone number field
- number: Numeric field with optional precision
- currency: Money field with currency symbol
- date: Date field with format options
- singleSelect: Single choice from options
- multiSelect: Multiple choices from options
$3
Available colors for select fields:
- blueBright, redBright, greenBright
- yellowBright, purpleBright, pinkBright
- grayBright, cyanBright, orangeBright
- blueDark1, greenDark1
Contributing
We welcome contributions to improve the Airtable MCP server! Here's how you can contribute:
1. Fork the Repository
- Visit https://github.com/felores/airtable-mcp
- Click the "Fork" button in the top right
- Clone your fork locally:
`bash
git clone https://github.com/your-username/airtable-mcp.git
`
2. Create a Feature Branch
`bash
git checkout -b feature/your-feature-name
`
3. Make Your Changes
- Follow the existing code style
- Add tests if applicable
- Update documentation as needed
4. Commit Your Changes
`bash
git add .
git commit -m "feat: add your feature description"
`
5. Push to Your Fork
`bash
git push origin feature/your-feature-name
``