Supabase

Agno supports using Supabase with the PostgresDb class.

You can get started with Supabase by following their Get Started guide.

You can read more about the PostgresDb class in its section.

Usage

Start in a virtual environment.

Install Agno, SQLAlchemy, the binary Psycopg driver, and the OpenAI client:

uv pip install agno sqlalchemy "psycopg[binary]" openai

Use your project's Connect dialog to copy a PostgreSQL connection string. Choose Direct connection when the Python host has IPv6 connectivity (or your project has the IPv4 add-on); choose the Session pooler for a persistent application on an IPv4-only host. See Connecting to Postgres.

Keep the URL's [YOUR-PASSWORD] placeholder and set the actual password separately. The code below encodes the password for the URL, including characters such as @ or /, and preserves the selected endpoint and query options.

export SUPABASE_DB_URL="paste_the_connection_string_from_Connect"
export SUPABASE_PASSWORD="your_database_password"

from agno.agent import Agent
from agno.db.postgres import PostgresDb
from os import environ
from sqlalchemy.engine import make_url

SUPABASE_DB_URL = make_url(environ["SUPABASE_DB_URL"]).set(
    drivername="postgresql+psycopg",
    password=environ["SUPABASE_PASSWORD"],
).render_as_string(hide_password=False)

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

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

Params