Persistent Session with Database

This example demonstrates how to use persistent session storage with a PostgreSQL database to maintain team conversations across multiple runs.

Code

cookbook/examples/teams/session/01_persistent_session.py

from agno.agent.agent import Agent
from agno.db.postgres import PostgresDb
from agno.models.openai import OpenAIChat
from agno.team import Team

db_url = "postgresql+psycopg://ai:ai@localhost:5532/ai"

db = PostgresDb(db_url=db_url, session_table="sessions")

agent = Agent(model=OpenAIChat(id="gpt-5-mini"))

team = Team(
    model=OpenAIChat(id="gpt-5-mini"),
    members=[agent],
    db=db,
)

team.print_response("Tell me a new interesting fact about space")

Usage

1. Create a virtual environment

   Open the Terminal and create a python virtual environment.

   Mac

   python3 -m venv .venv
   source .venv/bin/activate
   
2. Install required libraries

   pip install agno psycopg2-binary
   
3. Set environment variables

   export OPENAI_API_KEY=****
   
4. Start PostgreSQL database

   cookbook/run_pgvector.sh
   
5. Run the agent

   python cookbook/examples/teams/session/01_persistent_session.py