• NEW DATA
  • UPDATES
  • CLEANUP
  • HUMAN

How to manage database records with your AI

Connect SurrealDB to your AI client to turn plain text commands into database actions. Once connected, your agent handles the data manipulation for you.

Ask AI about this page

Short answer

Can I use my AI to manage SurrealDB records?

Yes. You can tell your agent to create, update, or delete specific records and perform bulk updates using natural language. You'll get direct control over your data through simple conversation.

Data outcomes

Where your commands land

Every request you send to your agent results in one of these four outcomes.

NEW DATA

Records created

Your agent adds new entries to your tables based on your descriptions. It handles the insertion logic so you don't have to.

UPDATES

Records modified

Change specific values or update entire sets of data at once. Your agent applies these changes to the existing records immediately.

CLEANUP

Records deleted

Remove single entries or wipe entire tables when they are no longer needed. The AI executes the removal based on your specific criteria.

HUMAN

Manual review

Complex structural changes or sensitive schema modifications stay with you. The AI won't touch the core database architecture without your direct oversight.

The workflow

What your AI does when a command arrives.

Your agent translates your intent into direct database operations.

  1. Add entries

    The agent takes your description of a new entity and builds the record in your database.

    create_recordcreate_specific_record

  2. Edit data

    Your agent finds the right records and applies the changes you ask for.

    update_recordmodify_record

  3. Bulk changes

    When you need to change many things at once, the AI handles the mass updates.

    update_allmodify_all

  4. Remove records

    The AI clears out specific rows or empties tables based on your instructions.

    delete_recorddelete_all

Try it

Copy these to start.

Use these prompts to trigger actions in SurrealDB.

Starting points

These are opening lines. Swap out the table names and field values to match your actual SurrealDB schema.

SurrealDB Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_z8y2X9S7Lg9neGU4YlezuYLhsuJbWmTxMe30Ga4Q/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 — SurrealDB capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "surrealdb-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_z8y2X9S7Lg9neGU4YlezuYLhsuJbWmTxMe30Ga4Q/mcp"
    }
  }
}
Copy into chat04

  • Create a new user record in the users table with the name 'Alex' and email 'alex@example.com'.

  • Update the status of all pending orders to 'shipped'.

  • Delete the record in the logs table where the ID is '12345'.

  • Modify all products in the inventory table to increase the price by 10 percent.

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

Start here

Connect SurrealDB once, then ask.

Follow the link to connect your database. Your login stays encrypted on our side, and you can start managing data immediately.

Connect SurrealDB to your AI

FAQ

How the SurrealDB Connector behaves

  • 01

    Can the AI change my database schema?

    No. The AI can only manage records through the provided tools; it cannot alter tables, indexes, or the underlying schema structure.

  • 02

    Will the AI delete everything if I'm not careful?

    The AI only executes the specific delete commands you authorize. It cannot perform a delete_all operation unless you explicitly tell it to clear everything.

  • 03

    Does the AI need to know my database password?

    No. You connect via Vinkius, which manages your credentials securely. Your AI client never sees your raw login details.

  • 04

    Can I perform complex joins using natural language?

    No. The current tools focus on CRUD operations like creating, updating, and deleting records. It does not have a tool for running arbitrary complex SurrealQL join queries.

  • 05

    Can the AI create multiple records at once?

    Yes. You can instruct the AI to create multiple records, and it will use the appropriate creation tools to fulfill the request.

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

Connect SurrealDB to Claude, Cursor, ChatGPT & more