All tools

Search records

Finds the records in a table whose searchable fields match a keyword, such as a company name.

View on GitHub
Updated Sep 27, 2026Available asMCPCLI

Description

Use it for free-text or fuzzy lookups on large tables; to match exact field values, filter with `list_records_for_table` instead. Pass `ALL_SEARCHABLE_FIELDS` as the fields to search every indexed field. Date, rating, checkbox and button fields are not searchable.

search-records.md

Search records

Finds the records in a table whose searchable fields match a keyword, such as a company name.

Use it for free-text or fuzzy lookups on large tables; to match exact field values, filter with list_records_for_table instead. Pass ALL_SEARCHABLE_FIELDS as the fields to search every indexed field. Date, rating, checkbox and button fields are not searchable.

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 search_records.

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 search-records.

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

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.

Built from these files in the repository

The layout and the rules come from lib/catalog/render-markdown.ts, the set-up wording from lib/catalog/render-access.ts.

Ways in

RouteSourceCallRequiredDocs
MCPOfficial · remotesearch_recordsOAuthDocs
CLIOfficialairtable-mcp search-recordsAPI key in $AIRTABLE_TOKENDocs

Workflows using Search records

No workflows yet
No published workflow uses Search records yet.