Skip to main content
Glama
fastmcp-me

Airtable OAuth MCP Server

by fastmcp-me

Add to Cursor Add to VS Code Add to Claude Add to ChatGPT Add to Codex Add to Gemini

Airtable OAuth MCP Server

Python License Code style: ruff

A production-ready Model Context Protocol (MCP) server for Airtable with secure OAuth 2.0 authentication. This server enables AI assistants and applications to interact with Airtable bases through a standardized MCP interface, providing complete API coverage for all Airtable operations.

๐Ÿš€ Features

Core Functionality

  • ๐Ÿ” OAuth 2.0 Authentication - Secure token-based authentication with Airtable

  • ๐Ÿ“Š Complete Airtable API Coverage - 10 comprehensive MCP tools covering all operations

  • โšก FastMCP Framework - Built on the high-performance FastMCP framework

  • โ˜๏ธ Cloud-Ready - Production-ready deployment support

  • ๐Ÿ”„ Dual Transport - Support for both STDIO and HTTP transport protocols

Security & Reliability

  • ๐Ÿ”‘ Environment-based Configuration - Secure credential management

  • โœ… Type Safety - Full type hints and validation with Pydantic

  • ๐Ÿงช Comprehensive Testing - Unit tests with pytest and coverage reporting

  • ๐Ÿ“ Code Quality - Linting with Ruff and type checking with MyPy

Developer Experience

  • ๐Ÿ“š Rich Documentation - Comprehensive setup and usage guides

  • ๐Ÿ”ง Easy Setup - Simple installation with uv package manager

  • ๐ŸŽฏ Typed Parameters - Clear, typed tool parameters for better IDE support

  • ๐Ÿ” Flexible Querying - Advanced filtering, sorting, and search capabilities

Related MCP server: Airtable MCP Pro

๐Ÿ“‹ Prerequisites

  • Python 3.11+ - Latest Python version for optimal performance

  • uv - Fast Python package manager (install guide)

  • Airtable Developer Account - To create OAuth applications (sign up)

๐Ÿš€ Quick Start

1. Installation

Clone the repository and install dependencies:

git clone https://github.com/onimsha/airtable-mcp-server-oauth.git
cd airtable-mcp-server-oauth
uv sync

2. Airtable OAuth Setup

  1. Create an Airtable OAuth Application:

    • Visit Airtable Developer Hub

    • Create a new OAuth integration

    • Note your Client ID and Client Secret

    • Set redirect URI to http://localhost:8000/oauth/callback

3. Environment Configuration

Copy the environment template and configure your credentials:

cp .env.example .env

Edit .env with your values:

# Airtable OAuth Configuration
AIRTABLE_CLIENT_ID="your_airtable_client_id_here"
AIRTABLE_CLIENT_SECRET="your_airtable_client_secret_here"
AIRTABLE_REDIRECT_URI="http://localhost:8000/oauth/callback"

# Server Configuration
HOST="0.0.0.0"
PORT=8000
LOG_LEVEL="INFO"

4. Testing with MCP Inspector

Use the official MCP Inspector to test and interact with your server:

  1. Start the server:

    uv run python -m airtable_mcp http
  2. Open MCP Inspector: Visit https://modelcontextprotocol.io/docs/tools/inspector

  3. Connect to your server:

    • Select "HTTP Streaming" transport

    • Enter the URL: http://localhost:8000/mcp

    • Click "Connect"

  4. Authenticate with Airtable:

    • The server will guide you through OAuth authentication

    • Use the inspector to test available MCP tools

5. Run the Server

STDIO Transport (default):

uv run python -m airtable_mcp
# or
uv run airtable-oauth-mcp

HTTP Transport:

uv run python -m airtable_mcp http
# or with custom host/port
uv run python -m airtable_mcp http localhost 8001

Additional Options:

# Set log level
uv run python -m airtable_mcp --log-level DEBUG

# Show help
uv run python -m airtable_mcp --help

# Show version
uv run python -m airtable_mcp --version

The HTTP server will be available at http://localhost:8000/ (or custom host:port) with OAuth endpoints for web integration.

MCP Tools Available

The server provides 10 MCP tools for Airtable operations:

Base Operations:

  • list_bases() - List all accessible bases

  • list_tables(base_id, detail_level?) - List tables in a base

  • describe_table(base_id, table_id) - Get detailed table schema

Record Operations:

  • list_records(base_id, table_id, view?, filter_by_formula?, sort?, fields?) - List records with filtering

  • get_record(base_id, table_id, record_id) - Get a specific record

  • create_record(base_id, table_id, fields, typecast?) - Create a single record

  • create_records(base_id, table_id, records, typecast?) - Create multiple records

  • update_records(base_id, table_id, records, typecast?) - Update multiple records

  • delete_records(base_id, table_id, record_ids) - Delete multiple records

  • search_records(base_id, table_id, filter_by_formula, view?, fields?) - Search records with formulas

All tools now use typed parameters instead of generic args, making them more transparent to MCP clients.

Parameter Flexibility:

  • fields parameter accepts either a single field name (string) or array of field names

  • sort parameter expects array of objects: [{"field": "Name", "direction": "asc"}]

๐Ÿ’ก Usage Examples

Basic Record Operations

# List all records in a table
records = await client.call_tool("list_records", {
    "base_id": "appXXXXXXXXXXXXXX",
    "table_id": "tblYYYYYYYYYYYYYY"
})

# Create a new record
new_record = await client.call_tool("create_record", {
    "base_id": "appXXXXXXXXXXXXXX",
    "table_id": "tblYYYYYYYYYYYYYY",
    "fields": {
        "Name": "John Doe",
        "Email": "john@example.com",
        "Status": "Active"
    }
})

# Search records with filtering
filtered_records = await client.call_tool("search_records", {
    "base_id": "appXXXXXXXXXXXXXX",
    "table_id": "tblYYYYYYYYYYYYYY",
    "filter_by_formula": "AND({Status} = 'Active', {Email} != '')",
    "fields": ["Name", "Email", "Status"]
})

Advanced Querying

# List records with sorting and filtering
records = await client.call_tool("list_records", {
    "base_id": "appXXXXXXXXXXXXXX",
    "table_id": "tblYYYYYYYYYYYYYY",
    "view": "Grid view",
    "filter_by_formula": "{Priority} = 'High'",
    "sort": [
        {"field": "Created", "direction": "desc"},
        {"field": "Name", "direction": "asc"}
    ],
    "fields": ["Name", "Priority", "Created", "Status"]
})

# Batch operations
batch_create = await client.call_tool("create_records", {
    "base_id": "appXXXXXXXXXXXXXX",
    "table_id": "tblYYYYYYYYYYYYYY",
    "records": [
        {"fields": {"Name": "Record 1", "Value": 100}},
        {"fields": {"Name": "Record 2", "Value": 200}},
        {"fields": {"Name": "Record 3", "Value": 300}}
    ],
    "typecast": True
})

Schema Discovery

# List all bases you have access to
bases = await client.call_tool("list_bases")

# Get detailed information about a specific table
table_info = await client.call_tool("describe_table", {
    "base_id": "appXXXXXXXXXXXXXX",
    "table_id": "tblYYYYYYYYYYYYYY"
})

# List all tables in a base
tables = await client.call_tool("list_tables", {
    "base_id": "appXXXXXXXXXXXXXX",
    "detail_level": "full"
})

๐Ÿ› ๏ธ Development

Getting Started

  1. Fork and Clone:

    git clone https://github.com/onimsha/airtable-mcp-server-oauth.git
    cd airtable-mcp-server-oauth
  2. Setup Development Environment:

    uv sync --all-extras
  3. Run Tests:

    uv run pytest
    uv run pytest --cov=src/airtable_mcp --cov-report=html

Code Quality

Type Checking:

uv run mypy src/

Linting:

uv run ruff check src/
uv run ruff format src/

Pre-commit Hooks:

pip install pre-commit
pre-commit install

Testing

The project includes comprehensive test coverage:

  • Unit Tests: Test individual components and functions

  • Integration Tests: Test OAuth flow and Airtable API interactions

  • Coverage Reports: Ensure >90% code coverage

# Run all tests
uv run pytest

# Run with coverage
uv run pytest --cov=src/airtable_mcp

# Run specific test files
uv run pytest tests/test_oauth.py
uv run pytest tests/test_tools.py

Project Structure

src/
โ”œโ”€โ”€ airtable_mcp/           # Main MCP server package
โ”‚   โ”œโ”€โ”€ __init__.py         # Package initialization
โ”‚   โ”œโ”€โ”€ __main__.py         # Module entry point
โ”‚   โ”œโ”€โ”€ main.py             # CLI and application entry
โ”‚   โ”œโ”€โ”€ api/                # Airtable API client
โ”‚   โ”‚   โ”œโ”€โ”€ __init__.py
โ”‚   โ”‚   โ”œโ”€โ”€ client.py       # HTTP client for Airtable API
โ”‚   โ”‚   โ”œโ”€โ”€ exceptions.py   # API-specific exceptions
โ”‚   โ”‚   โ””โ”€โ”€ models.py       # Pydantic models for API responses
โ”‚   โ””โ”€โ”€ mcp/                # MCP server implementation
โ”‚       โ”œโ”€โ”€ __init__.py
โ”‚       โ”œโ”€โ”€ schemas.py      # MCP tool schemas
โ”‚       โ””โ”€โ”€ server.py       # FastMCP server with tools
โ””โ”€โ”€ mcp_oauth_lib/          # Reusable OAuth library
    โ”œโ”€โ”€ __init__.py         # Library initialization
    โ”œโ”€โ”€ auth/               # Authentication components
    โ”‚   โ”œโ”€โ”€ __init__.py
    โ”‚   โ”œโ”€โ”€ context.py      # Auth context management
    โ”‚   โ”œโ”€โ”€ middleware.py   # OAuth middleware
    โ”‚   โ””โ”€โ”€ utils.py        # Auth utilities
    โ”œโ”€โ”€ core/               # Core OAuth functionality
    โ”‚   โ”œโ”€โ”€ __init__.py
    โ”‚   โ”œโ”€โ”€ config.py       # OAuth configuration
    โ”‚   โ”œโ”€โ”€ flow.py         # OAuth flow implementation
    โ”‚   โ””โ”€โ”€ server.py       # OAuth server endpoints
    โ”œโ”€โ”€ providers/          # OAuth provider implementations
    โ”‚   โ”œโ”€โ”€ __init__.py
    โ”‚   โ”œโ”€โ”€ airtable.py     # Airtable OAuth provider
    โ”‚   โ””โ”€โ”€ base.py         # Base provider interface
    โ””โ”€โ”€ utils/              # OAuth utilities
        โ”œโ”€โ”€ __init__.py
        โ”œโ”€โ”€ pkce.py         # PKCE implementation
        โ””โ”€โ”€ state.py        # State management

โš™๏ธ Configuration

All configuration is handled through environment variables (loaded from .env):

Required Variables

  • AIRTABLE_CLIENT_ID - OAuth client ID from Airtable

  • AIRTABLE_CLIENT_SECRET - OAuth client secret

  • AIRTABLE_REDIRECT_URI - OAuth callback URL

Optional Variables

  • HOST - Server host (default: 0.0.0.0)

  • PORT - Server port (default: 8000)

  • LOG_LEVEL - Logging level (default: INFO)

  • MCP_SERVER_NAME - Server name (optional)

  • MCP_SERVER_VERSION - Server version (optional)

๐Ÿค Contributing

We welcome contributions! Please see our contribution guidelines:

  1. Fork the repository and create a feature branch

  2. Write tests for any new functionality

  3. Ensure code quality with our linting and formatting tools

  4. Update documentation for any API changes

  5. Submit a pull request with a clear description

Contribution Areas

  • ๐Ÿ› Bug fixes - Help us squash bugs

  • โœจ New features - Add new Airtable API endpoints

  • ๐Ÿ“š Documentation - Improve setup guides and examples

  • ๐Ÿงช Testing - Increase test coverage

  • ๐Ÿš€ Performance - Optimize API calls and caching

๐Ÿ“„ License

This project is licensed under the MIT License - see the LICENSE file for details.

๐Ÿ™ Acknowledgments

๐Ÿ“š Documentation

Additional Resources

๐Ÿ“ž Support

Available Tools

10 tools
create_recordC

Create a single record

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
table_idYesThe table ID or name
fieldsYesField values for the new record
typecastNoEnable automatic data conversion

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

C2.5/5.0
Behavior2/5

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

With no annotations provided, the description must disclose behavioral traits. It only states the action, missing details like permission requirements, return behavior, or side effects.

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 short sentence, making it concise, but lacks structure and does not provide useful information beyond the name. It is efficient but insufficient.

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?

Despite having an output schema, the description is too minimal for a tool with 4 parameters and sibling tools. It leaves many questions unanswered, such as the return value and handling of optional parameters.

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

Parameters3/5

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

Input schema has 100% description coverage for all 4 parameters, so the description adds no extra value. Baseline score of 3 applies.

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 'Create a single record' states the verb and resource, and hints at single-record creation, but it doesn't specify the context (e.g., Airtable) nor clearly differentiate from 'create_records'. It is a slight improvement over a tautology but remains generic.

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 on when to use this tool versus siblings like 'create_records' or 'update_records'. The description lacks prerequisites, context, or alternatives.

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

create_recordsC

Create multiple records

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
table_idYesThe table ID or name
recordsYesList of records to create
typecastNoEnable automatic data conversion

Output Schema

ParametersJSON Schema
NameRequiredDescription
resultYes

TDQS

C2.7/5.0
Behavior2/5

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

No annotations provided. The description does not disclose behavioral details such as error handling, atomicity, or limits. Minimal transparency.

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

Conciseness2/5

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

Extremely concise (two words) but under-specified. Sacrifices necessary detail for brevity, lacking structure.

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?

Despite an output schema and full parameter descriptions, the description is too short to provide complete context. No mention of success behavior or constraints.

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

Parameters3/5

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

The input schema has 100% parameter description coverage, so baseline is 3. The description adds no further meaning beyond the schema.

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 'Create multiple records' clearly states the action and distinguishes from the sibling 'create_record' (singular). Verb and resource are specific.

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 on when to use this tool over alternatives like 'create_record' or other tools. Context about batch limits or trade-offs is missing.

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

delete_recordsC

Delete multiple records

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
table_idYesThe table ID or name
record_idsYesList of record IDs to delete

Output Schema

ParametersJSON Schema
NameRequiredDescription
resultYes

TDQS

C2.9/5.0
Behavior2/5

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

With no annotations, the description carries the full burden. It only states the action without disclosing effects like irreversibility, permission requirements, or whether the operation is atomic. The agent receives no safety or side-effect information beyond the obvious destructive hint.

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 very brief at only two words, which is efficient. However, it lacks structure or front-loading of key information like input requirements. It earns its place but could be more informative in the same length.

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 destructive nature and lack of annotations, the description is insufficient. It does not explain return values (though output schema exists), constraints on record count, or any post-deletion behavior. The tool's complexity (3 required params) demands more context.

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

Parameters3/5

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

Schema coverage is 100% with concise parameter descriptions. The description adds no additional meaning beyond what's in the schema; baseline 3 is appropriate as the schema does the heavy lifting.

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 'Delete multiple records' clearly states the action and resource, distinguishing it from siblings like create_records or list_records. However, it could be more specific by mentioning the target system (Airtable) as inferred from schema parameter descriptions.

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 update_records or delete single records. There are no conditions or exclusions mentioned, leaving the agent without context for appropriate use.

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

describe_tableB

Get detailed information about a specific table

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
table_idYesThe table ID or name

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output 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, and the description only says 'get detailed information', which implies a read operation but does not disclose any behavioral details like permission requirements, data freshness, or potential errors. However, it does not contradict any annotations as none exist.

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, which is concise but may be too terse. It front-loads the key action and resource, but could benefit from additional context without becoming verbose. It is adequate but not exemplary.

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 presence of an output schema documenting return values, and full schema coverage for parameters, the description is minimally complete. However, it lacks usage context and does not leverage the existing structured data to reduce redundancy. It is sufficient for a simple read operation but leaves gaps.

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

Parameters3/5

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

Schema description coverage is 100%, and both parameters ('base_id' and 'table_id') have clear descriptions in the schema itself. The tool description adds no additional meaning beyond what the schema already provides, so a baseline score of 3 is appropriate.

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 verb 'get' and resource 'a specific table', which is distinct from sibling tools like 'list_tables' (lists all tables) and 'get_record' (gets a record). It provides a specific and unambiguous 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?

The description offers no guidance on when to use this tool versus alternatives such as 'list_tables' or 'get_record'. It does not mention any prerequisites or context for invocation, leaving the agent to infer from the name alone.

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

get_recordB

Get a specific record by ID

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
table_idYesThe table ID or name
record_idYesThe record ID

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

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 must fully disclose behavioral traits. While 'Get' implies a read operation, it does not explicitly state that the tool is read-only, non-destructive, or what happens if the record is missing. More detail is needed.

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 exceptionally concise at one sentence with no wasted words. However, it could benefit from slightly more structured detail, such as mentioning the expected output or context, but it remains efficient.

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's simplicity, full parameter coverage, and the presence of an output schema, the description is mostly adequate. However, it omits any mention of prerequisites, error cases, or typical use context, leaving some gaps.

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

Parameters3/5

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

All three parameters are fully described in the input schema (100% coverage), so the description's job is minimal. The description adds no extra meaning beyond what the schema already provides, resulting in a baseline score.

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 action ('Get'), the resource ('a specific record'), and the method ('by ID'). It effectively distinguishes from sibling tools like create_record or list_records, making it easy for an AI agent to understand the tool's core function.

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 lacks context about prerequisites, when not to use it, or suggestions to consider sibling tools for different operations like searching or updating.

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

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

Output Schema

ParametersJSON Schema
NameRequiredDescription
resultYes

TDQS

A3.9/5.0
Behavior3/5

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

Without annotations, the description carries full burden. It implies a read-only operation but lacks details on pagination, authentication, or rate limits. Adequate for a simple list.

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?

Single sentence that is concise, front-loaded, and contains no extraneous words. Excellent efficiency.

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

Completeness5/5

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

Given zero parameters and existing output schema, the description sufficiently informs the agent of the tool's purpose and return value. No missing context.

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?

No parameters exist, so baseline score of 4 applies. Description adds no parameter information, which is unnecessary.

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?

Description clearly states the verb 'list', resource 'bases', and scope 'all accessible', distinguishing it from sibling tools like list_tables and list_records.

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 on when to use this tool versus alternatives, nor any exclusions or prerequisites. The description is purely functional.

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

list_recordsB

List records from a table with optional filtering

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
table_idYesThe table ID or name
viewNoView name or ID
filter_by_formulaNoAirtable formula for filtering
sortNoSort configuration - array of {field: string, direction: 'asc'|'desc'}
fieldsNoSpecific fields to include (field name or array of field names)

Output Schema

ParametersJSON Schema
NameRequiredDescription
resultYes

TDQS

B3.3/5.0
Behavior2/5

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

No annotations provided, so description must disclose behaviors. It mentions 'optional filtering' but does not disclose pagination, rate limits, record limits, or ordering. For a listing tool, this lack of behavioral context is a significant gap.

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 appropriately concise at 8 words, front-loading the core purpose. However, it could include a brief note on pagination or differentiation from search_records without much expansion. Still, it avoids unnecessary detail.

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 (6 parameters, sibling search_records tool), the description is incomplete. It does not mention pagination, record limit defaults, or how filtering compares to search_records. Output schema exists but description still needs to cover behavioral gaps.

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

Parameters3/5

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

Schema description coverage is 100%, so baseline is 3. The description adds only 'with optional filtering', which hints at available filtering parameters but does not add meaning beyond the schema. Schema already fully describes all 6 parameters.

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 'List records from a table with optional filtering', specifying the action (list) and resource (records from a table). It distinguishes from siblings like get_record (single record) and search_records (more advanced search).

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 the tool is for listing records with optional filtering, but does not explicitly differentiate from sibling search_records or state when to use this over alternatives. No guidance on prerequisites or exclusions.

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

list_tablesA

List tables in a specific base

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
detail_levelNoLevel of detail to include in responsetableIdentifiersOnly

Output Schema

ParametersJSON Schema
NameRequiredDescription
resultYes

TDQS

A3.8/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. 'List' implies a read-only operation, but the description does not explicitly disclose safety, permissions, or side effects. It is adequate but not explicit.

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 with no extraneous words. Every word earns its place.

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 presence of an output schema (handling return values) and the tool's simplicity (2 params, 1 required), the description is sufficiently complete. It could add brief detail about the detail_level parameter, but not necessary.

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

Parameters3/5

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

Schema description coverage is 100%, so the schema already documents both parameters. The description adds no extra meaning beyond the schema, meeting baseline expectations without exceeding them.

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 'List tables in a specific base' clearly states the verb (list), resource (tables), and scope (specific base). It naturally distinguishes from sibling tools like list_bases (which lists bases) and describe_table (which describes a single table).

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 does not explicitly provide when to use or when not to use this tool relative to siblings. Usage is implied, but no guidance on exclusions or alternatives is given.

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

search_recordsB

Search records using a formula filter

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
table_idYesThe table ID or name
filter_by_formulaYesAirtable formula for filtering
viewNoView name or ID
fieldsNoSpecific fields to include (field name or array of field names)

Output Schema

ParametersJSON Schema
NameRequiredDescription
resultYes

TDQS

B3.3/5.0
Behavior2/5

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

With no annotations, the description must disclose behavioral traits. It does not state that this is a read-only operation, nor mention any potential side effects, pagination, or limits. While search is likely safe, the lack of explicit disclosure leaves uncertainty.

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 concise sentence with no wasted words. It is front-loaded and efficiently communicates the core purpose.

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 5 parameters and an output schema, the description is adequate but minimal. It does not mention that the tool returns multiple records or any pagination details, but the output schema may cover the return structure. Overall, it meets minimum viability.

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

Parameters3/5

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

Input schema coverage is 100%, so parameters are already well-documented. The description adds minimal value beyond restating the filter mechanism. Baseline 3 is appropriate as the description does not significantly enhance understanding of parameters.

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 searches records using a formula filter. The verb 'search' and resource 'records' are specific, and the mention of 'formula filter' distinguishes it from sibling tools like list_records (likely unfiltered) and get_record (single record by ID). However, it doesn't explicitly differentiate from these siblings.

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?

No explicit when-to-use or when-not-to-use guidance is provided. The usage is implied by the description: use when you need to filter records via a formula. But alternatives like list_records or get_record are not mentioned, leaving the agent to infer.

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

update_recordsC

Update multiple records

ParametersJSON Schema
NameRequiredDescriptionDefault
base_idYesThe Airtable base ID
table_idYesThe table ID or name
recordsYesList of record updates
typecastNoEnable automatic data conversion

Output Schema

ParametersJSON Schema
NameRequiredDescription
resultYes

TDQS

C2.4/5.0
Behavior1/5

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

The description gives no behavioral details beyond the update action. With no annotations, the tool's effects (e.g., partial vs full replacement, error handling, idempotency) are completely opaque. The output schema exists but isn't referenced.

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

Conciseness2/5

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

At three words, the description is severely under-specified. While concise, it sacrifices clarity and fails to front-load critical information (e.g., 'update multiple records in an Airtable table').

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

Completeness1/5

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

Given the complexity of a batch update operation and the existence of an output schema, the description is woefully incomplete. It omits return value structure, error behavior, limits, and caveats, leaving an agent with insufficient information to use the tool correctly.

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

Parameters3/5

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

The input schema has 100% description coverage for all four parameters. The tool description adds no additional meaning beyond the schema, so the baseline score of 3 applies.

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 'Update multiple records' clearly states the verb (update) and resource (records), distinguishing it from create, delete, or single-record tools. However, it does not explicitly mention the Airtable context or differentiate from similar batch operations beyond the name and sibling list.

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 guidelines are provided on when to use this tool versus alternatives (e.g., create_records, delete_records). There is no mention of prerequisites, limits, or situations where this tool is inappropriate.

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

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. 10 tool updatesv0.1.0
    • First observedcreate_record
    • First observedcreate_records
    • First observeddelete_records
    • First observeddescribe_table
    • First observedget_record
    • First observedlist_bases
    • First observedlist_records
    • First observedlist_tables
    • First observedsearch_records
    • First observedupdate_records

TDQS

B3.4/5.0
Disambiguation5/5

Each tool targets a distinct operation: creating single vs multiple records, listing different resources (bases, tables, records), searching with filters, and updating/deleting. No ambiguity between tools.

Naming Consistency5/5

All tools follow a consistent verb_noun pattern using snake_case (e.g., create_record, list_bases, describe_table). No mixing of styles or irregular naming.

Tool Count5/5

10 tools cover the essential Airtable operations (base/table discovery, record CRUD, search, and table metadata) without being excessive or too sparse for the domain.

Completeness4/5

The set covers core workflows: listing bases/tables, CRUD for records (including bulk operations), search, and table description. Minor gap: no explicit single-record update or delete, but bulk operations likely handle those cases.

Maintenance

ActivityInactive
ResponsivenessNo issues

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
    A
    quality
    D
    maintenance
    A production-ready Model Context Protocol server that enables AI assistants and applications to interact with Airtable bases through a standardized interface with secure OAuth 2.0 authentication.
    10
    3
    MIT
  • -
    license
    Not graded
    quality
    Not graded
    maintenance
    Enables comprehensive interaction with Airtable databases through MCP for ChatGPT Business/Projects. Supports full CRUD operations, querying, searching, and database management with pagination, filtering, and per-user authentication.
    -
  • A
    license
    B
    quality
    D
    maintenance
    Provides comprehensive access to the Airtable Web API, enabling AI assistants to create and manage bases, tables, fields, records, views, and webhooks with support for 25+ field types, batch operations, and enterprise features.
    32
    22
    1
    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/fastmcp-me/airtable-mcp-server-oauth'

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