The right level of automation for an AI agent is 99%. Claude can read and rewrite every record in your Airtable base. The last 1%, deciding what actually writes back, stays with you. That is what makes it safe to point Claude at a base your team depends on.
How it works
- Scratch pulls your base into files. A base or a single table comes down to a folder on your laptop, one file per record.
- Claude edits the records. Tell it what you want across the table. Normalize every company name and fill the empty category cells from the description. Claude works the whole table.
- You review every diff and publish. Scratch shows each change next to the original, word by word. Approve what ships, and Scratch pushes only those records back through the Airtable API.
What Claude edits in Airtable
- Long-text and rich-text fields
- Single-line text, including titles
- Single-select and multi-select tags
- Date, currency, and number fields
- Attachment captions and linked-record references
Formulas, rollups, lookups, autonumber fields, and created or last-modified timestamps pass through untouched. Validators check your option sets so Claude cannot invent a select value that breaks a view. For the full picture, see Scratch for Airtable.
Why not an MCP server?
An Airtable MCP server hands Claude a direct line to your live base. One bad pass rewrites every record at once, and your views and automations react instantly. Scratch gives Claude the same full read and write access, but against a local copy. Every change waits as a diff until you approve it. The records you do not approve never leave your laptop.
Questions people ask
Is this an MCP server or an Airtable extension?
No. An MCP or extension gives Claude the write button straight to your base. Scratch does not. Claude gets the same access, but writing back is a separate step you approve, one record at a time.
Will Claude break my formulas or views?
No. Formulas, rollups, lookups, and autonumber fields pass through untouched, and validators stop Claude from inventing select values that would break a view.
Can I undo a change after it ships?
Yes. Every written record is reversible from Scratch, per row. The original sits next to the rewrite until you decide which one stays.
Can it handle a big table at once?
Yes, that is the use case. Pull 50 records to feel the flow, then pull 5,000.
Do I need to be technical?
No. Install Scratch, connect Airtable, point Claude at the folder, and approve the diffs.