ContextQMD
Back to Agno

Database Integration

cookbook/06_storage/README.md

2.6.52.0 KB
Original Source

Database Integration

This directory contains examples demonstrating how to integrate various databases with Agno agents, teams, and workflows for persistent storage.

Setup

shell
# Install required database drivers based on your choice
uv pip install psycopg2-binary  # PostgreSQL
uv pip install pymongo         # MongoDB
uv pip install mysql-connector-python  # MySQL
uv pip install redis           # Redis
uv pip install google-cloud-firestore  # Firestore
uv pip install boto3           # DynamoDB
uv pip install singlestoredb   # SingleStore
uv pip install google-cloud-storage  # GCS

Navigate to the specific integration directory for detailed documentation and examples.

Basic Integration

python
from agno.agent import Agent
from agno.db.postgres import PostgresDb

db = PostgresDb(db_url="postgresql+psycopg://user:password@localhost:5432/dbname")

agent = Agent(
    db=db,
    add_history_to_context=True,
)

Supported Databases

  • postgres - PostgreSQL relational database integration
  • sqllite - SQLite lightweight database integration
  • mongo - MongoDB document database integration
  • mysql - MySQL relational database integration
  • redis - Redis in-memory data structure store integration
  • singlestore - SingleStore distributed SQL database integration
  • firestore - Google Cloud Firestore NoSQL database integration
  • dynamodb - AWS DynamoDB NoSQL database integration
  • json - JSON file-based storage integration
  • gcs - Google Cloud Storage JSON blob integration
  • in_memory - In-memory storage with optional persistence hooks

Session Management