upsert
Create a record if it doesn't exist, or update it if it does.
How to use it
upsert is exposed by the Surrealdb MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the upsert tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install Surrealdb MCP Server
npm install -g surrealdb-mcp-serverOther tools in Surrealdb MCP Server (9)
Create a single new record in a table.
Delete a specific record by ID.
Insert multiple records into a table.
Create a graph relation (edge) between two records.
Merge data into a specific record (partial update).
Apply JSON Patch operations to a specific record.
Execute a raw SurrealQL query.
Select records from a table (all or by specific ID).
Update a specific record, replacing its content.