Skip to main content
Glama

Airtable MCP Server

Trust Score Airtable MCP TypeScript AI Agent Security Protocol

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.

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 | npm


Quick Start (Claude Desktop)

No installation required — just add this to your Claude Desktop config and restart:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

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

That's it. npx downloads and runs the server automatically. No git clone, no npm install.

Get your token at airtable.com/create/tokens — grant all scopes listed under Token Scopes below. Get your Base ID from the URL when viewing your base: https://airtable.com/[BASE_ID]/... (or omit it and use list_bases to discover bases dynamically).


Related MCP server: Airtable MCP Server

Quick Start (Claude Code)

One-command install

curl -fsSL https://raw.githubusercontent.com/rashidazarang/airtable-mcp/main/setup.sh | bash

The script checks prerequisites, prompts for your Airtable token, and writes the MCP config to ~/.claude.json. Restart Claude Code (or run /mcp) to connect.

You can also pass your token directly:

curl -fsSL https://raw.githubusercontent.com/rashidazarang/airtable-mcp/main/setup.sh | bash -s -- YOUR_AIRTABLE_TOKEN

Manual config

Add to ~/.claude.json under mcpServers:

{
  "airtable": {
    "type": "stdio",
    "command": "/bin/bash",
    "args": ["-c", "cd /tmp && npx -y @rashidazarang/airtable-mcp"],
    "env": {
      "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN"
    }
  }
}

Why the bash wrapper? npx can fail to resolve the binary when run from a directory that contains a package.json with the same package name. The cd /tmp && prefix avoids this edge case.


Quick Start (Codex, Cursor, Windsurf, VS Code)

The server works with any MCP client. It serves both the modern 2026-07-28 protocol and 2025-era clients automatically — no configuration needed for either.

OpenAI Codex (CLI, IDE extension, ChatGPT desktop)

One command:

codex mcp add airtable -- npx -y @rashidazarang/airtable-mcp

Or edit ~/.codex/config.toml (or .codex/config.toml for a trusted project) directly:

[mcp_servers.airtable]
command = "npx"
args = ["-y", "@rashidazarang/airtable-mcp"]

[mcp_servers.airtable.env]
AIRTABLE_TOKEN = "YOUR_AIRTABLE_TOKEN"

The Codex CLI, IDE extension, and ChatGPT desktop app share this configuration.

Cursor

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project):

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": ["-y", "@rashidazarang/airtable-mcp"],
      "env": {
        "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN",
        "AIRTABLE_TOOLSET": "core"
      }
    }
  }
}

Why AIRTABLE_TOOLSET=core? Cursor caps agents at 40 enabled tools across all servers, and this server exposes 42. The core profile registers the 18 record-centric tools (reads, writes, batches, governance), leaving room for other servers. Omit it (or set full) if Airtable is your only MCP server and you manage the cap by disabling individual tools in Cursor's Tools & MCP settings. Also note: Cursor offers MCP tools in Agent and Plan modes only (not Ask/Edit), and consumes tools and resources but not MCP prompts.

Windsurf

Add the same JSON block to ~/.codeium/windsurf/mcp_config.json (Cascade → MCP settings). Windsurf supports per-tool toggling if you prefer the full toolset.

VS Code (GitHub Copilot agent mode)

Add to .vscode/mcp.json:

{
  "servers": {
    "airtable": {
      "type": "stdio",
      "command": "npx",
      "args": ["-y", "@rashidazarang/airtable-mcp"],
      "env": { "AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN" }
    }
  }
}

Compatibility notes (any client)

  • Both protocol eras served — modern 2026-07-28 clients and legacy 2025-era clients (Codex, Cursor, Windsurf, Cline, Zed, and most others today) negotiate automatically.

  • Tool names are client-safe — bare snake_case, well under length limits, and free of : and * (reserved by Cursor's allowlist grammar server:tool).

  • Logs never touch stdout — all logging goes to stderr, so stdio framing is never corrupted.

  • Remote/HTTP clients — start the server with PORT or MCP_HTTP_PORT set and point the client at http://host:port/mcp (streamable HTTP, stateless; /health for orchestrators).

  • Tool caps — use AIRTABLE_TOOLSET=core or an explicit allowlist (e.g. AIRTABLE_TOOLSET=describe,query,list_records) for clients that limit enabled tools or to slim the agent's context.


Overview

This server provides comprehensive Airtable integration through the Model Context Protocol, enabling natural language interactions with your Airtable data. It includes 42 tools covering every Airtable PAT scope and 10 AI prompt templates for intelligent analytics.

Key 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


Protocol Support

Built on the MCP 2026-07-28 specification with the v2 TypeScript SDK (@modelcontextprotocol/server):

  • Stateless core — every request is served by a fresh server instance from a shared factory; no sessions, no sticky routing. In HTTP mode any request can land on any replica, so the server deploys cleanly to serverless and horizontally scaled environments.

  • Both eras served — modern 2026-07-28 clients (per-request envelope) and legacy 2025-era clients (initialize handshake) are handled by the same factory: per-connection era pinning over stdio, per-request stateless fallback over HTTP.

  • Transports — stdio (serveStdio) for local clients like Claude Desktop/Code, and streamable HTTP (createMcpHandler + Node adapter) when PORT/MCP_HTTP_PORT is set, with a /health endpoint for orchestrators.

  • Tasks extension — deliberately not implemented: the 2026-07-28 spec moved Tasks out of core into the io.modelcontextprotocol/tasks extension, and every operation this server exposes is a sub-second Airtable API call (batches are capped at 10 records), so background-task semantics add nothing. This will be revisited if long-running tools are added.


Prerequisites

  • Node.js 20 or later (required by the MCP v2 SDK)

  • An Airtable account with a Personal Access Token

  • Your Airtable Base ID (optional — can be discovered via the list_bases tool)


Token Scopes

Create a Personal Access Token at airtable.com/create/tokens with these scopes:

Scope

Purpose

data.records:read

Read records

data.records:write

Create, update, delete records

data.recordComments:read

Read record comments

data.recordComments:write

Create, update, delete comments

schema.bases:read

View table schemas

schema.bases:write

Create and modify tables and fields

user.email:read

Read user identity (whoami)

webhook:manage

Manage webhooks (optional)


Usage

Once configured, interact with your Airtable data using natural language:

Basic Operations

  • "List all my accessible Airtable bases"

  • "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'"

  • "Search for records where Status equals 'Active'"

Schema Management

  • "Show me the complete schema for this base"

  • "Create a new table called 'Tasks' with Name, Priority, and Due Date fields"

  • "Add a Status field to the Projects table"

Record Comments

  • "Show me all comments on record rec123"

  • "Add a comment to this record: 'Reviewed and approved'"

  • "Update my comment to say 'Needs revision'"

Batch Operations

  • "Create 5 new records at once in the Tasks table"

  • "Update multiple records with new status values"

  • "Delete these 3 records in one operation"

Webhooks

  • "List all active webhooks in my base"

  • "Create a webhook for changes to my Projects table"


Available Tools (42)

Core Operations (4 tools)

Tool

Description

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

Record CRUD (5 tools)

Tool

Description

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 (2 tools)

Tool

Description

upsert

Update or create records based on merge fields

batch_upsert_records

Batch upsert with merge-on fields

Schema Discovery (4 tools)

Tool

Description

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

Table Management (3 tools)

Tool

Description

create_table

Create tables with custom field definitions

update_table

Modify table names and descriptions

delete_table

Remove tables (requires confirmation)

Field Management (3 tools)

Tool

Description

create_field

Add fields to existing tables

update_field

Modify field properties and options

delete_field

Remove fields (requires confirmation)

Batch Operations (3 tools)

Tool

Description

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

Webhook Management (5 tools)

Tool

Description

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

Views & Attachments (3 tools)

Tool

Description

create_view

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

get_view_metadata

Get view details including filters

upload_attachment

Attach files from URLs

Base Management (3 tools)

Tool

Description

create_base

Create new bases with initial structure

list_collaborators

View collaborators and permissions

list_shares

List shared views and configurations

Record Comments (4 tools)

Tool

Description

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

User Info (1 tool)

Tool

Description

whoami

Get current user identity and scopes

Governance & Administration (2 tools)

Tool

Description

list_governance

Return governance allow-lists and PII masking policies

list_exceptions

List recent exceptions and remediation proposals


AI Intelligence Suite

Ten AI prompt templates for advanced analytics:

Prompt

Description

analyze_data

Statistical analysis with anomaly detection

create_report

Intelligent report generation

data_insights

Business intelligence and pattern discovery

optimize_workflow

Automation recommendations

smart_schema_design

Database optimization suggestions

data_quality_audit

Quality assessment and remediation

predictive_analytics

Forecasting and trend prediction

natural_language_query

Process questions with context awareness

smart_data_transformation

AI-assisted data processing

automation_recommendations

Workflow optimization with cost-benefit analysis


Advanced Configuration

Smithery Cloud

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

Environment Variables

Variable

Required

Description

AIRTABLE_TOKEN

Yes

Personal Access Token

AIRTABLE_BASE_ID

No

Default base ID (discoverable via list_bases)

AIRTABLE_TOOLSET

No

Which tools to register: full (default, all 42), core (18 record-centric tools — fits Cursor's 40-tool cap), or a comma-separated allowlist of tool names

LOG_LEVEL

No

Logging level (default: info)

MCP_HTTP_PORT

No

Enable HTTP transport for hosted deployments


Development

Not required for users. Clone the repo only if you want to contribute or modify the server. End users should use npx as shown in the Quick Start sections above.

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

Testing

npm run test:types     # Type checking
npm test               # Run test suite

Project Structure

airtable-mcp/
├── src/typescript/          # TypeScript implementation
│   ├── app/
│   │   ├── tools/           # 42 tool implementations
│   │   ├── prompts/         # 10 AI prompt registrations
│   │   ├── airtable-client.ts
│   │   ├── governance.ts
│   │   └── context.ts
│   └── airtable-mcp-server.ts
├── dist/                    # Compiled output
├── docs/                    # Documentation
├── types/                   # TypeScript definitions
└── bin/                     # CLI executables

Troubleshooting

Connection Issues

  • Verify the MCP server is running

  • Restart your MCP client

  • Check that your token has the required scopes

Invalid Token

  • Verify your Personal Access Token is correct

  • Confirm the token has the required scopes

  • Check for extra whitespace in credentials

Base Not Found

  • Confirm your Base ID is correct

  • Verify your token has access to the base

  • Use list_bases to discover accessible bases


Documentation


Contributing

Contributions are welcome. Please open an issue first to discuss major changes.


License

MIT License — see LICENSE for details.


Support

Available Tools

11 tools
createA

Create Airtable records (requires diff-before-write via dryRun first).

ParametersJSON Schema
NameRequiredDescriptionDefault
baseIdYes
tableYes
recordsYes
typecastNo
idempotencyKeyNo
dryRunNo

Output Schema

ParametersJSON Schema
NameRequiredDescription
diffYes
dryRunYes
recordsNo
warningsNo

TDQS

A3.7/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It mentions the 'dryRun' requirement, which is a behavioral constraint, but doesn't cover other important aspects like permissions needed, rate limits, error handling, or what happens on successful creation. It adds some context but leaves significant gaps for a mutation tool.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose and immediately follows with the critical usage requirement. There's zero waste—every word earns its place by providing essential information without redundancy or fluff.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given that there's an output schema (which handles return values), the description doesn't need to explain outputs. However, for a mutation tool with 6 parameters, 0% schema coverage, and no annotations, the description is incomplete. It covers the dry-run requirement well but misses other contextual details like error conditions or side effects, making it only partially adequate.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, meaning none of the 6 parameters have descriptions in the schema. The description only mentions 'dryRun' implicitly and doesn't explain any other parameters like 'baseId', 'table', 'records', 'typecast', or 'idempotencyKey'. It fails to compensate for the lack of schema documentation, leaving most parameters semantically unclear.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('Create Airtable records') and specifies the resource ('Airtable records'), which is a specific verb+resource combination. However, it doesn't explicitly distinguish this tool from its sibling 'upsert' or 'update' tools, which likely handle similar record operations. The purpose is clear but lacks sibling differentiation.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit usage guidance by stating 'requires diff-before-write via dryRun first,' which indicates a prerequisite workflow. This tells the agent when to use this tool (only after a dry run) and implies an alternative approach (using dryRun parameter). It gives clear context for proper invocation.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

create_webhookB

Create a new webhook for a base.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden for behavioral disclosure. It states 'Create' which implies a write/mutation operation, but doesn't cover permissions needed, whether the operation is idempotent, rate limits, or what happens on failure. This leaves significant gaps for a mutation tool.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that directly states the tool's purpose without any fluff or redundancy. It's appropriately sized and front-loaded with the essential information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a mutation tool ('Create') with no annotations and no output schema, the description is incomplete. It doesn't explain what a webhook is, what 'for a base' means, what data is returned, or error handling. Given the complexity implied by sibling tools and lack of structured data, more context is needed.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 0 parameters with 100% coverage, so no parameter documentation is needed. The description doesn't add parameter details, which is appropriate, but since there are no parameters to explain, it meets the baseline of 4 for this scenario.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('Create') and target resource ('a new webhook for a base'), which is specific and unambiguous. However, it doesn't differentiate from sibling tools like 'refresh_webhook' or 'update', which might also involve webhook operations, so it doesn't reach the highest score.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives like 'refresh_webhook' or 'update', nor does it mention prerequisites or context for creating a webhook. It's a basic statement with no usage instructions.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

describeB

Describe Airtable base or table schema.

Use detailLevel to optimize context usage:

  • tableIdentifiersOnly: Only table IDs and names (minimal)

  • identifiersOnly: Table, field, and view IDs and names

  • full: Complete details including field types and options (default)

ParametersJSON Schema
NameRequiredDescriptionDefault
scopeYes
baseIdYes
tableNo
detailLevelNofull
includeFieldsNo
includeViewsNo

Output Schema

ParametersJSON Schema
NameRequiredDescription
baseYes
viewsNo
tablesNo

TDQS

B3.4/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It mentions the tool's function and detailLevel optimization, but doesn't describe important behavioral aspects like whether this is a read-only operation, what permissions are required, rate limits, error conditions, or what the output looks like. The description is insufficient for a mutation-sensitive agent to understand the tool's behavior fully.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is efficiently structured with two sentences: the first states the purpose, and the second provides specific guidance about the detailLevel parameter. Every sentence earns its place with no wasted words, and the information is appropriately front-loaded.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given that there's an output schema (which means the description doesn't need to explain return values) and no annotations, the description provides adequate basic purpose and parameter guidance. However, for a tool with 6 parameters and 0% schema description coverage, the description should do more to explain parameter semantics and behavioral context to be truly complete.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The description provides meaningful context for the detailLevel parameter by explaining what each enum value returns, which adds significant value beyond the 0% schema description coverage. However, it doesn't explain the semantics of other parameters like scope, baseId, table, includeFields, or includeViews, leaving 5 of the 6 parameters without semantic explanation in the description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose as describing Airtable base or table schema, which is a specific verb+resource combination. However, it doesn't explicitly distinguish this from sibling tools like 'list_bases' or 'query', which might also provide schema information in different contexts.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides some usage guidance by explaining how to use the detailLevel parameter to optimize context usage, which implies when to choose different detail levels. However, it doesn't explicitly state when to use this tool versus alternatives like 'list_bases' or 'query', nor does it provide exclusion criteria or prerequisites.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_basesA

List all accessible Airtable bases with their names, IDs, and permission levels

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

Output Schema

ParametersJSON Schema
NameRequiredDescription
basesYes

TDQS

A4/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. It discloses the tool's read-only nature implicitly by using 'List', but lacks details on behavioral traits like pagination, rate limits, authentication requirements, or how 'accessible' is defined (e.g., user permissions). The description adds basic context but misses key operational details.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose ('List all accessible Airtable bases') and adds specific return details. Every word earns its place with no redundancy or waste.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's low complexity (0 parameters, no annotations, but has an output schema), the description is reasonably complete. It specifies the resource and return fields, and the output schema will handle return value details. However, it lacks context on access scope or behavioral constraints, leaving some gaps for a tool that lists resources.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has 0 parameters with 100% schema description coverage (empty schema). The description adds no parameter information, which is appropriate since there are none. Baseline is 4 for 0 parameters, as the description doesn't need to compensate for any gaps.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the specific action ('List') and resource ('all accessible Airtable bases'), including what information is returned ('names, IDs, and permission levels'). It distinguishes from siblings like 'list_exceptions' or 'list_webhooks' by specifying the resource type.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies usage for retrieving base metadata, but provides no explicit guidance on when to use this versus alternatives like 'describe' (which might get details for a specific base) or 'query' (which queries records within bases). No when-not-to-use or prerequisite information is included.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_exceptionsC

List recent exceptions and remediation proposals.

ParametersJSON Schema
NameRequiredDescriptionDefault
sinceNo
severityNo
limitNo
cursorNo

Output Schema

ParametersJSON Schema
NameRequiredDescription
itemsYes
cursorNo

TDQS

C2.6/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden for behavioral disclosure. It mentions 'recent exceptions and remediation proposals' which implies a read-only listing operation, but doesn't specify whether this requires authentication, what format the exceptions are in, whether results are paginated (though cursor parameter suggests it might be), or any rate limits. The description adds minimal behavioral context beyond the basic operation.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is extremely concise - just 6 words in a single sentence. It's front-loaded with the core purpose. While arguably too brief given the complexity of the tool (4 parameters, no annotations), every word contributes meaning without redundancy. The structure is simple but effective for such a short description.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given that there's an output schema (which handles return values), no annotations, and 4 parameters with 0% schema description coverage, the description is incomplete. It covers the basic purpose but lacks parameter explanations, usage context, and behavioral details that would help an agent use this tool effectively. The presence of an output schema reduces the need to describe return values, but other gaps remain significant.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The description provides no information about any of the 4 parameters. With 0% schema description coverage, the schema only provides structural information (types, constraints, enums) without explaining what 'since', 'severity', 'limit', or 'cursor' actually mean in context. The description doesn't compensate for this gap at all - it doesn't mention parameters, their purposes, or how they affect the listing.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose3/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states the tool's purpose ('List recent exceptions and remediation proposals') which is clear but somewhat vague. It specifies the verb 'List' and resource 'exceptions and remediation proposals', but doesn't distinguish this from potential sibling tools like 'list_bases' or 'list_governance' that might handle different resources. The term 'recent' provides some temporal context but lacks specificity.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. There's no mention of prerequisites, appropriate contexts, or comparison with sibling tools like 'query' or 'describe' that might handle similar data. The agent must infer usage from the tool name and description alone without explicit direction.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_governanceB

Return governance allow-lists and PII masking policies.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

Output Schema

ParametersJSON Schema
NameRequiredDescription
piiFieldsYes
allowedBasesYes
allowedTablesYes
loggingPolicyYes
retentionDaysYes
redactionPolicyYes
allowedOperationsYes

TDQS

B3.2/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It indicates a read operation ('return'), but lacks details on permissions, rate limits, data format, or any side effects. This is a significant gap for a tool with zero annotation coverage.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that directly states the tool's purpose without any wasted words. It is appropriately sized and front-loaded, making it easy to parse quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool has 0 parameters, 100% schema coverage, and an output schema exists, the description is minimally adequate. However, it lacks behavioral context (e.g., permissions, data format) and doesn't differentiate from siblings, leaving gaps in completeness for a read operation tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has 0 parameters with 100% schema description coverage, so the schema fully documents the inputs. The description doesn't need to add parameter information, and it appropriately avoids redundancy. A baseline of 4 is given since no parameters are present.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose with specific verbs ('return') and resources ('governance allow-lists and PII masking policies'), making it easy to understand what it does. However, it doesn't explicitly differentiate from sibling tools like 'list_bases' or 'list_exceptions', which prevents a perfect score.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives like 'list_bases' or 'list_exceptions', nor does it mention any prerequisites or exclusions. It simply states what the tool does without contextual usage information.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_webhooksB

List Airtable webhooks for the default base.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It states what the tool does but doesn't describe behavioral traits such as whether this is a read-only operation, if it requires authentication, potential rate limits, or what the output format looks like (e.g., list structure, pagination). This is inadequate for a tool with zero annotation coverage.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, clear sentence that directly states the tool's purpose without any wasted words. It is front-loaded with the essential information and appropriately sized for a simple listing tool with no parameters.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the lack of annotations and no output schema, the description is incomplete. It doesn't explain what the tool returns (e.g., a list of webhook objects, error handling), behavioral constraints, or how it interacts with the default base. For a tool with zero structured data coverage, more context is needed to guide effective use.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 0 parameters with 100% coverage, so no parameter documentation is needed. The description doesn't add parameter details, which is appropriate here. A baseline of 4 is applied since there are no parameters to document, and the description doesn't introduce unnecessary complexity.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('List') and resource ('Airtable webhooks for the default base'), providing a specific verb+resource combination. However, it doesn't explicitly distinguish this tool from sibling tools like 'list_bases' or 'list_exceptions', which would require mentioning what makes webhook listing unique.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., needing a default base configured), when not to use it, or how it differs from other listing tools like 'list_bases' or querying operations. This leaves the agent without context for tool selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

queryC

Query Airtable records with filtering, sorting, and pagination.

ParametersJSON Schema
NameRequiredDescriptionDefault
baseIdYes
tableYes
fieldsNo
filterByFormulaNo
viewNo
sortsNo
pageSizeNo
maxRecordsNo
offsetNo
returnFieldsByFieldIdNo

Output Schema

ParametersJSON Schema
NameRequiredDescription
offsetNo
recordsYes
summaryNo

TDQS

C2.7/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It mentions 'filtering, sorting, and pagination' which hints at read-only behavior, but doesn't explicitly state that this is a safe read operation, what permissions are required, rate limits, error conditions, or what the output looks like. For a tool with 10 parameters and no annotation coverage, this leaves significant behavioral gaps.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core functionality. Every word earns its place by specifying the action, target, and key capabilities without any fluff or redundancy. It's appropriately sized for a tool with a clear primary function.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity (10 parameters, 0% schema coverage, no annotations) and the presence of an output schema, the description is incomplete. While the output schema may cover return values, the description doesn't address critical context like authentication needs, error handling, rate limits, or detailed parameter guidance. For a query tool with extensive filtering options, this leaves too much undefined for reliable agent use.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters1/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema description coverage is 0%, meaning none of the 10 parameters have descriptions in the schema. The tool description only vaguely references 'filtering, sorting, and pagination' without explaining what parameters correspond to these features or their semantics. This fails to compensate for the complete lack of schema documentation, leaving parameters like 'filterByFormula', 'offset', and 'returnFieldsByFieldId' entirely unexplained.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('Query') and resource ('Airtable records') with specific capabilities ('filtering, sorting, and pagination'). It distinguishes from siblings like 'create', 'update', and 'upsert' which are write operations, but doesn't explicitly differentiate from 'describe' or 'list_bases' which might also retrieve data. The purpose is well-defined but could be more specific about what makes this query tool unique.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when to choose 'query' over 'list_bases', 'describe', or other read operations, nor does it specify prerequisites or exclusions. The agent must infer usage from the tool name and parameters alone, which is insufficient for optimal selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

refresh_webhookB

Refresh webhook expiration.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden for behavioral disclosure. 'Refresh webhook expiration' implies a mutation operation that likely extends or renews something, but it doesn't disclose what permissions are needed, whether this is idempotent, what happens if the webhook doesn't exist, or what the response looks like. For a mutation tool with zero annotation coverage, this is inadequate.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence with zero wasted words. It's appropriately sized for a simple operation and gets straight to the point without unnecessary elaboration.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given this is a mutation tool (implied by 'refresh') with no annotations and no output schema, the description is incomplete. It doesn't explain what 'refresh' actually means operationally, what the expected outcome is, or any error conditions. For a tool that presumably modifies system state, this leaves too many questions unanswered.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has 0 parameters with 100% schema description coverage, so the schema already fully documents the parameter situation. The description doesn't need to add parameter information, and it appropriately doesn't mention any parameters. This meets the baseline expectation for a zero-parameter tool.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('refresh') and the resource ('webhook expiration'), providing a specific verb+resource combination. However, it doesn't distinguish this tool from potential sibling tools like 'create_webhook' or 'update' that might also affect webhooks, so it doesn't reach the highest score.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With sibling tools like 'create_webhook', 'list_webhooks', and 'update' available, there's no indication of when refresh_webhook is appropriate versus those other operations. The description is purely functional without context.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

updateA

Update Airtable records (requires diff-before-write via dryRun first).

ParametersJSON Schema
NameRequiredDescriptionDefault
baseIdYes
tableYes
recordsYes
typecastNo
idempotencyKeyNo
dryRunNo
conflictStrategyNofail_on_conflict
ifUnchangedHashNo

Output Schema

ParametersJSON Schema
NameRequiredDescription
diffYes
dryRunYes
recordsNo
conflictsNo

TDQS

A3.5/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It reveals the dryRun workflow requirement, which is valuable behavioral context. However, it doesn't disclose other important traits like authentication needs, rate limits, error handling, or what constitutes a successful update. The description adds some value but leaves significant gaps.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is extremely concise - a single sentence that communicates the core purpose and a critical workflow requirement. Every word earns its place, with no wasted text. The structure is front-loaded with the main purpose followed by the important constraint.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a complex update tool with 8 parameters, 0% schema coverage, no annotations, but with an output schema, the description is incomplete. The dryRun guidance is helpful, but it doesn't cover parameter meanings, error conditions, or behavioral expectations. The output schema helps with return values, but the description should do more given the tool's complexity.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

With 0% schema description coverage for 8 parameters, the description provides almost no parameter information. It mentions 'dryRun' implicitly in the workflow guidance, but doesn't explain any of the other 7 parameters (baseId, table, records, typecast, idempotencyKey, conflictStrategy, ifUnchangedHash). The description fails to compensate for the schema's lack of descriptions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('update') and resource ('Airtable records'), making the purpose immediately understandable. It distinguishes from siblings like 'create', 'upsert', and 'query' by focusing on modifying existing records. However, it doesn't explicitly differentiate from 'upsert' which might also update records.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit guidance about a prerequisite workflow ('requires diff-before-write via dryRun first'), which gives important context about when to use this tool. It doesn't mention alternatives like 'upsert' or 'create', but the dryRun requirement provides meaningful usage context.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

upsertC

Upsert Airtable records using performUpsert.fieldsToMergeOn.

ParametersJSON Schema
NameRequiredDescriptionDefault
baseIdYes
tableYes
recordsYes
performUpsertYes
typecastNo
idempotencyKeyNo
dryRunNo
conflictStrategyNofail_on_conflict

Output Schema

ParametersJSON Schema
NameRequiredDescription
diffYes
dryRunYes
recordsNo
conflictsNo

TDQS

C2.4/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It mentions 'upsert' and 'fieldsToMergeOn', implying a conditional create/update based on matching fields, but doesn't explain critical behaviors like mutation effects, error handling, idempotency, or the impact of parameters like 'dryRun' and 'conflictStrategy'. For a complex mutation tool with 8 parameters, this leaves significant gaps in understanding how it operates.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness3/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single sentence that is technically concise, but it's under-specified for a tool with 8 parameters and complex behavior. While it avoids unnecessary words, it lacks the detail needed for effective tool use, making it more of an incomplete summary than appropriately concise guidance.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (8 parameters, mutation operation, no annotations) and the presence of an output schema, the description is inadequate. It doesn't explain the upsert logic, parameter roles, or behavioral traits, leaving the agent to rely heavily on the input and output schemas. For a mutation tool with rich parameters but 0% schema coverage, this description provides minimal context beyond the tool name.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, meaning none of the 8 parameters are documented in the schema. The description only references 'performUpsert.fieldsToMergeOn', which covers one aspect of one parameter. It doesn't explain the purpose of other key parameters like 'baseId', 'table', 'records', 'typecast', 'idempotencyKey', 'dryRun', or 'conflictStrategy', failing to compensate for the lack of schema documentation.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose3/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states the tool 'Upsert Airtable records' which provides a clear verb (upsert) and resource (Airtable records), but it's vague about what 'upsert' specifically means (insert or update based on matching criteria) and doesn't distinguish it from sibling tools like 'create' or 'update'. The mention of 'performUpsert.fieldsToMergeOn' hints at the matching mechanism but doesn't fully clarify the purpose.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance is provided on when to use this tool versus alternatives like 'create' or 'update'. The description doesn't mention prerequisites, use cases, or exclusions. Without this context, an agent must infer usage from the tool name and parameters alone, which is insufficient for optimal selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

TDQS

B3.3/5.0
Disambiguation4/5

Most tools have distinct purposes, but 'create' and 'upsert' could cause confusion as both handle record creation with overlapping functionality. The other tools target clearly different operations like webhooks, schema description, listing, and querying.

Naming Consistency4/5

The naming is mostly consistent with a verb_noun pattern (e.g., list_bases, create_webhook, refresh_webhook), but 'create', 'describe', 'query', and 'update' deviate by omitting the noun, creating minor inconsistency.

Tool Count5/5

With 11 tools, the count is well-scoped for an Airtable integration, covering core operations like CRUD, webhooks, schema management, and governance without being overwhelming.

Completeness4/5

The toolset provides strong coverage for Airtable operations, including CRUD, querying, webhooks, and governance. A minor gap exists in missing explicit delete operations for records or webhooks, but agents can likely work around this.

Maintenance

ActivityMaintained
ResponsivenessUnresponsive

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    D
    maintenance
    Connects AI agents like Claude, Cursor, and Windsurf to Retable for seamless AI-assisted data management. Enables AI agents to manage and interact with Retable workspaces, tables, and data through natural language.
    19
    MIT
  • A
    license
    Not graded
    quality
    C
    maintenance
    Enables AI-powered interaction with Airtable bases, supporting CRUD operations, schema management, webhooks, and natural language queries through the MCP protocol.
    406
    MIT

Latest Blog Posts

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