Airtable MCP
The Airtable MCP server enables comprehensive natural language interaction with Airtable through 42 tools covering data management, schema manipulation, webhooks, governance, and AI-driven analytics.
Data Operations: Full CRUD (create, read, update, delete) with advanced filtering, sorting, pagination, and Airtable formula support. Batch operations handle up to 10 records simultaneously. Upsert operations update or create records based on merge fields. Write operations include dryRun for diff review, conflict detection, and resolution strategies (fail, server merge, client merge).
Schema Management: Programmatically create, update, and delete tables, fields, and views. Describe base or table schemas with configurable detail levels. Create views (grid, form, calendar, etc.) and manage field types.
Record Comments: List, create, update, and delete comments on records.
Webhooks: Configure real-time notifications for data changes—list, create, delete, refresh expiration, and retrieve payloads.
Governance & Compliance: Enforce allow-lists for bases, tables, and operations. Apply PII masking policies (mask, hash, drop) with audit logging and exception tracking with remediation proposals.
Base Management: Discover and work with multiple bases dynamically, create new bases, list collaborators and shared configurations.
AI Analytics Suite: 10 prompt templates for statistical analysis, intelligent reporting, business intelligence, workflow optimization, schema design, data quality audits, predictive analytics, natural language queries, data transformation, and automation recommendations.
Additional Features: User identity verification (whoami), attachment uploads from URLs, idempotency keys for safe retries, typecast support for automatic data conversion, and full TypeScript type safety.
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.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Airtable MCPshow me all active projects with high priority"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Airtable MCP Server
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 |
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 uselist_basesto 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 | bashThe 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_TOKENManual 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?
npxcan fail to resolve the binary when run from a directory that contains apackage.jsonwith the same package name. Thecd /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-mcpOr 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. Thecoreprofile registers the 18 record-centric tools (reads, writes, batches, governance), leaving room for other servers. Omit it (or setfull) 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 grammarserver:tool).Logs never touch stdout — all logging goes to stderr, so stdio framing is never corrupted.
Remote/HTTP clients — start the server with
PORTorMCP_HTTP_PORTset and point the client athttp://host:port/mcp(streamable HTTP, stateless;/healthfor orchestrators).Tool caps — use
AIRTABLE_TOOLSET=coreor 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
whoamitoolAI 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 (
initializehandshake) 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) whenPORT/MCP_HTTP_PORTis set, with a/healthendpoint for orchestrators.Tasks extension — deliberately not implemented: the 2026-07-28 spec moved Tasks out of core into the
io.modelcontextprotocol/tasksextension, 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_basestool)
Token Scopes
Create a Personal Access Token at airtable.com/create/tokens with these scopes:
Scope | Purpose |
| Read records |
| Create, update, delete records |
| Read record comments |
| Create, update, delete comments |
| View table schemas |
| Create and modify tables and fields |
| Read user identity (whoami) |
| 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 all accessible bases with permissions |
| Describe base or table schema (supports detail levels) |
| Query records with filtering, sorting, and pagination |
| Advanced search with Airtable formulas |
Record CRUD (5 tools)
Tool | Description |
| List records with field selection and pagination |
| Retrieve a single record by ID |
| Create new records (requires dryRun diff review) |
| Update existing records (requires dryRun diff review) |
| Remove a record from a table |
Upsert (2 tools)
Tool | Description |
| Update or create records based on merge fields |
| Batch upsert with merge-on fields |
Schema Discovery (4 tools)
Tool | Description |
| Get all tables in a base with schema info |
| Get complete schema for any base |
| Reference guide for available field types |
| List all views for a table |
Table Management (3 tools)
Tool | Description |
| Create tables with custom field definitions |
| Modify table names and descriptions |
| Remove tables (requires confirmation) |
Field Management (3 tools)
Tool | Description |
| Add fields to existing tables |
| Modify field properties and options |
| Remove fields (requires confirmation) |
Batch Operations (3 tools)
Tool | Description |
| Create up to 10 records at once |
| Update up to 10 records simultaneously |
| Delete up to 10 records in one operation |
Webhook Management (5 tools)
Tool | Description |
| View all configured webhooks |
| Set up real-time notifications |
| Remove webhook configurations |
| Retrieve notification history |
| Extend webhook expiration |
Views & Attachments (3 tools)
Tool | Description |
| Create views (grid, form, calendar, etc.) |
| Get view details including filters |
| Attach files from URLs |
Base Management (3 tools)
Tool | Description |
| Create new bases with initial structure |
| View collaborators and permissions |
| List shared views and configurations |
Record Comments (4 tools)
Tool | Description |
| List comments on a record |
| Add a comment to a record |
| Edit an existing comment |
| Remove a comment |
User Info (1 tool)
Tool | Description |
| Get current user identity and scopes |
Governance & Administration (2 tools)
Tool | Description |
| Return governance allow-lists and PII masking policies |
| List recent exceptions and remediation proposals |
AI Intelligence Suite
Ten AI prompt templates for advanced analytics:
Prompt | Description |
| Statistical analysis with anomaly detection |
| Intelligent report generation |
| Business intelligence and pattern discovery |
| Automation recommendations |
| Database optimization suggestions |
| Quality assessment and remediation |
| Forecasting and trend prediction |
| Process questions with context awareness |
| AI-assisted data processing |
| 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 |
| Yes | Personal Access Token |
| No | Default base ID (discoverable via |
| No | Which tools to register: |
| No | Logging level (default: |
| 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
npxas shown in the Quick Start sections above.
git clone https://github.com/rashidazarang/airtable-mcp.git
cd airtable-mcp
npm install
npm run buildTesting
npm run test:types # Type checking
npm test # Run test suiteProject 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 executablesTroubleshooting
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_basesto 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 toolscreateA
Create Airtable records (requires diff-before-write via dryRun first).
| Name | Required | Description | Default |
|---|---|---|---|
| baseId | Yes | ||
| table | Yes | ||
| records | Yes | ||
| typecast | No | ||
| idempotencyKey | No | ||
| dryRun | No |
Output Schema
| Name | Required | Description |
|---|---|---|
| diff | Yes | |
| dryRun | Yes | |
| records | No | |
| warnings | No |
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
TDQS
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.
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.
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.
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.
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.
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)
| Name | Required | Description | Default |
|---|---|---|---|
| scope | Yes | ||
| baseId | Yes | ||
| table | No | ||
| detailLevel | No | full | |
| includeFields | No | ||
| includeViews | No |
Output Schema
| Name | Required | Description |
|---|---|---|
| base | Yes | |
| views | No | |
| tables | No |
TDQS
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.
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.
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.
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.
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.
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
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
Output Schema
| Name | Required | Description |
|---|---|---|
| bases | Yes |
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| since | No | ||
| severity | No | ||
| limit | No | ||
| cursor | No |
Output Schema
| Name | Required | Description |
|---|---|---|
| items | Yes | |
| cursor | No |
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
Output Schema
| Name | Required | Description |
|---|---|---|
| piiFields | Yes | |
| allowedBases | Yes | |
| allowedTables | Yes | |
| loggingPolicy | Yes | |
| retentionDays | Yes | |
| redactionPolicy | Yes | |
| allowedOperations | Yes |
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| baseId | Yes | ||
| table | Yes | ||
| fields | No | ||
| filterByFormula | No | ||
| view | No | ||
| sorts | No | ||
| pageSize | No | ||
| maxRecords | No | ||
| offset | No | ||
| returnFieldsByFieldId | No |
Output Schema
| Name | Required | Description |
|---|---|---|
| offset | No | |
| records | Yes | |
| summary | No |
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
TDQS
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.
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.
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.
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.
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.
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).
| Name | Required | Description | Default |
|---|---|---|---|
| baseId | Yes | ||
| table | Yes | ||
| records | Yes | ||
| typecast | No | ||
| idempotencyKey | No | ||
| dryRun | No | ||
| conflictStrategy | No | fail_on_conflict | |
| ifUnchangedHash | No |
Output Schema
| Name | Required | Description |
|---|---|---|
| diff | Yes | |
| dryRun | Yes | |
| records | No | |
| conflicts | No |
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| baseId | Yes | ||
| table | Yes | ||
| records | Yes | ||
| performUpsert | Yes | ||
| typecast | No | ||
| idempotencyKey | No | ||
| dryRun | No | ||
| conflictStrategy | No | fail_on_conflict |
Output Schema
| Name | Required | Description |
|---|---|---|
| diff | Yes | |
| dryRun | Yes | |
| records | No | |
| conflicts | No |
TDQS
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.
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.
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.
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.
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.
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
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.
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.
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.
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
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
No-code databases, forms, portals and AI sites. Manage records and automation via natural language.
No-code databases, forms, portals and AI sites. Manage records and automation via natural language.
No-code databases, forms, portals and AI sites. Manage records and automation via natural language.
Streamline your Attio workflows using natural language to search, create, update, and organize com…
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceProvides tools for AI assistants to interact with Airtable databases, enabling CRUD operations on Airtable bases and tables.13MIT
- AlicenseNot gradedqualityCmaintenanceProvides read and write access to Airtable databases, enabling LLMs to inspect schemas, search, create, update, and delete records, tables, and fields, as well as manage comments on records.3,739MIT

Retable MCP Serverofficial
AlicenseNot gradedqualityDmaintenanceConnects 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.19MIT- AlicenseNot gradedqualityCmaintenanceEnables AI-powered interaction with Airtable bases, supporting CRUD operations, schema management, webhooks, and natural language queries through the MCP protocol.406MIT
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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