Skip to main content

​
Overview

SqliteStorage provides a file-based SQLite storage backend. Ideal for local development, single-node deployments, and testing.

​
Install

Install the SQLite storage optional dependency group:
uv pip install "upsonic[sqlite-storage]"

​
Basic Usage

from upsonic import Agent, Task
from upsonic.storage.memory import Memory
from upsonic.storage.sqlite import SqliteStorage

storage = SqliteStorage(db_file="memory.db")

memory = Memory(
    storage=storage,
    session_id="session_001",
    user_id="user_123",
    full_session_memory=True,
    summary_memory=True,
    user_analysis_memory=True,
    model="openai/gpt-4o"
)

agent = Agent("openai/gpt-4o", memory=memory)

result1 = agent.do(Task("My name is Alice"))
result2 = agent.do(Task("What's my name?"))
print(result2)  # "Your name is Alice"

​
Parameters

ParameterTypeDefaultDescription
db_filestr | NoneNonePath to SQLite file. If None, creates ./upsonic.db
db_engineEngine | NoneNonePre-configured SQLAlchemy Engine
db_urlstr | NoneNoneSQLAlchemy URL (e.g., sqlite:///./data.db)
session_tablestr | None"upsonic_sessions"Session table name
user_memory_tablestr | None"upsonic_user_memories"User memory table name
idstr | Noneauto-generatedStorage instance ID

​
Storage Type

SqliteStorage is a synchronous storage implementation. It uses SQLAlchemy with thread-safe scoped sessions.