Skip to main content
Glama
felores

Airtable MCP Server

get_record

Retrieve a specific record from an Airtable base using its unique ID, table name, and base ID for targeted data access.

Instructions

Get a single record by its ID

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
base_idYesID of the base
table_nameYesName of the table
record_idYesID of the record to retrieve

Implementation Reference

  • src/index.ts:371-392 (registration)
    Registration of the 'get_record' tool in the ListTools response. Defines the tool name, description, and input schema specifying base_id, table_name, and record_id as required string parameters.
    {
      name: "get_record",
      description: "Get a single record by its ID",
      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 retrieve",
          },
        },
        required: ["base_id", "table_name", "record_id"],
      },
    },
  • The handler function for the 'get_record' tool. Extracts base_id, table_name, and record_id from arguments, makes a GET request to the Airtable API endpoint for the specific record, and returns the response data as formatted JSON text.
    case "get_record": {
      const { base_id, table_name, record_id } = request.params.arguments as {
        base_id: string;
        table_name: string;
        record_id: string;
      };
      const response = await this.axiosInstance.get(
        `/${base_id}/${table_name}/${record_id}`
      );
      return {
        content: [{
          type: "text",
          text: JSON.stringify(response.data, null, 2),
        }],
      };
    }

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/felores/airtable-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server