MySQLDb

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

MySQLDb implements the Db interface with MySQL 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]	None	Database ID. Derived from the connection and schema when omitted.
db_engine	Optional[Engine]	None	SQLAlchemy database engine. Provide this or db_url.
db_schema	Optional[str]	None	Database schema. Uses "ai" when omitted.
db_url	Optional[str]	None	Database URL. Provide this or db_engine.
session_table	Optional[str]	None	Table for Agent, Team, and Workflow sessions. Uses "agno_sessions" when omitted.
memory_table	Optional[str]	None	Table for memories. Uses "agno_memories" when omitted.
metrics_table	Optional[str]	None	Table for metrics. Uses "agno_metrics" when omitted.
eval_table	Optional[str]	None	Table for evaluation run data. Uses "agno_eval_runs" when omitted.
knowledge_table	Optional[str]	None	Table for knowledge content. Uses "agno_knowledge" when omitted.
culture_table	Optional[str]	None	Table for cultural knowledge. Uses "agno_culture" when omitted.
traces_table	Optional[str]	None	Table for traces. Uses "agno_traces" when omitted.
spans_table	Optional[str]	None	Table for spans. Uses "agno_spans" when omitted.
versions_table	Optional[str]	None	Table for schema versions. Uses "agno_schema_versions" when omitted.
create_schema	bool	True	Create the database schema when it does not exist. Set to False when migrations manage it.

Methods

upsert_sessions

Bulk upsert multiple sessions for improved performance on large datasets.

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

Bulk upsert multiple memories for improved performance on large datasets.

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]]]