Search documentation

Search for a topic, a control, or an event type.

    Docs / Workflows / Integrations / Supabase

    Supabase

    Read and write Supabase tables, execute SQL and work with storage buckets.

    What you can do

    Each Supabase integration’s page in OAIZ shows these uses, with its events and its read and write actions, under What you can do with Supabase.

    New rows
    Insert a row for each new order.
    Reacting to rows
    Act on new rows, such as welcoming a new customer.
    Answers from your data
    Answer questions with data from your tables.

    Connection scope

    A connection can contain multiple configured Supabase projects. projectRef selects the project. Row actions use its configured default PostgREST schema. Execute SQL accesses the project’s PostgreSQL database.

    Connecting

    Authorize OAIZ through Supabase and approve access to the projects the connection will use. OAIZ discovers the projects accessible to the authorization and creates a secret API key in each connected project for table and storage tools.

    The authorization needs access to discover projects, create project secret keys, run database queries and configure webhooks. It also reads organization and member information.

    The project secret keys use the service_role database role and bypass row-level security policies. Execute SQL uses the Supabase Management API’s privileged database access. Give this connection only to workflows that should have that level of access.

    Read actions

    Query Table
    Read one page of table rows with filters and sorting. Filters are combined with AND.
    Get Tables
    List tables in one or all connected projects, with schemas, primary keys and column counts.
    Get Schema
    Read column types, defaults, primary keys, unique constraints and foreign keys for a project’s tables.
    Download File
    Download a file from a Supabase storage bucket.
    List Files
    List files in a Supabase storage bucket with optional filtering and pagination.
    Create Signed URL
    Return a temporary access URL for a private storage file. The file itself is unchanged.
    Get Buckets
    List a project’s storage buckets.

    Write actions

    Insert Row
    Insert a row into a Supabase table.
    Update Row
    Update existing rows in a Supabase table based on filter conditions.
    Delete Row
    Delete every row matching the required filters.
    Upsert Row
    Insert a row or update its conflicting existing row.
    Execute SQL
    Run SQL against a project’s Postgres database, including reads, writes and table or index changes. This tool is classified as a write tool because it can change data and structure.
    Upload File
    Upload a file to a Supabase storage bucket.
    Delete File
    Delete one or more files from a Supabase storage bucket.

    Events

    Configured table webhooks publish row-inserted, row-updated and row-deleted events. Their table and row data describe the change. These are Supabase events from the connected project.