Provides tools for Airtable data management, including base and table operations, record creation, reading, updating, and deletion, schema management, and data filtering—all accessible through natural language commands.
Airtable MCP Server
🤖 Revolutionary AI Agent v3.1.0 - Advanced AI-powered Airtable MCP server with TypeScript support, comprehensive intelligence capabilities, predictive analytics, and enterprise automation features.
🚀 Latest: TypeScript Support v3.1.0
Enterprise-Grade Type Safety with full backward compatibility:
- 🔷 TypeScript Implementation - Complete type-safe server with strict validation
- 📘 Comprehensive Type Definitions - All 33 tools and 10 AI prompts fully typed
- 🛡️ Compile-Time Safety - Catch errors before runtime with advanced type checking
- 🎯 Developer Experience - IntelliSense, auto-completion, and refactoring support
- 🔄 Dual Distribution - Use with JavaScript or TypeScript, your choice
- 📖 Type Documentation - Self-documenting APIs through comprehensive type definitions
🤖 AI Intelligence Suite
Complete AI-Powered Intelligence with enterprise capabilities:
- 🤖 10 AI Prompt Templates - Advanced analytics, predictions, and automation
- 🔮 Predictive Analytics - Forecasting and trend analysis with confidence intervals
- 🗣️ Natural Language Processing - Query your data using human language
- 📊 Business Intelligence - Automated insights and recommendations
- 🏗️ Smart Schema Design - AI-optimized database architecture
- ⚡ Workflow Automation - Intelligent process optimization
- 🔍 Data Quality Auditing - Comprehensive quality assessment and fixes
- 📈 Statistical Analysis - Advanced analytics with significance testing
✨ Features
- 🔍 Natural Language Queries - Ask questions about your data in plain English
- 📊 Full CRUD Operations - Create, read, update, and delete records
- 🪝 Webhook Management - Create and manage webhooks for real-time notifications
- 🏗️ Advanced Schema Management - Create tables, fields, and manage base structure
- 🔍 Base Discovery - Explore all accessible bases and their schemas
- 🔧 Field Management - Add, modify, and remove fields programmatically
- 🔐 Secure Authentication - Uses environment variables for credentials
- 🚀 Easy Setup - Multiple installation options available
- ⚡ Fast & Reliable - Built with Node.js for optimal performance
- 🎯 33 Powerful Tools - Complete Airtable API coverage with batch operations
- 📎 Attachment Management - Upload files via URLs to attachment fields
- ⚡ Batch Operations - Create, update, delete up to 10 records at once
- 👥 Collaboration Tools - Manage base collaborators and shared views
- 🤖 AI Integration - Prompts and sampling for intelligent data operations
- 🔐 Enterprise Security - OAuth2, rate limiting, comprehensive validation
📋 Prerequisites
- Node.js 14+ installed on your system
- An Airtable account with a Personal Access Token
- Your Airtable Base ID
🚀 Quick Start
Step 1: Get Your Airtable Credentials
- Personal Access Token: Visit Airtable Account → Create a token with the following scopes:
data.records:read
- Read records from tablesdata.records:write
- Create, update, delete recordsschema.bases:read
- View table schemasschema.bases:write
- New in v1.5.0 - Create/modify tables and fieldswebhook:manage
- (Optional) For webhook features
- Base ID: Open your Airtable base and copy the ID from the URL:
Step 2: Installation
Choose one of these installation methods:
🔷 TypeScript Users (Recommended for Development)
📦 JavaScript Users (Production Ready)
Option A: Install via NPM (Recommended)
Option B: Clone from GitHub
Step 3: Set Up Environment Variables
Create a .env
file in your project directory:
Security Note: Never commit .env
files to version control!
Step 4: Configure Your MCP Client
🔷 TypeScript Configuration (Enhanced Developer Experience)
Add to your Claude Desktop configuration file with TypeScript binary:
MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\\Claude\\claude_desktop_config.json
📦 JavaScript Configuration (Standard)
Add to your Claude Desktop configuration file:
MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
For Environment Variables (More Secure)
Step 5: Restart Your MCP Client
After configuration, restart Claude Desktop or your MCP client to load the Airtable server.
🎯 Usage Examples
Once configured, you can interact with your Airtable data naturally:
🔷 TypeScript Development
📦 Natural Language Interactions
Basic Operations
Webhook Operations (v1.4.0+)
Schema Management (v1.5.0+)
Batch Operations & Attachments (v1.6.0+)
🛠️ Available Tools (33 Total)
📊 Data Operations (7 tools)
Tool | Description |
---|---|
list_tables | Get all tables in your base with schema information |
list_records | Query records with optional filtering and pagination |
get_record | Retrieve a single record by ID |
create_record | Add new records to any table |
update_record | Modify existing record fields |
delete_record | Remove records from a table |
search_records | Advanced search with Airtable formulas and sorting |
🪝 Webhook Management (5 tools)
Tool | Description |
---|---|
list_webhooks | View all webhooks configured for your base |
create_webhook | Set up real-time notifications for data changes |
delete_webhook | Remove webhook configurations |
get_webhook_payloads | Retrieve webhook notification history |
refresh_webhook | Extend webhook expiration time |
🔍 Schema Discovery (6 tools) - New in v1.5.0
Tool | Description |
---|---|
list_bases | List all accessible Airtable bases with permissions |
get_base_schema | Get complete schema information for any base |
describe_table | Get detailed table info including all field specifications |
list_field_types | Reference guide for all available Airtable field types |
get_table_views | List all views for a specific table with configurations |
🏗️ Table Management (3 tools) - New in v1.5.0
Tool | Description |
---|---|
create_table | Create new tables with custom field definitions |
update_table | Modify table names and descriptions |
delete_table | Remove tables (with safety confirmation required) |
🔧 Field Management (3 tools) - New in v1.5.0
Tool | Description |
---|---|
create_field | Add new fields to existing tables with all field types |
update_field | Modify field properties, names, and options |
delete_field | Remove fields (with safety confirmation required) |
⚡ Batch Operations (4 tools) - New in v1.6.0
Tool | Description |
---|---|
batch_create_records | Create up to 10 records at once for better performance |
batch_update_records | Update up to 10 records simultaneously |
batch_delete_records | Delete up to 10 records in a single operation |
batch_upsert_records | Update existing or create new records based on key fields |
📎 Attachment Management (1 tool) - New in v1.6.0
Tool | Description |
---|---|
upload_attachment | Attach files from public URLs to attachment fields |
👁️ Advanced Views (2 tools) - New in v1.6.0
Tool | Description |
---|---|
create_view | Create new views (grid, form, calendar, etc.) with custom configurations |
get_view_metadata | Get detailed view information including filters and sorts |
🏢 Base Management (3 tools) - New in v1.6.0
Tool | Description |
---|---|
create_base | Create new Airtable bases with initial table structures |
list_collaborators | View base collaborators and their permission levels |
list_shares | List shared views and their public configurations |
🤖 AI Intelligence Suite (10 prompts) - Revolutionary v3.0.0
Prompt | Description | Enterprise Features |
---|---|---|
analyze_data | Advanced statistical analysis with ML insights | Confidence intervals, anomaly detection |
create_report | Intelligent report generation with recommendations | Multi-stakeholder customization, ROI analysis |
data_insights | Business intelligence and pattern discovery | Cross-table correlations, predictive indicators |
optimize_workflow | AI-powered automation recommendations | Change management, implementation roadmaps |
smart_schema_design | Database optimization with best practices | Compliance-aware (GDPR, HIPAA), scalability planning |
data_quality_audit | Comprehensive quality assessment and fixes | Automated remediation, governance frameworks |
predictive_analytics | Forecasting and trend prediction | Multiple algorithms, uncertainty quantification |
natural_language_query | Process human questions intelligently | Context awareness, confidence scoring |
smart_data_transformation | AI-assisted data processing | Quality rules, audit trails, optimization |
automation_recommendations | Workflow optimization suggestions | Technical feasibility, cost-benefit analysis |
🔧 Advanced Configuration
Using with Smithery Cloud
For cloud-hosted MCP servers:
Direct Node.js Execution
If you cloned the repository:
🧪 Testing
🔷 TypeScript Testing
Run the comprehensive TypeScript test suite:
📦 JavaScript Testing
Run the comprehensive test suite to verify all 33 tools:
The TypeScript test suite validates:
- Type Safety: Compile-time validation of all interfaces
- Enterprise Testing: 33 tools with strict type checking
- AI Prompt Validation: All 10 AI templates with proper typing
- Error Handling: Type-safe error management
- Performance: Concurrent operations with type safety
- Integration: Full MCP protocol compliance
The JavaScript test suite validates:
- All 33 tools with real API calls
- Complete CRUD operations
- Advanced schema management
- Batch operations (create/update/delete multiple records)
- Attachment management via URLs
- Advanced view creation and metadata
- Base management and collaboration tools
- Webhook management
- Error handling and edge cases
- Security verification
- 100% test coverage
🐛 Troubleshooting
"Connection Refused" Error
- Ensure the MCP server is running
- Check that port 8010 is not blocked
- Restart your MCP client
"Invalid Token" Error
- Verify your Personal Access Token is correct
- Check that the token has the required scopes
- Ensure no extra spaces in your credentials
"Base Not Found" Error
- Confirm your Base ID is correct
- Check that your token has access to the base
Port Conflicts
If port 8010 is in use:
📚 Documentation
🔷 TypeScript Documentation
- 📘 TypeScript Examples - Complete type-safe usage examples
- 🏗️ Type Definitions - Comprehensive type definitions for all features
- 🧪 TypeScript Testing - Enterprise-grade testing framework
📦 General Documentation
- 🎆 Release Notes v3.1.0 - Latest TypeScript release
- Release Notes v1.6.0 - Major feature release
- Release Notes v1.5.0
- Release Notes v1.4.0
- Detailed Setup Guide
- Development Guide
- Security Notice
📦 Version History
- v3.1.0 (2025-08-16) - 🔷 TypeScript Support: Enterprise-grade type safety, comprehensive type definitions, dual JS/TS distribution
- v3.0.0 (2025-08-16) - 🤖 Revolutionary AI Agent: 10 intelligent prompts, predictive analytics, natural language processing
- v2.2.3 (2025-08-16) - 🔒 Security release: Final XSS vulnerability fixes and enhanced validation
- v2.2.0 (2025-08-16) - 🏆 Major release: Complete MCP 2024-11-05 protocol implementation
- v1.6.0 (2025-08-15) - 🎆 Major release: Added batch operations & attachment management (33 total tools)
- v1.5.0 (2025-08-15) - Added comprehensive schema management (23 total tools)
- v1.4.0 (2025-08-14) - Added webhook support and enhanced CRUD operations (12 tools)
- v1.2.4 (2025-08-12) - Security fixes and stability improvements
- v1.2.3 (2025-08-11) - Bug fixes and error handling
- v1.2.2 (2025-08-10) - Initial stable release
🤝 Contributing
Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.
📄 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
📮 Support
- Issues: GitHub Issues
- Discussions: GitHub Discussions
Version: 3.1.0 | Status: 🔷 TypeScript + 🤖 AI Agent | MCP Protocol: 2024-11-05 Complete | Type Safety: Enterprise-Grade | Intelligence: 10 AI Prompts | Last Updated: August 16, 2025
This server cannot be installed
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Connects AI tools directly to Airtable, allowing users to query, create, update, and delete records using natural language.
Related MCP Servers
- AsecurityAlicenseAqualityAllows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.Last updated -1768PythonMIT License
- -securityFlicense-qualityEnables AI assistants to interact with Metabase, providing access to dashboards, questions, databases, and tools for executing queries and viewing data through natural language.Last updated -JavaScript
- -securityAlicense-qualityEnables AI-powered applications to access and manipulate Airtable data directly from your IDE, supporting operations like querying, creating, updating, and deleting records through natural language commands.Last updated -MIT License
- -securityFlicense-qualityA powerful interface for extending AI capabilities through remote control, calculations, email operations, knowledge search, and more.Last updated -35Python