SingleStoreDb

Store AgentOS sessions, memory, knowledge, evals, and traces in SingleStore.

SingleStoreDb implements the Db interface with SingleStore tables for Agent, Team, and Workflow sessions, memories, knowledge, metrics, evals, cultural knowledge, traces, spans, and schema versions.

Parameter	Type	Default	Description
id	Optional[str]	-	The ID of the database instance. UUID by default.
db_engine	Optional[Engine]	-	The SQLAlchemy database engine to use.
db_schema	Optional[str]	-	The database schema to use.
db_url	Optional[str]	-	The database URL to connect to.
session_table	Optional[str]	-	Name of the table to store Agent, Team and Workflow sessions.
memory_table	Optional[str]	-	Name of the table to store memories.
metrics_table	Optional[str]	-	Name of the table to store metrics.
eval_table	Optional[str]	-	Name of the table to store evaluation runs data.
knowledge_table	Optional[str]	-	Name of the table to store knowledge content.
culture_table	Optional[str]	-	Name of the table to store cultural knowledge.
traces_table	Optional[str]	-	Name of the table to store traces.
spans_table	Optional[str]	-	Name of the table to store spans.
versions_table	Optional[str]	-	Name of the table to store schema versions.
create_schema	bool	True	Whether to create the database schema if it doesn't exist. Set to False when the schema is managed externally.

Methods

upsert_sessions

Upsert multiple sessions in one method call.

Parameters:

• sessions (List[Session]): List of sessions to upsert
• deserialize (Optional[bool]): Whether to deserialize the sessions. Defaults to True
• preserve_updated_at (bool): Whether to keep the sessions' existing updated_at timestamps. Defaults to False

Returns: List[Union[Session, Dict[str, Any]]]

upsert_memories

Upsert multiple memories in one method call.

Parameters:

• memories (List[UserMemory]): List of memories to upsert
• deserialize (Optional[bool]): Whether to deserialize the memories. Defaults to True
• preserve_updated_at (bool): Whether to keep the memories' existing updated_at timestamps. Defaults to False

Returns: List[Union[UserMemory, Dict[str, Any]]]