Business operationProject management
MCP lets an AI agent reach into the tools you already use and do the work — not just talk about it.
▶ 3 min · Jun 2026
Business operationProject managementAIProcess AutomationNoCode Development
Let AI build your Airtable
I let an AI agent build Airtable bases through the API, and flag what I must finish by hand.
▶ 3 minJun 2026Difficulty 2Cost: Free
Story behind
I build a lot of Airtable bases — my own and my clients'.
I describe the base to an AI agent,
and it builds most of it through the API.
But the API can't do everything.
It creates fields but can't delete them.
It can't edit a dropdown's options.
It can't make a lookup, rollup, or count.
Miss one of those,
and you ship a base with the wrong numbers in it.
So how do I let the agent do the fast 80%,
without leaving hidden mistakes behind?
It marks every gap as it goes, right in the field name:
- 🟡 — needs a manual fix
- 🔴 — delete this
Then I open the base and clear the markers in two minutes.
A base with no markers left is a finished base.
Why this helps you
Build in minutes, not hours — the agent does the repetitive 80% of schema-building in one pass.
Nothing breaks silently — every limit the API hits becomes a visible marker, not a hidden wrong-typed field.
A two-minute human finish — you do only the handful of clicks the API genuinely can't, guided to exactly where.
Formulas survive the cleanup — converting a placeholder keeps its field ID, so dependent formulas keep working untouched.
Reusable on every base — the same convention works for any AI-built Airtable, yours or a client's.
How to
Hover or click a step to open it.
Grab it from "Try it yourself" and give it to your agent — it carries the whole marker convention.
Good to know
Never hand off a marker silently — the agent should list every 🟡 and 🔴 it left, and what each one needs, in the same message.
Test on a throwaway table first — verify what your API key can and can't do against a scratch table before it touches real schema.
Renaming is always safe — Airtable references fields by ID, so renaming a table or field never breaks a link, lookup, or formula.
Mind the rate limit — Airtable allows about five API calls a second per base; big rename sweeps need a small pause between calls.
Try it yourself
More how-tos