List records

List records

Returns a table's records a page at a time, filtered, sorted and cut down to the fields you ask for.

The API returns up to 100 records per page with an offset for the next one; narrow it with filterByFormula, view, sort and fields. When a formula makes the URL too long, POST /v0/{baseId}/{tableIdOrName}/listRecords takes the same parameters in the body. The MCP tool and the CLI filter with structured JSON in filters, not formulas. Fields with empty values are left out of each record.

Set up

Use the first option your agent supports.

MCP (official, remote)

Add this server to your agent's MCP settings, then sign in when asked.

{ "mcpServers": { "airtable": { "url": "https://mcp.airtable.com/mcp" } } }

Call the MCP tool list_records_for_table.

Server URL: https://mcp.airtable.com/mcp

CLI (official)

Install the command, then confirm it runs.

npm install -g @airtable/mcp-cli
airtable-mcp --version

Run airtable-mcp list-records-for-table.

Set $AIRTABLE_TOKEN in your environment first (get a key: https://airtable.com/create/tokens).

API (official)

• Base URL: https://api.airtable.com
• Endpoint: GET /v0/{baseId}/{tableIdOrName}
• Auth: send the header Authorization: Bearer $AIRTABLE_TOKEN
• Get a key: https://airtable.com/create/tokens
• Docs: https://airtable.com/developers/web/api/introduction

Before doing anything else, make one read-only call to confirm access.

Rules

• Ask the user before anything that sends messages, costs money, or changes data.
• Never print API keys.