Airtable Count Records By Field on Airtable

Retrieves a single Airtable record by its record ID (starts with 'rec'). Returns all field values for that record. Use when you know the exact record ID. To search by field value use AIRTABLE_SEARCH_RECORDS.

Lists all accessible Airtable bases and optionally fetches the complete schema for a matching base in one call. Use as a starting point when you don't know the base ID or table structure. Returns base IDs, table names, and field names ready to use in other tools.

Searches Airtable records by field value without writing Airtable formula syntax. Automatically builds the filterByFormula string. Use when you need to find records matching a value. For complex filters use AIRTABLE_LIST_RECORDS with filterByFormula directly.

Scans an Airtable table and identifies records that have duplicate values in a specified field. Returns groups of duplicate records with their IDs and field values. Use for data quality checks and deduplication workflows.

Adds a new comment to an Airtable record. Comments appear in the record's activity feed and can notify collaborators. Use for adding notes, feedback, or status updates to specific records.

Creates a single new record in an Airtable table with the provided field values. Returns the created record with its new record ID. For creating multiple records at once use AIRTABLE_CREATE_MULTIPLE_RECORDS.

Lists records from an Airtable table with optional filtering, sorting, and field selection. Returns up to 100 records per page with an offset for pagination. Use filterByFormula for conditional filtering e.g. '{Status}="Active"'. For fetching ALL records use AIRTABLE_LIST_ALL_RECORDS.

Renames a field or updates its description in an Airtable table. Note: field type cannot be changed via API. To change field type, delete and recreate the field. Returns the updated field object.

Creates a new record OR updates an existing one based on a matching field value. First searches by match_field=match_value, if found updates that record, otherwise creates a new one. Use for data sync workflows where you don't know if a record already exists.

Partially updates an existing Airtable record — only the fields you provide are changed, others remain untouched. Use for targeted field updates. For replacing all fields use AIRTABLE_REPLACE_RECORD.

Creates a webhook subscription for an Airtable base to receive real-time notifications on record changes, table changes, or field changes. Returns a MAC secret for payload verification. Webhooks expire after 7 days — use AIRTABLE_REFRESH_WEBHOOK to extend. Use AIRTABLE_LIST_WEBHOOK_PAYLOADS to retrieve change details.

Partially updates up to 10 records in a single API call. Each record needs an id and fields object with only the fields to change. More efficient than individual updates for batch operations.

Adds a new field to an Airtable table. Supported types: singleLineText, multilineText, number, checkbox, singleSelect, multipleSelects, date, dateTime, email, url, phoneNumber, currency, percent, duration, rating, formula, rollup, count, lookup, attachment, multipleRecordLinks, createdTime, lastModifiedTime, autoNumber.

Lists all comments on a specific Airtable record with author info, text content, and timestamps. Returns newest comments first. Use to review discussion and feedback on a record before adding your own comment.

Retrieves ALL records from an Airtable table by automatically handling pagination with offset. Returns complete dataset. Use when you need every record in a table. For large tables this may make multiple API calls. For partial fetching with control use AIRTABLE_LIST_RECORDS.

Filters Airtable records using a raw Airtable formula for advanced queries. Supports all Airtable formula functions. Examples: 'AND({Status}="Active",{Priority}="High")' or 'IS_AFTER({Date},TODAY())'. For simple field matching use AIRTABLE_SEARCH_RECORDS instead.

Lists all Airtable bases accessible to the authenticated user with base IDs, names, and permission levels. Use this as a discovery tool before working with specific bases — you need the base ID for most other operations. Returns bases paginated with offset.

Permanently removes a webhook subscription from an Airtable base. The webhook will stop sending notifications immediately. Returns empty response on success.

Edits the text of an existing comment on an Airtable record. Only the comment author can edit their own comments. Returns the updated comment object with revised text.

Imports records from CSV-formatted data into an Airtable table. Automatically parses the CSV, maps columns to fields, and creates or upserts records in batches of 10. Handles rate limiting automatically. Use for bulk data imports from spreadsheets or external systems.

Renames an existing Airtable table or updates its description. Requires the table ID from AIRTABLE_GET_BASE_SCHEMA. Only name and description can be changed — to modify fields use AIRTABLE_UPDATE_FIELD.

Permanently deletes up to 10 records in one API call. Pass an array of record IDs. More efficient than individual deletes. This action is irreversible — deleted records cannot be recovered via API.

Returns a human-readable summary of an Airtable table including field names, types, and a sample of records. Combines schema and record data in one call. Use when you want to understand a table's structure and data at a glance before performing operations.

Returns the authenticated user's Airtable ID, email, and the permission scopes granted to the current token. Use at session start to verify authentication and check which operations are permitted with the current token's scopes.

Retrieves change notification payloads from an Airtable webhook cursor. Use after receiving a webhook ping to get the actual change details. Always pass the returned cursor in the next call to avoid reprocessing the same payloads.

Returns all members and collaborators in an Airtable workspace with their roles and permission levels. Use for workspace access management and onboarding/offboarding workflows.

Creates a new Airtable base in the specified workspace with initial tables and field definitions. Returns the new base ID. Field types supported: singleLineText, multilineText, number, checkbox, singleSelect, multipleSelects, date, email, url, phoneNumber, currency, percent.

Extends an Airtable webhook's expiration by 7 days from now. Webhooks expire after 7 days without refresh and stop sending notifications. Set up a daily schedule to call this and prevent webhook expiration.

Returns all collaborators with access to an Airtable base including their user IDs, names, emails, and permission levels (owner, create, editor, commenter, read). Use for access audits and understanding who can modify base data.

Copies records from one Airtable table to another, optionally filtering which records to copy and remapping field names. Handles pagination for large tables. Use for data migration, backup, or cross-base sync workflows.

Fully replaces an Airtable record — ALL fields not included in the request will be cleared/emptied. Use only when you intend to reset the entire record. For partial updates use AIRTABLE_UPDATE_RECORD.

Permanently deletes a comment from an Airtable record. Only the comment author can delete their own comments. This action is irreversible. Use to remove outdated or incorrect comments.

Permanently deletes a single record from an Airtable table. This action is irreversible. Returns the deleted record ID and deleted=true. For deleting multiple records use AIRTABLE_DELETE_MULTIPLE_RECORDS.

Returns the complete schema of an Airtable base including all tables, their fields with types and options, views, and primary field. Use before creating or querying records to understand the base structure. Essential for knowing available field names and types.

Creates up to 10 records in a single API call. More efficient than calling AIRTABLE_CREATE_RECORD multiple times. Each record needs a fields object. Returns array of created records with their IDs.

Creates a new table in an existing Airtable base with specified fields. Returns the new table ID. Every table automatically gets a primary Name field. Additional fields must specify type and options. Use AIRTABLE_GET_BASE_SCHEMA first to check existing tables.

Finds records older than a specified number of days based on a date field and either marks them as archived (sets a boolean field) or deletes them. Use for automated data lifecycle management and keeping active tables clean.

Lists all public share links and shared views for an Airtable base with their share IDs, types, and URLs. Use to audit what data is publicly accessible and manage sharing settings.

Lists all webhooks registered for an Airtable base including webhook IDs, endpoint URLs, event types, and expiration dates. Webhooks expire after 7 days without refresh. Use to audit or manage existing webhook subscriptions.

Creates or updates multiple records based on a matching field. For each record, searches by match_field value — updates if found, creates if not. Handles batching and rate limiting automatically. Use for syncing external data into Airtable without creating duplicates.

Retrieves records as displayed in a specific Airtable view, preserving that view's filters, sort order, and hidden fields. Use when you want records filtered exactly as a particular view shows them. Views include Grid, Gallery, Kanban, Calendar, Gantt views.

Retrieves all records from a table and returns them grouped by a specified field value as a dictionary. Useful for organizing data like {status: [records], priority: [records]}. Great for generating summaries and dashboards without complex formulas.