Airtable MCP Server

Instructions

Implementation Reference

• src/index.ts:544-561 (handler)

  Handler implementation for the update_record tool. Extracts arguments from the request and performs a PATCH request to the Airtable API to update the specified record.

  case "update_record": {
    const { base_id, table_name, record_id, fields } = request.params.arguments as {
      base_id: string;
      table_name: string;
      record_id: string;
      fields: Record<string, any>;
    };
    const response = await this.axiosInstance.patch(
      `/${base_id}/${table_name}/${record_id}`,
      { fields }
    );
    return {
      content: [{
        type: "text",
        text: JSON.stringify(response.data, null, 2),
      }],
    };
  }

• src/index.ts:297-322 (registration)

  Registration of the update_record tool, including its name, description, and input schema definition.

  {
    name: "update_record",
    description: "Update an existing record in a table",
    inputSchema: {
      type: "object",
      properties: {
        base_id: {
          type: "string",
          description: "ID of the base",
        },
        table_name: {
          type: "string",
          description: "Name of the table",
        },
        record_id: {
          type: "string",
          description: "ID of the record to update",
        },
        fields: {
          type: "object",
          description: "Record fields to update as key-value pairs",
        },
      },
      required: ["base_id", "table_name", "record_id", "fields"],
    },
  },

• src/index.ts:300-321 (schema)

  Input schema definition for the update_record tool, specifying parameters like base_id, table_name, record_id, and fields.

  inputSchema: {
    type: "object",
    properties: {
      base_id: {
        type: "string",
        description: "ID of the base",
      },
      table_name: {
        type: "string",
        description: "Name of the table",
      },
      record_id: {
        type: "string",
        description: "ID of the record to update",
      },
      fields: {
        type: "object",
        description: "Record fields to update as key-value pairs",
      },
    },
    required: ["base_id", "table_name", "record_id", "fields"],
  },