pip install "praisonai[tools]"

docker run -d --name praison-postgres -p 5432:5432 \
    -e POSTGRES_PASSWORD=praison123 \
    -e POSTGRES_DB=praisonai \
    postgres:16

from praisonaiagents import Agent
from praisonai.db import PostgresDB

db = PostgresDB(
    host="localhost",
    port=5432,
    database="praisonai",
    user="postgres",
    password="praison123"
)

agent = Agent(
    name="Assistant",
    db=db,
    session_id="my-session"
)

agent.chat("Hello!")
db.close()

from praisonai.db import PraisonDB

db = PraisonDB(database_url="postgresql://user:password@host:port/database")

export PRAISON_CONVERSATION_URL="postgresql://postgres:praison123@localhost:5432/praisonai"

# Validate connection
praisonai persistence doctor \
    --conversation-url "postgresql://postgres:praison123@localhost/praisonai"

# Run with persistence
praisonai persistence run \
    --conversation-url "postgresql://postgres:praison123@localhost/praisonai" \
    --session-id "cli-session" \
    "Hello!"

# Check if PostgreSQL is running
docker ps | grep postgres

# Check logs
docker logs praison-postgres