Agent Storage

Agents can persist every data point they generate and use in a database, set by the db param. We can store sessions, memory, knowledge, traces, schedules, approvals, learnings and even usage metrics. The primitives (agents, teams, workflows) and the AgentOS accept a db param. Pick from JSON files (local or cloud), embedded (SQLite), relational (Postgres, MySQL), document (MongoDB), key-value (Redis, DynamoDB, Firestore), or distributed (SingleStore).

from agno.db.postgres import PostgresDb
from agno.os import AgentOS

db = PostgresDb(db_url="postgresql://user:pass@host:5432/agno")

agent_os = AgentOS(agents=[agent], db=db)

When we set the db param, AgentOS creates the tables and indexes on first boot.

What gets stored

Table	Holds
`agno_sessions`	Conversation history per `(user_id, session_id)`
`agno_memories`	User memories the agent decides to keep
`agno_knowledge`	Embeddings
`agno_traces`, `agno_spans`	OpenTelemetry traces
`agno_approvals`	Pending and resolved HITL requests
`agno_schedules`, `agno_schedule_runs`	Cron jobs
`agno_metrics`, `agno_eval_runs`	Metrics and eval results

Backend-specific names may vary.
Schema changes are generally additive.

Pick a backend

PostgresDb is the default for most tutorials and the recommended production database. It pairs well with PgVector to keep relational data and embeddings on the same engine.

Backend	When to use
`PostgresDb`	Production. Vector + relational on one box.
`SqliteDb`	Local dev, single-user demos, edge deployments
`MongoDb`	Already on Mongo
`MySQLDb`	Already on MySQL
`SingleStoreDb`	Vector + analytics on one engine, high-throughput
`RedisDb`	Cache-friendly, ephemeral sessions
`DynamoDb`	AWS-native, serverless
`FirestoreDb`	GCP-native, serverless
`GCSJsonDb`	Cheap cold storage, knowledge as JSON in Cloud Storage
`InMemoryDb`	Tests, ephemeral demos

Postgres-compatible managed services like Neon and Supabase work with PostgresDb directly. Point db_url at the managed instance. Async variants (AsyncPostgresDb, AsyncSqliteDb, AsyncMongoDb, AsyncMySQLDb) are documented under Database.

Vector storage

Knowledge needs a vector store and agno supports every vector database out of the box.

from agno.knowledge import Knowledge
from agno.vectordb.pgvector import PgVector

agent = Agent(
    db=db,
    knowledge=Knowledge(
        vector_db=PgVector(
            table_name="my_kb",
            db_url=DB_URL,
            search_type="hybrid",   # vector + BM25
        ),
    ),
)

Other options: LanceDB, Qdrant, Weaviate, Pinecone, Chroma, MongoDB Atlas, Cosmos, Cassandra, ClickHouse, SurrealDB, Milvus. See Vector Stores. For most production AgentOS deployments, PgVector + PostgresDb on the same Postgres is the right default. One database, hybrid search, transactional reads, no extra service to operate.

Splitting concerns across databases

Every agent, team, and workflow can take its own db, overriding the AgentOS default. Use the AgentOS db for shared state and hand individual components a separate database when they need isolation:

shared_db = PostgresDb(db_url="postgresql://shared/...")
tenant_db = PostgresDb(db_url="postgresql://tenant-a/...")

tenant_agent = Agent(name="tenant-a-support", db=tenant_db, ...)
internal_agent = Agent(name="ops", db=shared_db, ...)

agent_os = AgentOS(
    agents=[tenant_agent, internal_agent],
    db=shared_db,
)

Common splits: per-tenant DBs for strict isolation, a high-traffic agent on its own engine, or routing one workflow’s session history to a cheaper backend.

File and blob storage

For media that doesn’t belong in the relational store (generated images, audio, large PDFs), store them in object storage and reference paths in agno_knowledge or agno_sessions.

Welcome

Get Started

Features

Use Cases

Agent Storage

What gets stored

Pick a backend

Vector storage

Splitting concerns across databases

File and blob storage

​What gets stored

​Pick a backend

​Vector storage

​Splitting concerns across databases

​File and blob storage

What gets stored

Pick a backend

Vector storage

Splitting concerns across databases

File and blob storage