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