Airtableデータベースの読み書きアクセスを提供するモデルコンテキストプロトコルサーバーです。このサーバーはLLMがデータベーススキーマを検査し、レコードの読み書きを可能にします。

https://github.com/user-attachments/assets/c8285e76-d0ed-4018-94c7-20535db6c944

設置

install-mcpの手順に従ってください。こちらはMCPクライアント(Claude Code、Claude Desktop、Cursor、Cline、VS Codeなど)に適した設定を生成します。

Airtableのパーソナルアクセストークンが必要です。ここで、スコープschema.bases:readとdata.records:read(オプションでschema.bases:write、data.records:write、data.recordComments:read、data.recordComments:write)と使いたいベースへのアクセスで作成してください。見た目はpat123.abc123に近いですが、より長いです。生成設定のプレースホルダーをAIRTABLE_API_KEYに置き換えて設定してください。

構成要素

道具

• list_records
• 指定されたAirtableテーブルからのレコード一覧
• 入力パラメータ:
• baseId(文字列、必須):AirtableベースのID
• tableId(文字列、必須):クエリするテーブルのID
• maxRecords(番号、任意):返すべきレコードの最大数。デフォルトは100です。

airtable-mcp-server

A Model Context Protocol server that provides read and write access to Airtable databases. This server enables LLMs to inspect database schemas, then read and write records.

https://github.com/user-attachments/assets/c8285e76-d0ed-4018-94c7-20535db6c944

Installation

Follow the instructions on install-mcp, which generates the right config for your MCP client (Claude Code, Claude Desktop, Cursor, Cline, VS Code, and more).

You’ll need an Airtable personal access token — create one here with scopes schema.bases:read and data.records:read (and optionally schema.bases:write, data.records:write, data.recordComments:read, data.recordComments:write), and access to the bases you want to use. It looks something like pat123.abc123 (but longer). Set it as AIRTABLE_API_KEY (replacing the placeholder in the generated config).

Components

Tools

• list_records

  • Lists records from a specified Airtable table
  • Input parameters:
    • baseId (string, required): The ID of the Airtable base
    • tableId (string, required): The ID of the table to query
    • maxRecords (number, optional): Maximum number of records to return. Defaults to 100.
    • filterByFormula (string, optional): Airtable formula to filter records

• search_records

  • Search for records containing specific text
  • Input parameters:
    • baseId (string, required): The ID of the Airtable base
    • tableId (string, required): The ID of the table to query
    • searchTerm (string, required): Text to search for in records
    • fieldIds (array, optional): Specific field IDs to search in. If not provided, searches all text-based fields.
    • maxRecords (number, optional): Maximum number of records to return. Defaults to 100.

• list_bases

  • Lists all accessible Airtable bases
  • No input parameters required
  • Returns base ID, name, and permission level

• list_tables

  • Lists all tables in a specific base
  • Input parameters:
    • baseId (string, required): The ID of the Airtable base
    • detailLevel (string, optional): The amount of detail to get about the tables (tableIdentifiersOnly, identifiersOnly, or full)
  • Returns table ID, name, description, fields, and views (to the given detailLevel)

• describe_table

  • Gets detailed information about a specific table
  • Input parameters:
    • baseId (string, required): The ID of the Airtable base
    • tableId (string, required): The ID of the table to describe
    • detailLevel (string, optional): The amount of detail to get about the table (tableIdentifiersOnly, identifiersOnly, or full)
  • Returns the same format as list_tables but for a single table