• DATA EDITS
  • DATA LOOKUP
  • HUMAN REVIEW
  • TABLE SYNC

How to update database records with your AI

Connect Retable to your AI client once. After that, you can change data just by talking to your agent.

Ask AI about this page

Short answer

How can I change Retable data with my AI?

Your AI uses the Retable MCP to find specific rows and change their values based on your instructions. You can update single fields or multiple records at once through your chat interface. This setup lets you manage your database without manual clicking.

The results.

Where your data changes.

The AI handles the technical edits while you stay in control of the logic.

DATA EDITS

Updated field values

The AI uses the update_record tool to change specific cells. Your table stays current without you opening the Retable app.

DATA LOOKUP

Found specific rows

The agent uses get_table and get_record to locate the exact information you want to change. It ensures the right data is targeted.

HUMAN REVIEW

Manual verification

You decide which changes are correct. The AI proposes the update, but you confirm the intent before the data is modified.

TABLE SYNC

Live table state

Changes happen in real time. Your Retable base reflects the new values immediately after the AI executes the command.

The workflow

What your AI does when <the thing arrives>.

The AI follows a loop of reading your data and then applying your requested changes.

  1. Locate the table

    The agent first identifies the correct table structure to understand where your data lives.

    get_table

  2. Find the row

    It searches for the specific record you mentioned to ensure it has the right context.

    get_record

  3. Apply the change

    The AI modifies the requested field values in the target row.

    update_record

  4. Confirm the update

    The agent verifies the change was successful so you know the database is accurate.

    get_record

Try it

Copy these to start.

Use these prompts to trigger your first updates.

Starting points

These are basic ideas. Swap out the table names and field names for your actual Retable setup.

Retable Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_X91AuQv858pXn8isDT9V12prRCAmmasTd9J20AeG/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Retable capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "retable-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_X91AuQv858pXn8isDT9V12prRCAmmasTd9J20AeG/mcp"
    }
  }
}
Copy into chat04

  • In my Sales table, change the Status of the row for 'Acme Corp' to 'Closed'.

  • Find the record in the Inventory table where the ID is 502 and set the stock level to 15.

  • Update the 'Last Contacted' date to today for all clients in my CRM table.

  • Change the priority of the task in my Project table named 'Website Launch' to High.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Retable once, then ask.

Just click the link to connect your account. Your credentials stay encrypted and secure, and you can immediately start chatting with your data.

Connect Retable to your AI

FAQ

How this task behaves.

  • 01

    Can the AI delete rows in my Retable base?

    No. The current tools only allow for reading and updating existing records.

  • 02

    Will the AI change my table structure?

    No. The AI can only modify the values within existing fields, not add or remove columns.

  • 03

    Does the AI need to see all my data?

    The AI only accesses the specific tables and records required to fulfill your command.

  • 04

    Can I update multiple rows at once?

    Yes, if you give a command that identifies a group of records to change.

  • 05

    How does the AI know which row to update?

    It uses the information you provide in your prompt to find the right record via the table data.

  • More questions about Retable? See everything the Retable Connector can do

Connect Retable to Claude, Cursor, ChatGPT & more