How to Use the Airtable MCP in Claude Code

Q: How do I update multiple Airtable records from a script using Claude Code?

The updaterecords tool is what you need. In your script, instruct Claude Code to update records matching certain criteria with new data. It performs the operation in a single batch request.

Pipe Airtable data directly into your shell scripts with this MCP Server. A headless, terminal-native way to manage bases with Claude Code.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Airtable MCP to Claude Code

Create your Vinkius account to connect Airtable to Claude Code and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Airtable with Claude Code

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Airtable for Your CI/CD Pipelines

This is for automating your devops tasks. Use Claude Code in a GitHub Action to check a feature flag in an Airtable base before deploying. Or, have it create a new record in a 'Deployments' table after a successful run. Because it's headless and runs from the command line, you can integrate Airtable operations into any script. Use `get_record` to fetch a config value or `update_records` to change the status of a build entry, all from your CI environment.

Scriptable Database Management

Forget manual cleanup. Write a simple shell script that calls Claude Code to run maintenance on your Airtable bases. Set up a cron job to periodically run `search_records` and `delete_records` to archive old entries. You can also pipe data between commands. Use `list_records` to get a JSON array of records, then pipe it to `jq` for filtering, and then feed the results back into another Claude Code command to update a different table. It's all text, so it's all scriptable.

A Headless MCP Server for Airtable

There's no GUI here. This MCP Server gives Claude Code a set of command-line tools for Airtable. You can list all your bases with `list_bases` or inspect a table's structure with `list_tables` and `list_fields`, with the output printed directly to stdout. This is about raw, programmatic access. You're not asking an agent to chat with you; you're telling it to execute a command and give you the data. It's perfect for backend scripts where you just need the job done.

Setup guide

Set up Airtable MCP in Claude Code

Prerequisites

Claude Code CLI installed (npm install -g @anthropic-ai/claude-code)
Active Vinkius subscription with a valid endpoint token

1

Run the add command

Open your terminal and run the command shown on the right. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com. Use --scope user to make it available across all projects.
2

Verify the connection

Start a Claude Code session and type /mcp to list connected servers. You should see airtable-mcp with a green status indicator.
3

Start using tools

Ask Claude Code something like "Check my latest Airtable transactions." It will automatically discover and invoke the available Airtable tools.

Terminal

claude mcp add --transport http airtable-mcp https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp

Get your connection token →

Prerequisites

Claude Code CLI installed
Active Vinkius subscription with a valid endpoint token

1

Open the config file

Create or edit .mcp.json in your project root for project-level scope, or ~/.claude.json for user-level scope.
2

Add the Airtable MCP

Paste the JSON snippet shown on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Restart Claude Code

Start a new Claude Code session. Type /mcp to confirm the server is connected. The tools will be automatically available in your conversation.

.mcp.json

{
  "mcpServers": {
    "airtable-mcp": {
      "type": "url",
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Airtable. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Airtable now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Airtable MCP in Claude Code

Just run the command and ask it to list your bases. Claude Code will use the `list_bases` tool and print the names and IDs of your Airtable bases directly to your console.

Yes. Write a shell script that calls Claude Code with a prompt to use the `create_records` tool. Then, just point a cron job to that script to run it on your desired schedule.

Definitely. Use a prompt with your search criteria. Claude Code will invoke the `search_records` tool with an Airtable formula and pipe the matching records back to you as JSON output.

The `update_records` tool is what you need. In your script, instruct Claude Code to update records matching certain criteria with new data. It performs the operation in a single batch request.

Your credentials live on the Vinkius platform, not in your CI secrets. Your runner uses a short-lived Vinkius token to talk to the MCP server, which then makes the call to Airtable. The connection is proxied and the server environment is ephemeral, so no record or base metadata is ever stored on the runner or the server.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript