Airtable OAuth MCP Server

Instructions

Implementation Reference

• src/airtable_mcp/mcp/server.py:286-300 (handler)

  MCP tool handler function for 'get_record' that authenticates, calls AirtableClient.get_record, and formats the response.

  @self.mcp.tool(description="Get a specific record by ID")
  async def get_record(
      base_id: Annotated[str, Field(description="The Airtable base ID")],
      table_id: Annotated[str, Field(description="The table ID or name")],
      record_id: Annotated[str, Field(description="The record ID")],
  ) -> dict[str, Any]:
      """Get a specific record by ID."""
      client = await self._get_authenticated_client()
      record = await client.get_record(base_id, table_id, record_id)
  
      return {
          "id": record.id,
          "fields": record.fields,
          "createdTime": record.created_time,
      }

• src/airtable_mcp/mcp/schemas.py:54-60 (schema)

  Pydantic schema defining input arguments for the get_record tool.

  class GetRecordArgs(BaseArgs):
      """Arguments for get_record tool."""
  
      base_id: str = Field(description="The Airtable base ID")
      table_id: str = Field(description="The table ID or name")
      record_id: str = Field(description="The record ID")

• src/airtable_mcp/api/client.py:347-372 (helper)

  AirtableClient helper method that performs the actual HTTP GET request to retrieve a specific record from Airtable API.

  async def get_record(
      self,
      base_id: str,
      table_id: str,
      record_id: str,
  ) -> AirtableRecord:
      """Get a specific record by ID.
  
      Args:
          base_id: The Airtable base ID
          table_id: The table ID or name
          record_id: The record ID
  
      Returns:
          The requested record
      """
      logger.info(f"Getting record {record_id} from {base_id}/{table_id}")
  
      response = await self._make_request(
          "GET",
          f"/v0/{base_id}/{table_id}/{record_id}",
          response_model=AirtableRecord,
      )
  
      return response

• src/airtable_mcp/mcp/server.py:286-286 (registration)

  FastMCP tool registration decorator for the get_record handler.

  @self.mcp.tool(description="Get a specific record by ID")