Connect Airtable to Claude Code
Read a base's schema, then query, create, update, and delete its records. Add Toolspoke to Claude Code once and it can use 9 Airtable actions. Your Airtable credential stays in Toolspoke, and you choose which actions Claude Code may call.
Set it up in Claude Code
Three steps, the first one once for every toolkit you will ever add.
Add Toolspoke to Claude Code
Run it in your project, then /mcp to sign in
claude mcp add --transport http toolspoke https://toolspoke.com/mcpThe sign-in opens in your browser, and Toolspoke asks you to approve it.
Install Airtable and connect it
Add Airtable to a project in your Toolspoke workspace.
Personal access token. You provide it once, when you install the connector. Toolspoke encrypts it at rest and decrypts it only for the length of a single call, and the gateway attaches it to the outbound request itself, so it is never part of the arguments an agent sends.
- Personal access token
- Airtable → Builder hub → Personal access tokens. Grant schema.bases:read and data.records:read, plus data.records:write only if this install should be able to change records, and add every base it may reach.
Choose what Claude Code may do
All 9 actions start on. Switch off any of the 4 actions that change something in Airtable, and Claude Code gets a refusal if it tries.
What you can ask Claude Code for
A few of the Airtable actions that only read, so they are safe to try first.
- List the bases the token can reach, each with its base id, name and permission level
- Return records from one table, optionally narrowed by a view and sorted
- Return the records of one table that match an Airtable formula
- Fetch one record by its record id, with every field it has a value for
What Claude Code can do in Airtable
5 actions read, 3 write and one deletes or permanently changes something.
Reads
List bases
List the bases the token can reach, each with its base id, name and permission level. Call this first: every other operation needs a base id, and a base id is not something an agent can guess from a base's name.
Get base schema
Describe every table in one base: table ids and names, each field's id, name and type (including select options and linked-record targets), and the views defined on the table. Call this after list_bases and before any record operation, it supplies the table name or id, the exact field names a filterByFormula or a write has to use, and the view names list_records accepts. Guessing a field name instead returns an empty page rather than an error.
List records
Return records from one table, optionally narrowed by a view and sorted. This is the browse operation: use it when you want a page of a table as a person would see it. Use search_records instead when you have a formula that selects the rows you want. Call get_base_schema first so `view`, `fields` and `sort_field` name things that exist. Paginate by passing the `offset` from the previous response.
Search records
Return the records of one table that match an Airtable formula. Prefer this over list_records whenever you know the condition, {Status} = 'Active', AND({Owner} = '[email protected]', {Due} < TODAY()), SEARCH('acme', LOWER({Company})). Field names go in curly braces and must match get_base_schema exactly: a formula naming a field that does not exist returns an empty page, not an error, so check the schema before concluding there are no matches.
Get record
Fetch one record by its record id, with every field it has a value for. Airtable omits empty fields entirely, so a field missing from the response is empty rather than absent from the table, get_base_schema is what tells you which fields exist. Record ids come from list_records or search_records.
Writes
Create records
Create up to 10 records in one table. Each entry is an object of field name to value, matching the types get_base_schema reports, a linked-record field takes an array of record ids, a multiple-select takes an array of option names. Set typecast to let Airtable coerce loose values (a date string, a new select option) instead of rejecting them. Returns the created records with their new record ids.
Update records
Update up to 10 existing records by record id, changing only the fields you name and leaving the rest as they are. Each entry is {"id": "recXXXX", "fields": {…}}. Use this rather than delete-then-create: it preserves the record id, its created time and every field you did not mention. Call get_record first if you need to know what a field currently holds.
Upsert records
Update records that match on one or more key fields, and create the ones that do not exist yet. Supply records without ids plus merge_on naming the fields Airtable should match against, an external id, an email address. The response separates createdRecords from updatedRecords so you can tell what happened. Prefer update_records when you already hold record ids; this exists for syncing from a source that only knows its own keys.
Deletes or permanently changes
Delete records
Permanently delete up to 10 records by record id. Airtable's API has no undo for this and the records do not go to a trash. Confirm the ids with get_record or search_records first, and prefer update_records to set a status field when the intent is to archive rather than erase.
Airtable in Claude Code: questions
Does Claude Code see my Airtable credential?
No. The credential is stored encrypted in Toolspoke, and the gateway adds it to each call. Claude Code only ever talks to Toolspoke, and the dashboard shows the last four characters of the credential and nothing more.
Can I stop Claude Code from changing things in Airtable?
Yes. Each of the 9 actions can be switched off for a project. Turn off the 4 that change something and Claude Code can only read.
Will 9 actions crowd Claude Code's context?
No. Toolspoke shows Claude Code five bridge tools, plus a guide where a toolkit has one, and Claude Code searches for the Airtable action it needs when it needs it. Adding more toolkits does not add more tools to its list.
Can I add it once for every project?
Yes. Add --scope user to the command and Claude Code keeps Toolspoke in every project on this machine. Without it, the server is added to the project you ran the command in.
What does it cost?
Tool calls are free on every plan, and a Airtable call does not run in a sandbox, so it bills nothing.
Airtable in your other apps
Try Airtable in Claude Code
Free to start, and tool calls cost nothing on any plan.