Skip to main content
Glama

Airtable MCP

Airtable MCP Server

Airtable

🤖 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

  1. Personal Access Token: Visit Airtable Account → Create a token with the following scopes:
    • data.records:read - Read records from tables
    • data.records:write - Create, update, delete records
    • schema.bases:read - View table schemas
    • schema.bases:write - New in v1.5.0 - Create/modify tables and fields
    • webhook:manage - (Optional) For webhook features
  2. Base ID: Open your Airtable base and copy the ID from the URL:
    https://airtable.com/[BASE_ID]/...

Step 2: Installation

Choose one of these installation methods:

# Install with TypeScript support npm install -g @rashidazarang/airtable-mcp # For development with types npm install --save-dev typescript @types/node
📦 JavaScript Users (Production Ready)

Option A: Install via NPM (Recommended)

npm install -g @rashidazarang/airtable-mcp

Option B: Clone from GitHub

git clone https://github.com/rashidazarang/airtable-mcp.git cd airtable-mcp npm install

Step 3: Set Up Environment Variables

Create a .env file in your project directory:

AIRTABLE_TOKEN=your_personal_access_token_here AIRTABLE_BASE_ID=your_base_id_here

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

{ "mcpServers": { "airtable-typescript": { "command": "npx", "args": [ "@rashidazarang/airtable-mcp", "--token", "YOUR_AIRTABLE_TOKEN", "--base", "YOUR_BASE_ID" ], "env": { "NODE_ENV": "production", "LOG_LEVEL": "INFO" } } } }
📦 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

{ "mcpServers": { "airtable": { "command": "npx", "args": [ "@rashidazarang/airtable-mcp", "--token", "YOUR_AIRTABLE_TOKEN", "--base", "YOUR_BASE_ID" ] } } }
For Environment Variables (More Secure)
{ "mcpServers": { "airtable": { "command": "npx", "args": ["@rashidazarang/airtable-mcp"], "env": { "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN", "AIRTABLE_BASE_ID": "YOUR_BASE_ID" } } } }

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

import { AirtableMCPServer, ListRecordsInput, AnalyzeDataPrompt } from '@rashidazarang/airtable-mcp/types'; const server = new AirtableMCPServer(); // Type-safe data operations const params: ListRecordsInput = { table: 'Tasks', maxRecords: 10, filterByFormula: "Status = 'Active'" }; const records = await server.handleToolCall('list_records', params); // Type-safe AI analytics const analysis: AnalyzeDataPrompt = { table: 'Sales', analysis_type: 'predictive', confidence_level: 0.95 }; const insights = await server.handlePromptGet('analyze_data', analysis);

📦 Natural Language Interactions

Basic Operations

"Show me all records in the Projects table" "Create a new task with priority 'High' and due date tomorrow" "Update the status of task ID rec123 to 'Completed'" "Delete all records where status is 'Archived'" "What tables are in my base?" "Search for records where Status equals 'Active'"

Webhook Operations (v1.4.0+)

"Create a webhook for my table that notifies https://my-app.com/webhook" "List all active webhooks in my base" "Show me the recent webhook payloads" "Delete webhook ach123xyz"

Schema Management (v1.5.0+)

"List all my accessible Airtable bases" "Show me the complete schema for this base" "Describe the Projects table with all field details" "Create a new table called 'Tasks' with Name, Priority, and Due Date fields" "Add a Status field to the existing Projects table" "What field types are available in Airtable?"

Batch Operations & Attachments (v1.6.0+)

"Create 5 new records at once in the Tasks table" "Update multiple records with new status values" "Delete these 3 records in one operation" "Attach this image URL to the record's photo field" "Who are the collaborators on this base?" "Show me all shared views in this base"

🛠️ Available Tools (33 Total)

📊 Data Operations (7 tools)

ToolDescription
list_tablesGet all tables in your base with schema information
list_recordsQuery records with optional filtering and pagination
get_recordRetrieve a single record by ID
create_recordAdd new records to any table
update_recordModify existing record fields
delete_recordRemove records from a table
search_recordsAdvanced search with Airtable formulas and sorting

🪝 Webhook Management (5 tools)

ToolDescription
list_webhooksView all webhooks configured for your base
create_webhookSet up real-time notifications for data changes
delete_webhookRemove webhook configurations
get_webhook_payloadsRetrieve webhook notification history
refresh_webhookExtend webhook expiration time

🔍 Schema Discovery (6 tools) - New in v1.5.0

ToolDescription
list_basesList all accessible Airtable bases with permissions
get_base_schemaGet complete schema information for any base
describe_tableGet detailed table info including all field specifications
list_field_typesReference guide for all available Airtable field types
get_table_viewsList all views for a specific table with configurations

🏗️ Table Management (3 tools) - New in v1.5.0

ToolDescription
create_tableCreate new tables with custom field definitions
update_tableModify table names and descriptions
delete_tableRemove tables (with safety confirmation required)

🔧 Field Management (3 tools) - New in v1.5.0

ToolDescription
create_fieldAdd new fields to existing tables with all field types
update_fieldModify field properties, names, and options
delete_fieldRemove fields (with safety confirmation required)

⚡ Batch Operations (4 tools) - New in v1.6.0

ToolDescription
batch_create_recordsCreate up to 10 records at once for better performance
batch_update_recordsUpdate up to 10 records simultaneously
batch_delete_recordsDelete up to 10 records in a single operation
batch_upsert_recordsUpdate existing or create new records based on key fields

📎 Attachment Management (1 tool) - New in v1.6.0

ToolDescription
upload_attachmentAttach files from public URLs to attachment fields

👁️ Advanced Views (2 tools) - New in v1.6.0

ToolDescription
create_viewCreate new views (grid, form, calendar, etc.) with custom configurations
get_view_metadataGet detailed view information including filters and sorts

🏢 Base Management (3 tools) - New in v1.6.0

ToolDescription
create_baseCreate new Airtable bases with initial table structures
list_collaboratorsView base collaborators and their permission levels
list_sharesList shared views and their public configurations

🤖 AI Intelligence Suite (10 prompts) - Revolutionary v3.0.0

PromptDescriptionEnterprise Features
analyze_dataAdvanced statistical analysis with ML insightsConfidence intervals, anomaly detection
create_reportIntelligent report generation with recommendationsMulti-stakeholder customization, ROI analysis
data_insightsBusiness intelligence and pattern discoveryCross-table correlations, predictive indicators
optimize_workflowAI-powered automation recommendationsChange management, implementation roadmaps
smart_schema_designDatabase optimization with best practicesCompliance-aware (GDPR, HIPAA), scalability planning
data_quality_auditComprehensive quality assessment and fixesAutomated remediation, governance frameworks
predictive_analyticsForecasting and trend predictionMultiple algorithms, uncertainty quantification
natural_language_queryProcess human questions intelligentlyContext awareness, confidence scoring
smart_data_transformationAI-assisted data processingQuality rules, audit trails, optimization
automation_recommendationsWorkflow optimization suggestionsTechnical feasibility, cost-benefit analysis

🔧 Advanced Configuration

Using with Smithery Cloud

For cloud-hosted MCP servers:

{ "mcpServers": { "airtable": { "command": "npx", "args": [ "@smithery/cli", "run", "@rashidazarang/airtable-mcp", "--token", "YOUR_TOKEN", "--base", "YOUR_BASE_ID" ] } } }

Direct Node.js Execution

If you cloned the repository:

{ "mcpServers": { "airtable": { "command": "node", "args": [ "/path/to/airtable-mcp/airtable_simple.js", "--token", "YOUR_TOKEN", "--base", "YOUR_BASE_ID" ] } } }

🧪 Testing

🔷 TypeScript Testing

Run the comprehensive TypeScript test suite:

# Install dependencies first npm install # Run TypeScript type checking npm run test:types # Run full TypeScript test suite npm run test:ts # Build and test TypeScript server npm run build npm run start:ts

📦 JavaScript Testing

Run the comprehensive test suite to verify all 33 tools:

# Set environment variables first export AIRTABLE_TOKEN=your_token export AIRTABLE_BASE_ID=your_base_id # Start the server node airtable_simple.js & # Run comprehensive tests (v1.6.0+) ./test_v1.6.0_comprehensive.sh

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:

lsof -ti:8010 | xargs kill -9

📚 Documentation

🔷 TypeScript Documentation

📦 General Documentation

📦 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

📮 Support


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

-
security - not tested
A
license - permissive license
-
quality - not tested

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.

  1. Quick Start
    1. Features
      1. Available Tools
        1. Troubleshooting
          1. Common Issues
          2. Need Help?
        2. Contributing
          1. License

            Related MCP Servers

            • A
              security
              A
              license
              A
              quality
              Allows 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 -
              1
              768
              Python
              MIT License
              • Linux
              • Apple
            • -
              security
              F
              license
              -
              quality
              Enables 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
              • Apple
            • -
              security
              A
              license
              -
              quality
              Enables 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
            • -
              security
              F
              license
              -
              quality
              A powerful interface for extending AI capabilities through remote control, calculations, email operations, knowledge search, and more.
              Last updated -
              35
              Python

            View all related MCP servers

            MCP directory API

            We provide all the information about MCP servers via our MCP API.

            curl -X GET 'https://glama.ai/api/mcp/v1/servers/rashidazarang/airtable-mcp'

            If you have feedback or need assistance with the MCP directory API, please join our Discord server