3: Using the ONLY keyword
SurrealDB returns an array of results by default. But in queries that return a single record, you can add ONLY to return the record itself instead of the record contained inside an array.
-- Return an array with one record inside
CREATE place;
-- Return one record
CREATE ONLY place;
[
{
id: place:hke4u4eqkm9lomnma9ac
}
]{
id: place:8xi1lvtx785stp7lyy64
}This is useful when working with the output of a query. Instead of needing to use [0] to pull out the first item at index 0, the output of the query itself is now just a single record.
It is also helpful when using one of the SDKs and you want a response that can be deserialised easily into a single object.
THE PLATFORM
Everything an application and its agents know. Five surfaces, one engine.
Database
Document, graph, vector, time-series and relational in one engine.
Agent Memory
What an agent learns, with its source and its time, in the same engine.
Cloud
Dedicated clusters by region, or serverless on SurrealDB Earth.
Studio
Query, explore and design the schema from the browser.
MCP
Every model that speaks MCP reaches the database and the memory directly.
IN PRODUCTION
Trusted at scale. Samsung, Nvidia, Verizon, Tencent, and Walmart run on SurrealDB.
14,000+
Developers building on SurrealDB Cloud
4M+
Developers building on SurrealDB worldwide
FROM THE TEAMS
SurrealDB gives us a foundation where we can unify semantic search, knowledge graphs, and AI-driven decision making without stitching together multiple systems. Collapsing responsibility into SurrealDB has become our default engineering posture.
VP of Engineering, Later