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;

Output · Query 1

[
  {
    id: place:hke4u4eqkm9lomnma9ac
  }
]

Output · Query 2

{
  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.

Continue

2: Creating records

4: Non-ASCII record IDs

Next lesson

THE PLATFORM

Everything an application and its agents know. Five surfaces, one engine.

Database

Document, graph, vector, time-series and relational in one engine.

Five data models as dotted tiles: documents, graph, vector, time-series and relational

Agent Memory

What an agent learns, with its source and its time, in the same engine.

A timeline of remembered facts, each with its source

Cloud

Managed clusters in the regions you choose, scaled on demand.

Clusters in three regions on a world map, each running or scaling

Studio

Query, explore and design the schema from the browser.

MCP

Every model that speaks MCP reaches the database and the memory directly.

Three models connected through MCP to the database and Agent Memory

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.

Justin Foley

VP of Engineering, Later