Airtable logo
    Files & productivity Supported

    Airtable integration for Rig

    The easiest way to connect Airtable to Claude and other AI tools

    Airtable is a spreadsheet-database hybrid teams use to run processes that never got a proper system: content calendars, supplier lists, product roadmaps.

    What Rig syncs from Airtable

    Once connected, Rig models these objects so questions resolve to the right tables and joins:

    • Records from the selected table
    • Field values
    • Record metadata

    How Airtable connects to Rig

    Give Rig a personal access token and the base and table you want. Rig syncs that table's records into the warehouse. Airtable's record API is per table, so add a connection per table you want synced.

    Join hand-maintained data to systems data

    The mapping that makes a report correct is often in Airtable: campaign to category, SKU to supplier, account to segment. Bringing it into the warehouse means those mappings apply automatically rather than being pasted into a spreadsheet each month.

    Ask Rig
    • Apply our campaign categorisation to ad spend by month
    • Which SKUs are missing from the supplier mapping table?
    • Report revenue using the segment definitions from Airtable

    Report on processes that live in Airtable

    Plenty of real work runs in Airtable and reports nowhere. Once records are in the warehouse, that work can be measured alongside everything else rather than counted by hand.

    Ask Rig
    • How many items moved through this process last month?
    • What is the average time from request to completion?
    • Which owners have the most outstanding items?

    Find where the source of truth has drifted

    Manually maintained tables drift from the systems they describe. Held together in one warehouse, the gaps become visible: products in the system missing from the table, or entries pointing at things that no longer exist.

    Ask Rig
    • Which products exist in Shopify but not in our Airtable catalogue?
    • Where does our Airtable mapping reference a campaign that no longer runs?
    • Which records have not been updated in six months?

    Ask your Airtable data in Claude, ChatGPT or Cursor

    Rig serves your Airtable data to AI assistants over MCP. Once Airtable is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL.

    Frequently asked questions

    Can Rig sync a whole base?
    Currently one table per connection, because Airtable's record API works per table. Add a connection for each table you need, and tell us if you want a whole base covered.
    What do I need to connect Airtable?
    A personal access token, plus the base and table identifiers.
    Does it handle custom fields?
    Yes. Fields come across as columns, so whatever your team has built lands in the warehouse.
    Why sync Airtable at all?
    Because it usually holds the mappings and definitions that make other reporting correct, and re-entering those by hand every month is where reporting errors come from.

    Related integrations

    Connect Airtable data to AI tools like Claude

    Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust.