Agno supports using Supabase with the PostgresDb class. You can get started with Supabase following their Get Started guide. You can read more about the PostgresDb class in its section.

Usage

supabase_for_agent.py
from agno.agent import Agent
from agno.db.postgres import PostgresDb
from os import getenv

# Get your Supabase project and password
SUPABASE_PROJECT = getenv("SUPABASE_PROJECT")
SUPABASE_PASSWORD = getenv("SUPABASE_PASSWORD")

SUPABASE_DB_URL = (
    f"postgresql://postgres:{SUPABASE_PASSWORD}@db.{SUPABASE_PROJECT}:5432/postgres"
)

# Setup the Supabase database
db = PostgresDb(db_url=SUPABASE_DB_URL)

# Setup your Agent with the Database
agent = Agent(db=db)

Params

ParameterTypeDefaultDescription
db_urlOptional[str]-The database URL to connect to.
db_engineOptional[Engine]-The SQLAlchemy database engine to use.
db_schemaOptional[str]-The database schema to use.
session_tableOptional[str]-Name of the table to store Agent, Team and Workflow sessions.
memory_tableOptional[str]-Name of the table to store memories.
metrics_tableOptional[str]-Name of the table to store metrics.
eval_tableOptional[str]-Name of the table to store evaluation runs data.
knowledge_tableOptional[str]-Name of the table to store knowledge content.

Developer Resources