Supabase Database

Connect to Supabase PostgreSQL databases.

Configuration

Field	Required	Description
secret_name	Yes	Reference to project secret containing connection string

Setup Methods

OAuth (Recommended)

1. Click Connect with Supabase
2. Authenticate with your Supabase account
3. Select your project from the list
4. Connection details are automatically imported

Manual Setup

1. Get your connection string from Supabase dashboard
2. Store it as a project secret
3. Select the secret in the catalog configuration

Connection String Format

postgresql://postgres:[password]@db.[ref].supabase.co:5432/postgres

Find your connection string in Supabase Dashboard > Project Settings > Database > Connection string.

Example

import daft

def analyze_users(db: daft.Catalog):
    """Query data from Supabase PostgreSQL."""
    users = db.load_table("users")
    active = users.where(daft.col("status") == "active")
    return active.to_pydict()

Available Operations

Once connected, you can:

• Load tables: catalog.load_table("table_name")
• List tables: Browse available tables in your database
• Query data: Use Daft DataFrame operations on loaded tables