Supabase
Read and write Supabase database records from your workflows.
Overview
The Softr Supabase integration lets your app create, find, update, and delete records in your Supabase database as part of a workflow. Trigger a new row from a form submission, update records when a status changes, or look up existing data to display or use in the next step — all driven by what your users do in Softr.
Whether you're building a customer portal, an internal admin tool, or a member dashboard, Supabase becomes the backend your Softr app writes to and reads from, so your existing database stays the single source of truth while Softr handles the front end and the automations. Supabase connects to your workflows through Softr's SQL / Database action, using your project's PostgreSQL credentials.
Available actions
- Find recordLook up the first record that matches your conditions — perfect for fetching a customer, order, or profile to display in your app or use in a later step.
- Find multiple recordsReturn every record that meets your criteria, so you can power a live list, dashboard, or digest from your Supabase data.
- Add recordCreate a new record whenever a workflow runs — turn a form submission or sign-up into a row in your database instantly.
- Update recordChange a single record automatically as things happen in your app, such as updating a status or contact detail.
- Update multiple recordsUpdate many records at once — ideal for bulk status changes or applying the same update across a set of rows.
- Delete recordRemove a single record that's no longer needed as work is cancelled or cleaned up.
- Delete multiple recordsClear out a batch of records at once to keep your database tidy.
Example use cases
- Form-to-database intakeA Softr form submission adds a new record to your Supabase table with all the submitted details.
- User provisioning on sign-upWhen a new member signs up, create their record in Supabase so their data is ready across your app.
- Status syncWhen a record moves to "In progress" in your Softr app, update the matching Supabase row automatically.
- Live data dashboardUse Find multiple records to power a Softr list block that always reflects your latest Supabase data.
- Bulk updatesUpdate multiple records at once — for example, mark a batch of orders as shipped from an admin action.
- Automated cleanupDelete records that are cancelled or expired to keep your database tidy without manual work.
Key benefits
- No-code database access: Read from and write to your Supabase database visually inside Softr — no SQL or backend code required.
- Your data stays the source of truth: Keep your existing Supabase backend and let Softr handle the front end and automations on top of it.
- Always-current pickers: Databases, schemas, tables, and fields load live from your connected project, so your options stay up to date.
- Real-time two-way sync: New submissions become rows the moment they arrive, and record changes flow back into your app instantly.
- Custom queries when you need them: Drop in a custom SQL query for anything the standard actions don't cover.
