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.