Chat History Retrieval

This example demonstrates how to retrieve and display chat history from team sessions for conversation tracking and analysis.

Code

cookbook/examples/teams/session/05_chat_history.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")
print(team.get_chat_history())

team.print_response("Tell me a new interesting fact about oceans")
print(team.get_chat_history())

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/05_chat_history.py