• READ
  • EDIT
  • WRITE
  • REVIEW

How to update NoSQL database records with your AI

Connect Deta Space to your AI client to perform surgical updates on JSON objects. You stop replacing entire rows and start changing only what matters.

Ask AI about this page

Short answer

How can I update specific JSON fields in Deta Base using AI?

Your AI fetches the current record, modifies the specific attributes you want, and pushes the updated version back to the database. This prevents the AI from accidentally wiping out other fields in your JSON objects. You get precise control over your data structure.

The results.

Targeted data updates.

The AI handles the heavy lifting of reading and writing, leaving you to just describe the change.

READ

Current state retrieval

The AI pulls the existing JSON object from Deta Base to see exactly what is currently stored. This ensures it knows the context before making changes.

EDIT

Granular attribute changes

Instead of a full overwrite, your agent targets only the keys you mentioned. It keeps the rest of your data intact.

WRITE

Database synchronization

The updated JSON is sent back to Deta Base immediately. Your records stay current with your conversation.

REVIEW

Human oversight

The AI presents the proposed change to you first. You decide if the update is correct before it hits your database.

The workflow

What your AI does when the request arrives.

The AI follows a precise loop to ensure data integrity during the update process.

  1. Fetch the record

    The AI looks up the specific item in your Deta Base to get its current structure and values.

    base_get_item

  2. Calculate the delta

    Your agent compares the existing data with your instructions to determine which specific JSON keys need to change.

    base_get_item

  3. Apply the update

    The AI sends the modified JSON object back to the database to replace the old version.

    base_update_item

  4. Confirm success

    The AI verifies the operation was successful and reports the new state of the record to you.

    base_get_item

Try it

Copy these to start.

Use these prompts to trigger the update workflow.

Starting points

Replace the bracketed text with your actual Deta Base names and specific JSON keys.

Deta Space Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_GX4IrdQUKPa9zaRnx8N7BCKZxc1g51D1pb49fcrf/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 — Deta Space capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "deta-space-serverless-personal-cloud-api-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_GX4IrdQUKPa9zaRnx8N7BCKZxc1g51D1pb49fcrf/mcp"
    }
  }
}
Copy into chat04

  • Update the 'status' field to 'completed' for the item with ID user_123 in my Deta Base.

  • In my 'inventory' base, change the 'stock_count' to 50 for the product record named 'widget_a'.

  • Find the record for 'project_alpha' and add a new attribute 'last_reviewed' with today's date.

  • Check the 'settings' item in my base and change the 'theme' value to 'dark'.

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

Start here

Connect Deta Space once, then ask.

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

Connect Deta Space to your AI

FAQ

How this task behaves.

  • 01

    Will the AI overwrite my entire JSON object?

    No. The AI is instructed to fetch the existing record first so it can perform a targeted update on specific keys.

  • 02

    Can the AI delete records from my Deta Base?

    No. This MCP only provides tools to get and update items. It does not have the capability to delete records.

  • 03

    Does the AI need to know the item ID?

    Yes. To perform an update, the AI needs to identify the specific record using its unique identifier.

  • 04

    Can the AI create brand new records?

    No. The available tools are limited to retrieving and updating existing items.

  • 05

    What happens if I give a vague instruction?

    The AI will ask you for clarification or the specific ID of the record you want to change before it attempts an update.

  • More questions about Deta Space? See everything the Deta Space Connector can do

Connect Deta Space to Claude, Cursor, ChatGPT & more