Labsco
MCP SERVER

Airtable

by felores

Build an Airtable base from a conversation — create tables, add fields one at a time, then read, search, write and delete the records inside them.

NoSQL, Graph & Key-Value StoresVerified
Summary
Creating the schema is the part most Airtable integrations get wrong, and this one slows it down deliberately.

Complex fields each carry their own required options — precision on a number, choices with colours on a select, formats on a date — and building a whole table in one call is where that usually falls over; here fields are added individually and verified as you go, which is why the repository ships a system prompt to keep the model doing it that way. The token scopes decide what is possible: without schema.bases:write the table and field tools cannot run at all, so grant them at creation rather than debugging permission errors later.

What it is

A schema-and-records surface over the Airtable API. Alongside record operations it creates and alters tables and fields, and it is written to build a table in stages rather than in one large call.

What you get
  • list_bases shows every base the token can reach, and list_tables enumerates a base's tables
  • create_table makes a table with an initial field set and description; update_table renames it or changes the description
  • create_field and update_field add and modify fields one at a time — the staged approach the guide recommends for anything beyond plain text
  • Field types documented with what each one needs: singleLineText, multilineText, email, phoneNumber, richText and url take no options, while number, currency and percent need precision, rating needs a maximum and an icon, date and dateTime need formats, and singleSelect and multipleSelects need their choices with names and colours
  • list_records with a max_records cap, get_record by id, and search_records matching a value in a named field
  • create_record, update_record and delete_record for individual rows
  • A system prompt and project knowledge file in the repository, meant to be loaded into a Claude project so the model follows the staged build pattern
Requirements

An Airtable personal access token, created at Airtable's Builder Hub with the scopes data.records:read, data.records:write, schema.bases:read and schema.bases:write, and scoped to the workspace or bases it should reach. It goes in AIRTABLE_API_KEY. Node.js 18 or higher; it runs as npx @felores/airtable-mcp-server. MIT.

Setup effort

One command plus a key — npx @felores/airtable-mcp-server, then supply credentials