Hi there,
Using the Supabase Pro plugin, is there a way to insert/update/upsert a Supabase table via a backend workflow? Ie, I have a scheduled API that collects new information every half an hour, and it needs to write to the Supabase DB.
Thanks.
Hi Phil,
Yes, this is possible. In this case, you can use the Supabase Pro Kit server-side actions inside a Bubble backend workflow to write data to your Supabase database.
For example, you can use the plugin’s Run SQL query action to perform an INSERT, UPDATE, or PostgreSQL upsert using INSERT … ON CONFLICT … DO UPDATE.
You can check the documentation here:
Supabase Pro Kit docs: Supabase Pro Kit
Server-side actions: ⚡️ Server-Side Actions
We also have a backend workflow example on our demo page that you can review here:
supabase-editor | Bubble Editor
So for your scheduled API workflow that runs every half hour, you can add the Supabase Pro Kit server-side action there and use it to write/update records in your Supabase DB.
Best regards,
Egor Smorodinov,
Support Team
Browse all Zeroqode Plugins for bubble
Hi Phil / @phil1,
I just wanted to follow up on this.
As mentioned earlier, yes — you can write to your Supabase database from a Bubble backend workflow using the Supabase Pro Kit server-side actions.
For your scheduled API workflow that runs every half hour, you can add the plugin’s server-side action there and use it to insert/update records in your Supabase table. For an upsert specifically, you can use the Run SQL query action with a PostgreSQL query such as INSERT … ON CONFLICT … DO UPDATE.
Please also make sure that the field used for conflict handling, usually a primary key or unique column, is included in the data you are sending. This is required so Supabase can determine whether to insert a new row or update an existing one.
If you’ve already tested this and are running into any issue, please share the workflow setup, the query/action configuration, and any error message you’re getting, and we’ll take a closer look.
Best regards,
Egor Smorodinov,
Support Team
Browse all Zeroqode Plugins for bubble