select
Select records from a table (all or by specific ID).
How to use it
select is exposed by the Surrealdb MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the select 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.
Update a specific record, replacing its content.
Create a record if it doesn't exist, or update it if it does.