advanced_list_records
List records with advanced filtering, sorting, and pagination
LABSCO SUMMARY
Schema-level access, which is what makes an agent able to build a base rather than just fill one.
Most Airtable connectors stop at records. This one creates tables, adds fields across the full type range including formulas, rollups and record links, and configures views, so "set up a tracker for this" is something the agent can carry out rather than describe. Large bases are the thing to plan for: a full schema can exceed what a single response will carry, and the schema tool pages through it rather than failing.
What it is
A server over the Airtable Web API. It covers the schema layer — bases, tables, fields and views — as well as records, with batch operations and webhook management.
What you get
- Bases listed, a complete base schema with all tables and fields, and base deletion where the plan allows it
- Tables listed, created with their field configuration, and their schema updated
- Fields listed, created, updated and deleted across the Airtable type range — text, number, currency, percent, date and dateTime, singleSelect and multipleSelects, rating, checkbox, formula, rollup, lookup, multipleRecordLinks, attachment, barcode, button, count and autoNumber
- Records listed, fetched by ID, searched, created, updated and deleted one at a time, or created, updated and deleted in batches
- Advanced listing with filtering, sorting, pagination and field selection when the basic list is not enough
- Views listed, read for their configuration, created, updated and deleted — grid, form, calendar, gallery, kanban, timeline and gantt
- Webhooks created, listed, updated and deleted, with their notification history readable
Requirements
An Airtable personal access token in AIRTABLE_API_KEY — the older API keys stopped working in February 2024. The token needs both the right scopes and the specific bases added to it as resources, and it acts as the user who created it, so its access is theirs. Run it with npx @loticdigital/airtable-mcp-server; the npm package is @loticdigital/airtable-mcp-server, currently 0.5.4, with an airtable-server binary. Airtable's own limits apply: 5 requests per second per base, and monthly API calls capped at 1,000 per workspace on Free and 100,000 on Team, with Business and Enterprise uncapped. Deleting a base is Enterprise-only.
Setup effort
One command plus a key — npm install @loticdigital/airtable-mcp-server, then supply credentials
USE CASES
01
Understanding a base you have just been given access to
List the bases, then read the full schema — tables and fields — before touching anything.
02
Standing up a tracker from a description
Create the table, add the fields with their types and options, then add the views people will actually use.
03
Loading a batch of rows without hitting the rate limit
Create the records in batches rather than one call each — 5 requests per second per base is the ceiling.
04
Pulling a filtered, sorted slice of a large table
Use the advanced listing with filters, sort order, pagination and only the fields you need.
05
Updating many records after a decision
Search for the ones that match, then update them in a single batched call.
06
Getting notified when the base changes
Create the webhook, then read its notification history to confirm events are arriving.
30 tools
Counted once with only startup setup. Other versions, modes or optional credentials may expose a different list.
batch_create_records
Create multiple records in a single request
batch_delete_records
Delete multiple records in a single request
batch_update_records
Update multiple records in a single request
create_field
Create a new field in a table
create_record
Create a new record in a table
create_table
Create a new table in a base
create_view
Create a new view in a table
create_webhook
Create a new webhook for real-time notifications
delete_base
Delete a base (Enterprise only)
delete_field
Delete a field from a table
delete_record
Delete a record from a table
delete_view
Delete a view from a table
delete_webhook
Delete a webhook
get_base_schema
Get complete base schema including all tables and fields
get_record
Get a single record by its ID
get_view
Get view configuration
get_webhook_payloads
Get webhook notification history
list_bases
List all accessible Airtable bases
list_fields
List all fields in a table
list_records
List records in a table
list_tables
List all tables in a base
list_views
List all views in a table
list_webhooks
List all webhooks for a base
search_records
Search for records in a table
update_field
Update a field in a table
update_record
Update an existing record in a table
update_table
Update a table's schema
update_view
Update an existing view
update_webhook
Update an existing webhook
BEFORE YOU INSTALL
What to know first
Tools you get
30 tools when we connected. There is no delete_table tool, and none of the listed Enterprise features (user, workspace, audit log, share link or collaborator management) is exposed as a tool.
Requires
- npx on PATH
- AIRTABLE_API_KEY in your environment
CONTEXT COST
Light Standing cost
Rated by the size of the 30 tool definitions that ride along on every turn, not by how many there are
INSTALLATION
Connect your client
Server setup
TERMINAL
npm install @loticdigital/airtable-mcp-serverMCP Clients
Claude Desktop
CLAUDE DESKTOP · JSON
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"@loticdigital/airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "<YOUR_AIRTABLE_API_KEY>"
}
}
}
}MCP Inspector (test only)
MCP INSPECTOR (TEST ONLY) · TERMINAL
npx @modelcontextprotocol/inspector npx @loticdigital/airtable-mcp-server
