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.
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.
- 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
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.
One command plus a key — npm install @loticdigital/airtable-mcp-server, then supply credentials