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