Airtable OAuth MCP Server

Instructions

Implementation Reference

• src/airtable_mcp/mcp/server.py:390-407 (handler)

  MCP tool handler function for delete_records. Registers the tool with FastMCP and implements the logic by calling AirtableClient.delete_records after authentication.
  @self.mcp.tool(description="Delete multiple records") async def delete_records( base_id: Annotated[str, Field(description="The Airtable base ID")], table_id: Annotated[str, Field(description="The table ID or name")], record_ids: Annotated[ list[str], Field(description="List of record IDs to delete") ], ) -> list[str]: """Delete multiple records from a table.""" client = await self._get_authenticated_client() deleted_ids = await client.delete_records( base_id, table_id, record_ids, ) return deleted_ids
• src/airtable_mcp/api/client.py:441-469 (helper)

  AirtableClient.delete_records method: makes DELETE request to Airtable API with record_ids, parses DeleteRecordsResponse, returns list of deleted IDs.
  async def delete_records( self, base_id: str, table_id: str, record_ids: list[str], ) -> list[str]: """Delete records from a table. Args: base_id: The Airtable base ID table_id: The table ID or name record_ids: List of record IDs to delete Returns: List of deleted record IDs """ logger.info(f"Deleting {len(record_ids)} records from {base_id}/{table_id}") params = {"records[]": record_ids} response = await self._make_request( "DELETE", f"/v0/{base_id}/{table_id}", params=params, response_model=DeleteRecordsResponse, ) return [record["id"] for record in response.records]
• src/airtable_mcp/mcp/schemas.py:95-101 (schema)

  Pydantic schema/model for delete_records tool input arguments (base_id, table_id, record_ids).
  class DeleteRecordsArgs(BaseArgs): """Arguments for delete_records tool.""" base_id: str = Field(description="The Airtable base ID") table_id: str = Field(description="The table ID or name") record_ids: list[str] = Field(description="List of record IDs to delete")
• src/airtable_mcp/api/models.py:97-101 (schema)

  Pydantic model for Airtable delete records API response.
  class DeleteRecordsResponse(BaseModel): """Response from deleting records.""" records: list[dict[str, Any]]