Airtable MCP

# 🚀 Airtable MCP Server v1.6.0 Release Notes **Release Date**: August 15, 2025 **Major Update**: Batch Operations, Attachment Management & Advanced Features ## 🎯 Overview Version 1.6.0 represents another **major expansion** of the Airtable MCP Server, adding powerful batch operations, attachment management, and advanced base management capabilities. This release increases the total tools from 23 to **33 tools**, providing the most comprehensive Airtable API coverage available for AI assistants. ## ✨ New Features (10 New Tools) ### ⚡ Batch Operations (4 New Tools) 1. **`batch_create_records`** - Create up to 10 records simultaneously - Significantly improves performance for bulk data entry - Maintains atomicity - all records created or none - Proper error handling for validation failures 2. **`batch_update_records`** - Update up to 10 records at once - Efficient bulk updates with field-level precision - Maintains data integrity across operations - Returns detailed success/failure information 3. **`batch_delete_records`** - Delete up to 10 records in one operation - Fast bulk deletion with safety validation - Atomic operation ensures consistency - Detailed deletion confirmation 4. **`batch_upsert_records`** - Smart update-or-create operations - Updates existing records or creates new ones based on key fields - Intelligent matching using specified key fields - Optimizes data synchronization workflows ### 📎 Attachment Management (1 New Tool) 5. **`upload_attachment`** - Attach files from URLs to records - Supports any publicly accessible file URL - Automatic file type detection and validation - Optional custom filename specification - Works with all Airtable-supported file types ### 👁️ Advanced View Management (2 New Tools) 6. **`create_view`** - Create custom views programmatically - Support for all view types: grid, form, calendar, gallery, kanban, timeline, gantt - Custom field visibility and ordering - Configurable filters and sorts - Automated view setup for workflows 7. **`get_view_metadata`** - Detailed view configuration retrieval - Complete view settings and configurations - Filter formulas and sort specifications - Field visibility and ordering information - Perfect for view replication and analysis ### 🏢 Base Management (3 New Tools) 8. **`create_base`** - Create new Airtable bases - Programmatic base creation with initial table structures - Support for workspace organization - Batch table and field creation - Perfect for template deployment 9. **`list_collaborators`** - View base collaboration details - Complete collaborator list with permission levels - User type identification (user, group, etc.) - Permission auditing and management - Security compliance support 10. **`list_shares`** - Manage shared view configurations - Public share URLs and settings - Share type and effectiveness status - View and table relationship mapping - Privacy and access control management ## 🔄 Enhanced Existing Features ### Performance Improvements - **Batch Operations**: Up to 10x faster for bulk operations - **Error Handling**: More detailed error messages and validation - **API Efficiency**: Reduced API calls through intelligent batching ### Security Enhancements - **Input Validation**: Enhanced parameter validation for all new tools - **Permission Checking**: Better handling of permission-restricted operations - **Safe Defaults**: Conservative defaults for destructive operations ### User Experience - **Better Error Messages**: More descriptive error responses - **Consistent Interface**: Uniform parameter naming across all tools - **Enhanced Documentation**: Detailed examples and use cases ## 📊 Tool Count Progression | Version | Total Tools | New Features | |---------|-------------|--------------| | **v1.6.0** | **33** | Batch ops, attachments, advanced views, base mgmt | | v1.5.0 | 23 | Schema management | | v1.4.0 | 12 | Webhooks | | v1.2.4 | 5 | Basic CRUD | ## 🛠️ Technical Improvements ### API Coverage - **Complete Airtable API**: Now covers virtually all public Airtable API endpoints - **Batch Endpoints**: Full support for Airtable's batch operation limits - **Metadata API**: Complete integration with Airtable's metadata capabilities ### Architecture - **Modular Design**: Clean separation of concerns for each tool category - **Error Resilience**: Improved error handling and recovery - **Performance Optimized**: Efficient API usage patterns ### Compatibility - **Backward Compatible**: All v1.5.0 tools unchanged - **API Limits**: Respects Airtable's rate limits and batch size restrictions - **Token Scopes**: Graceful handling of insufficient permissions ## 📚 New Capabilities ### For Users - **Bulk Data Operations**: Efficiently manage large datasets - **File Management**: Easy attachment handling through URLs - **Advanced Workflows**: Create complex multi-step processes - **Collaboration Insights**: Understand base sharing and permissions - **Template Creation**: Programmatically create standardized bases ### For Developers - **High-Performance Bulk Ops**: Optimize data synchronization - **Complete Base Lifecycle**: Full cradle-to-grave base management - **Advanced View Control**: Programmatic UI customization - **Security Auditing**: Comprehensive permission monitoring ## 🚀 Getting Started with v1.6.0 ### Installation ```bash npm install -g @rashidazarang/airtable-mcp@1.6.0 ``` ### New Usage Examples #### Batch Operations ```javascript // Create multiple records efficiently "Create 5 new project records with these details: [project data]" // Update multiple records at once "Update all records where status is 'pending' to 'in progress'" // Delete multiple records "Delete these 3 completed tasks: rec123, rec456, rec789" ``` #### Attachment Management ```javascript // Attach files to records "Attach this image https://example.com/image.jpg to the product photo field in record rec123" // Batch create with attachments "Create a new product record and attach the logo from this URL" ``` #### Advanced Views ```javascript // Create custom views "Create a calendar view for the Events table showing only future events" // Analyze view configurations "Show me the detailed configuration of the 'Active Projects' view" ``` #### Base Management ```javascript // Create new bases "Create a new base called 'Project Tracker' with tables for Projects, Tasks, and Team Members" // Collaboration insights "Who has access to this base and what are their permission levels?" ``` ## 🔧 Breaking Changes **None** - v1.6.0 maintains full backward compatibility with all previous versions. ## 🐛 Bug Fixes - **Batch Size Validation**: Proper enforcement of 10-record limits - **Error Message Clarity**: More descriptive API error responses - **Permission Handling**: Better graceful degradation for insufficient permissions - **URL Validation**: Enhanced validation for attachment URLs ## ⚡ Performance Improvements - **Batch Operations**: Up to 10x performance improvement for bulk operations - **API Efficiency**: Reduced API calls through intelligent batching - **Memory Usage**: Optimized memory usage for large operations - **Response Processing**: Faster JSON parsing and response handling ## 🌟 What's Next Based on user feedback and Airtable API evolution: - Enhanced search and filtering capabilities - Advanced automation triggers - Real-time collaboration features - Performance analytics and monitoring - Enterprise-grade security features ## 📈 Compatibility & Requirements - **Node.js**: Requires Node.js 14+ - **Airtable API**: Compatible with latest Airtable API version - **Rate Limits**: Respects Airtable's 5 requests/second limit - **Token Scopes**: Requires appropriate scopes for advanced features ### Required Scopes for Full Functionality - `data.records:read` - Read records - `data.records:write` - Create, update, delete records - `schema.bases:read` - View schemas and metadata - `schema.bases:write` - Create/modify tables, fields, views, bases - `webhook:manage` - Webhook operations (optional) ## 📊 Testing & Quality - **100% Test Coverage**: All 33 tools tested with real API calls - **Edge Case Handling**: Comprehensive error condition testing - **Performance Testing**: Batch operation efficiency verification - **Security Testing**: Permission and validation testing ## 🤝 Community Impact v1.6.0 establishes this MCP server as the definitive Airtable integration for AI assistants, providing: - **Most Comprehensive Coverage**: 33 tools covering entire Airtable API - **Best Performance**: Intelligent batching and optimization - **Enterprise Ready**: Advanced collaboration and security features - **Developer Friendly**: Clean, consistent, well-documented interface ## 🔗 Resources **GitHub**: https://github.com/rashidazarang/airtable-mcp **NPM**: https://www.npmjs.com/package/@rashidazarang/airtable-mcp **Issues**: https://github.com/rashidazarang/airtable-mcp/issues **Documentation**: https://github.com/rashidazarang/airtable-mcp#readme --- 🎉 **Thank you for using Airtable MCP Server v1.6.0!** This release represents the culmination of comprehensive Airtable API integration, providing AI assistants with unprecedented access to Airtable's full feature set through natural language interactions.