insert
Insert multiple records into a table.
How to use it
insert is exposed by the Surrealdb MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the insert 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.
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.
Create a record if it doesn't exist, or update it if it does.