Airtable MCP Server
A Model Context Protocol (MCP) server for Airtable, designed to integrate with AI-powered applications and n8n workflows. This server provides a standardized interface for interacting with Airtable bases, tables, and records.
🚀 Features
- 16 Core Tools: Complete CRUD operations for Airtable
- Batch Operations: Create, update, and delete multiple records at once
- Schema Management: Access table, field, and view information
- HTTP Streamable: Compatible with n8n and other HTTP-based MCP clients
- TypeScript: Full type safety and modern JavaScript features
- Render Ready: Pre-configured for deployment on Render
🛠️ Available Tools
Base Operations
get_base_info- Get information about the Airtable baselist_tables- List all tables in the base
Table Operations
get_table_info- Get detailed table informationlist_fields- List all fields in a tableget_field_info- Get detailed field information
Record Operations
list_records- List records with filtering, sorting, and paginationget_record- Get a specific record by IDcreate_record- Create a new recordupdate_record- Update an existing recorddelete_record- Delete a record
Batch Operations
create_records- Create multiple records (up to 10)update_records- Update multiple records (up to 10)delete_records- Delete multiple records (up to 10)
View Operations
list_views- List all views for a tableget_view_info- Get detailed view information
🚀 Quick Start
Prerequisites
- Node.js 20+
- Airtable API key
- Airtable base ID
Installation
-
Clone the repository
git clone https://github.com/jjwjr94/airtable-mcp.git cd airtable-mcp -
Install dependencies
npm install -
Set up environment variables
cp env.example .env # Edit .env with your Airtable credentials -
Start the development server
npm run dev:http
Environment Variables
# Server Configuration
NODE_ENV=development
PORT=3000
# Airtable Configuration
AIRTABLE_API_KEY=your_airtable_api_key_here
AIRTABLE_BASE_ID=your_base_id_here
🔧 Usage
HTTP Server (Recommended for n8n)
The HTTP server runs on port 3000 by default and provides these endpoints:
- Health Check:
GET /health - MCP Endpoint:
POST /mcp - Set Credentials:
POST /set-credentials
Headers Required
For all MCP requests, include these headers:
x-airtable-api-key: YOUR_API_KEY
x-airtable-base-id: YOUR_BASE_ID
Example MCP Request
curl -X POST http://localhost:3000/mcp \
-H "Content-Type: application/json" \
-H "x-airtable-api-key: YOUR_API_KEY" \
-H "x-airtable-base-id: YOUR_BASE_ID" \
-d '{
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"name": "list_tables",
"arguments": {}
},
"id": "1"
}'
🚀 Deployment
Render (Recommended)
- Fork this repository
- Connect to Render
- Deploy as a Web Service
- Set environment variables in Render dashboard
The render.yaml file is pre-configured for easy deployment.
Environment Variables for Production
NODE_ENV=production
PORT=10000
🧪 Testing
Run Tests
# Start the server first
npm run dev:http
# In another terminal, run tests
npm test
Test Individual Endpoints
# Health check
curl http://localhost:3000/health
# List tools
curl -X POST http://localhost:3000/mcp \
-H "Content-Type: application/json" \
-H "x-airtable-api-key: YOUR_API_KEY" \
-H "x-airtable-base-id: YOUR_BASE_ID" \
-d '{"jsonrpc":"2.0","method":"tools/list","params":{},"id":"1"}'
🔌 n8n Integration
HTTP Request Node Configuration
- Method: POST
- URL:
https://your-render-app.onrender.com/mcp - Headers:
Content-Type: application/jsonx-airtable-api-key: {{ $json.apiKey }}x-airtable-base-id: {{ $json.baseId }}
- Body:
{ "jsonrpc": "2.0", "method": "tools/call", "params": { "name": "list_tables", "arguments": {} }, "id": "{{ $json.requestId }}" }
Example n8n Workflow
- Set node to configure Airtable credentials
- HTTP Request node to call MCP tools
- Switch node to handle different tool responses
- Process node to format data for your needs
📚 API Reference
Tool: list_records
List records from a table with optional filtering and pagination.
Parameters:
tableId(required): The ID of the tablepageSize(optional): Number of records to return (max 100)filterByFormula(optional): Airtable formula to filter recordssort(optional): Sorting configurationfields(optional): Specific fields to returnview(optional): View ID to use
Example:
{
"name": "list_records",
"arguments": {
"tableId": "tblXXXXXXXXXXXXXX",
"pageSize": 50,
"filterByFormula": "{Status} = 'Active'",
"sort": [{"field": "Name", "direction": "asc"}],
"fields": ["Name", "Status", "Created"]
}
}
Tool: create_record
Create a new record in a table.
Parameters:
tableId(required): The ID of the tablefields(required): The field values for the new record
Example:
{
"name": "create_record",
"arguments": {
"tableId": "tblXXXXXXXXXXXXXX",
"fields": {
"Name": "New Project",
"Status": "Active",
"Priority": "High"
}
}
}
🔒 Security
- CORS: Configured for Render and n8n domains
- Helmet: Security headers enabled
- Input Validation: All inputs are validated
- Error Handling: Secure error messages
🚀 Development
Scripts
npm run build # Build TypeScript
npm run start # Start production server
npm run start:http # Start HTTP server
npm run dev # Development mode
npm run dev:http # HTTP development mode
npm run watch # Watch mode for TypeScript
npm test # Run tests
npm run inspector # MCP inspector
Project Structure
airtable-mcp/
├── src/
│ ├── airtable-client-wrapper.ts # Airtable API client
│ ├── tool-handler.ts # MCP tool definitions
│ └── version.ts # Version information
├── index.ts # Standard MCP server
├── index-http.ts # HTTP server
├── test-http-server.js # Test suite
├── render.yaml # Render deployment config
└── package.json # Dependencies and scripts
🤝 Contributing
- Fork the repository
- Create a feature branch
- Make your changes
- Add tests if applicable
- Submit a pull request
📄 License
MIT License - see LICENSE file for details.
🙏 Acknowledgments
- Built for the Model Context Protocol
- Powered by Airtable API
- Compatible with Claude Desktop and other MCP clients
- Designed for n8n integration
📞 Support
- Issues: GitHub Issues
- Discussions: GitHub Discussions
Version: 1.0.0 | Status: 🚀 Production Ready | MCP Protocol: 2025-06-18 | Type Safety: Full TypeScript | Last Updated: January 2025