filterByFormula
(string, optional): Airtable formula to filter records
How to use it
filterByFormula is exposed by the Airtable MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the filterByFormula tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
FULL AIRTABLE MCP SERVER LISTINGOther tools in Airtable MCP Server (33)
(string, required): The ID of the Airtable base
(string, optional): Description of the table
(string, optional): The amount of detail to get about the tables (tableIdentifiersOnly, identifiersOnly, or full)
(string, required): The ID of the field
(array, optional): Specific field IDs to search in. If not provided, searches all text-based fields.
(object, required): The fields and values for the new record
(number, optional): Maximum number of records to return. Defaults to 100.
(string, required): Name of the new table
(string, optional): Pagination offset for retrieving additional comments
(number, optional): Number of comments to return (max 100, default 100)
(string, optional): Parent comment ID for threaded replies
(string, required): The ID of the record to retrieve
(array, required): Array of record IDs to delete
(array, required): Array of objects containing record ID and fields to update
(string, required): Text to search for in records
(string, required): The ID of the table to query
(string, required): The comment text
(string, required): Type of the field