`airtable_list_records`

Pack: airtable · Endpoint: https://gateway.pipeworx.io/airtable/mcp

Fetch records from an Airtable table with optional filtering by formula (e.g., “{Status} = ‘Done’”). Returns record IDs, field values, and metadata.

Parameters

Name	Type	Required	Description
`_apiKey`	string	yes	Airtable personal access token
`baseId`	string	yes	Airtable base ID (e.g., appXXXXXXXXXXXX)
`tableIdOrName`	string	yes	Table ID or name
`filterByFormula`	string	no	Airtable formula to filter records (optional)
`maxRecords`	number	no	Maximum number of records to return (default 100)

Example call

Arguments

{
  "_apiKey": "your-airtable-api-key",
  "baseId": "appXXXXXXXXXXXX",
  "tableIdOrName": "Tasks"
}

curl

curl -X POST https://gateway.pipeworx.io/airtable/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"airtable_list_records","arguments":{"_apiKey":"your-airtable-api-key","baseId":"appXXXXXXXXXXXX","tableIdOrName":"Tasks"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('airtable_list_records', {
  "_apiKey": "your-airtable-api-key",
  "baseId": "appXXXXXXXXXXXX",
  "tableIdOrName": "Tasks"
});

More examples

{
  "_apiKey": "your-airtable-api-key",
  "baseId": "appXXXXXXXXXXXX",
  "tableIdOrName": "Tasks",
  "filterByFormula": "{Status} = 'Done'",
  "maxRecords": 50
}

Response shape

Always returns: records

Field	Type	Description
`records`	array	List of records matching the query
`offset`	string	Pagination offset for next batch of records

Full JSON Schema

{
  "type": "object",
  "properties": {
    "records": {
      "type": "array",
      "description": "List of records matching the query",
      "items": {
        "type": "object",
        "properties": {
          "id": {
            "type": "string",
            "description": "Record ID"
          },
          "fields": {
            "type": "object",
            "description": "Field name/value pairs for this record"
          },
          "createdTime": {
            "type": "string",
            "description": "ISO timestamp when record was created"
          }
        }
      }
    },
    "offset": {
      "type": "string",
      "description": "Pagination offset for next batch of records"
    }
  },
  "required": [
    "records"
  ]
}

Connect

Add this to your MCP client config, or use one-click install buttons:

{
  "mcpServers": {
    "airtable": {
      "url": "https://gateway.pipeworx.io/airtable/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

airtable_list_records