Base managementData

Airtable Operations Hub

Connect AI to your Airtable bases and manage your entire operations workflow in plain English. Query records, create entries, update fields, and generate summaries across any base — perfect for ops teams, project managers and startups that use Airtable as their system of record.

Default model: Claude Sonnet 4.51 serverAccess token required

Default model

Claude Sonnet 4.5

MCP servers

mcp.airtable.com

Auth

Airtable personal access token (airtable.com/create/tokens) with data.records:read and data.records:write scopes

What you can do

A few things this template does well out of the box.

  • Search and filter records across any base without formulas
  • Create or update records from meeting notes, emails or chat messages
  • Generate weekly status reports from project tracking bases
  • Identify overdue tasks, missing fields or data quality issues

How it works

Three steps to go from template to a live chat.

1

Click "Use this template"

Agent Studio opens with the MCP server, model and system prompt pre-filled.

2

Add your access token

Airtable personal access token (airtable.com/create/tokens) with data.records:read and data.records:write scopes

3

Start chatting

Ask a question, watch live tool calls and switch models at any time to compare answers.

MCP servers used

The endpoints this template connects to by default. You can swap any of them in Agent Studio.

https://mcp.airtable.com/sse

mcp.airtable.com

SSE

Getting your access token

A quick walkthrough for the credential this template needs.

  1. 1Go to **airtable.com/create/tokens** and create a personal access token.
  2. 2Add scopes: **data.records:read**, **data.records:write**, **schema.bases:read**.
  3. 3Select the bases you want the agent to access.
  4. 4Paste the token into the **Access token** field above.

Try these prompts

Copy one into the studio to see the agent in action.

  • Show all records in the "Projects" table where Status is "In Progress".

  • Create a new record in the CRM base: company "Acme", contact "Jane", stage "Negotiation".

  • How many open tasks are assigned to each team member in the Sprint table?

  • Which records in the Inventory base are below minimum stock level?

System prompt

The default instructions the model starts with. Edit it any time inside Agent Studio.

You are an Airtable operations assistant. Help ops teams, project managers and business owners manage their Airtable bases using plain English.

Use the available tools to:
- Query, filter and search records across bases and tables
- Create, update and delete records when explicitly requested
- Summarise table contents, field distributions and data quality issues
- Generate reports from multiple tables or linked records

Always scope queries with filters to avoid large result sets. Present records as clean tables or bullet lists. Confirm any write or delete operations before executing.

Ready to try the Airtable Operations Hub?

Open Agent Studio with this template pre-loaded. Add your token, pick any model, and start chatting.

Use this template

Related templates