Airtable MCP Files

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
2. Significantly improves performance for bulk data entry
3. Maintains atomicity - all records created or none

4. Proper error handling for validation failures

5. batch_update_records - Update up to 10 records at once

6. Efficient bulk updates with field-level precision
7. Maintains data integrity across operations

8. Returns detailed success/failure information

9. batch_delete_records - Delete up to 10 records in one operation

10. Fast bulk deletion with safety validation
11. Atomic operation ensures consistency

12. Detailed deletion confirmation

13. batch_upsert_records - Smart update-or-create operations

14. Updates existing records or creates new ones based on key fields
15. Intelligent matching using specified key fields
16. Optimizes data synchronization workflows

📎 Attachment Management (1 New Tool)

1. upload_attachment - Attach files from URLs to records
2. Supports any publicly accessible file URL
3. Automatic file type detection and validation
4. Optional custom filename specification
5. Works with all Airtable-supported file types

👁️ Advanced View Management (2 New Tools)

1. create_view - Create custom views programmatically
2. Support for all view types: grid, form, calendar, gallery, kanban, timeline, gantt
3. Custom field visibility and ordering
4. Configurable filters and sorts

5. Automated view setup for workflows

6. get_view_metadata - Detailed view configuration retrieval

7. Complete view settings and configurations
8. Filter formulas and sort specifications
9. Field visibility and ordering information
10. Perfect for view replication and analysis

🏢 Base Management (3 New Tools)

1. create_base - Create new Airtable bases
2. Programmatic base creation with initial table structures
3. Support for workspace organization
4. Batch table and field creation

5. Perfect for template deployment

6. list_collaborators - View base collaboration details

7. Complete collaborator list with permission levels
8. User type identification (user, group, etc.)
9. Permission auditing and management

10. Security compliance support

11. 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.