AI Atlas

Database · Developer Tools

Airtable MCP logo

Airtable MCP

rashidazarang/airtable-mcp

A Model Context Protocol (MCP) server for Airtable with full CRUD operations, schema management, record comments, webhooks, batch operations, governance controls, and AI-powered analytics.

View on GitHub12

Install

npx -y @rashidazarang/airtable-mcp

Client configuration

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "-y",
        "@rashidazarang/airtable-mcp"
      ],
      "env": {
        "AIRTABLE_TOKEN": "<AIRTABLE_TOKEN>",
        "AIRTABLE_BASE_ID": "<AIRTABLE_BASE_ID>"
      }
    }
  }
}

Environment variables

AIRTABLE_TOKENAIRTABLE_BASE_IDAIRTABLE_TOOLSET
GitHub stars
12
Author
@rashidazarang
Category
Database, Developer Tools
License
MIT
Updated
Oct 6, 2026

About Airtable MCP

Version 5.1.0 | MCP Protocol 2026-07-28 (stateless core, legacy 2025-era clients still served) | Works with Claude, Codex, Cursor, Windsurf, VS Code, and any MCP client |

Features

  • Full CRUD Operations — Create, read, update, and delete records with filtering and pagination

  • Record Comments — List, create, update, and delete comments on records

  • Schema Management — Create and modify tables, fields, and views programmatically

  • Batch Operations — Process up to 10 records per operation for improved performance

  • Webhook Management — Set up real-time notifications for data changes

  • Governance & Compliance — Allow-list governance, PII masking, and exception tracking

  • User Identity — Verify token identity with the whoami tool

  • AI Analytics — 10 prompt templates for predictive analytics, natural language queries, and automated insights

  • Multi-Base Support — Discover and work with multiple bases dynamically

  • Type Safety — Full TypeScript support with comprehensive type definitions

Tools (40)

  • list_bases

    List all accessible bases with permissions

  • describe

    Describe base or table schema (supports detail levels)

  • query

    Query records with filtering, sorting, and pagination

  • search_records

    Advanced search with Airtable formulas

  • list_records

    List records with field selection and pagination

  • get_record

    Retrieve a single record by ID

  • create

    Create new records (requires dryRun diff review)

  • update

    Update existing records (requires dryRun diff review)

  • delete_record

    Remove a record from a table

  • upsert

    Update or create records based on merge fields

  • batch_upsert_records

    Batch upsert with merge-on fields

  • list_tables

    Get all tables in a base with schema info

  • get_base_schema

    Get complete schema for any base

  • list_field_types

    Reference guide for available field types

  • get_table_views

    List all views for a table

  • create_table

    Create tables with custom field definitions

  • update_table

    Modify table names and descriptions

  • delete_table

    Remove tables (requires confirmation)

  • create_field

    Add fields to existing tables

  • update_field

    Modify field properties and options

  • delete_field

    Remove fields (requires confirmation)

  • batch_create_records

    Create up to 10 records at once

  • batch_update_records

    Update up to 10 records simultaneously

  • batch_delete_records

    Delete up to 10 records in one operation

  • list_webhooks

    View all configured webhooks

  • create_webhook

    Set up real-time notifications

  • delete_webhook

    Remove webhook configurations

  • get_webhook_payloads

    Retrieve notification history

  • refresh_webhook

    Extend webhook expiration

  • create_view

    Create views (grid, form, calendar, etc.)

  • get_view_metadata

    Get view details including filters

  • upload_attachment

    Attach files from URLs

  • create_base

    Create new bases with initial structure

  • list_collaborators

    View collaborators and permissions

  • list_shares

    List shared views and configurations

  • list_comments

    List comments on a record

  • create_comment

    Add a comment to a record

  • update_comment

    Edit an existing comment

  • delete_comment

    Remove a comment

  • whoami

    Get current user identity and scopes

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Claude Desktop logo

Claude Desktop

Desktop · Freemium · Proprietary

Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.

WindowsMacOS
Cline logo

Cline

Desktop · Free · MIT

An AI coding assistant integrated into the IDE. Supports MCP servers for enhanced functionality.

WindowsMacOSLinux
Cursor logo

Cursor

Desktop · Freemium · Proprietary

The first agentic IDE. The Cursor editor truly merges how developers and AI work together, delivering a magical coding experience.

WindowsMacOSLinux
Windsurf logo

Windsurf

Desktop · Freemium · Proprietary

The first agentic IDE. The Windsurf editor truly merges how developers and AI work together.

WindowsMacOSLinux

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database