Open source website builder and Webflow alternative. Webstudio is an advanced visual builder that connects to any headless CMS, supports all CSS properties, and can be hosted anywhere, including with us.
description: Use Supabase as a backend database for your Webstudio site.
How to build a frontend for Supabase using Webstudio
In Webstudio, a "Collection" is a powerful feature designed to manage and display dynamic content on web pages. Essentially, they serve as containers that can connect to various data sources, like databases or APIs, to fetch and present data in a structured and repeatable manner. This allows developers and designers to create instances, such as lists, galleries, or testimonial sections, where each item in the collection is automatically populated with data from the connected source. By using a collection, Webstudio users can efficiently create pages with content that updates in real-time, reflecting changes in the data source without manual intervention, thereby enhancing the site's interactivity and relevance.
{% embed url="https://www.youtube.com/watch?v=2MrkfnjYuCo" %}
Create dynamic content with Webstudio and Supabase
This guide creates pages with dynamic content by using Supabase as the data source.
Set up your Supabase project
- Sign up for a free Supabase account.
- Create a new project. (You'll need to set a strong password for your project to proceed).
- Once your project is initialized, navigate to the table editor to create a new table
- Define your fields (e.g., text fields for name, testimonial content, and an image URL field)
Upload images to Supabase Storage
- Go to Storage in your Supabase dashboard
- Create a new bucket and set it as public
- Upload your images
- Each image will have a URL you can copy and store in your table
Configure Row Level Security
- Navigate to your table → "No active RLS policies"
- Create a new policy
- Enable read access for everyone (anonymous users)
- Save the policy
Integrate Supabase with Webstudio
Get the API URL
- Go to Table Editor → select your table
- Click API (at the top right of the table view)
- Switch the example code to bash
- Copy the URL provided
Add the Resource variable
- In Webstudio, select your Collection's parent element
- Go to Settings → Add Variable → Type: Resource
- Paste the API URL
- Add a header:
- Name:
apikey - Value: Your publishable key from Project settings → API Keys
- Name:
{% hint style="warning" %}
Use only a Supabase publishable key (or the legacy anon key) in a website integration. Never use a secret or service_role key. Publishable keys identify the project but do not protect its data; configure Row Level Security policies and table grants for every operation the site permits. See Supabase API keys and Row Level Security.
{% endhint %}
Map data and finish the page
Map the data from Supabase to your Webstudio project. This involves setting up the data within your collection to inform Webstudio about the available data for use.
- Delete any automatically generated preview box within the collection.
- Drag in your pre-created and pre-styled components, which will be repeated for each fetched item from Supabase.
- For each component (e.g., paragraph, field, and image), bind the corresponding data from your Supabase collection.
- Use
.datato access the actual content (e.g.,resource.data) - When binding inside a Collection, use
collectionIteminstead of the resource name - Once everything is connected and data is properly mapped, your page will dynamically display the testimonials stored in Supabase.
Make sure to check the responsiveness and appearance on mobile devices before publishing.
Related
- CMS – Learn about dynamic pages and Resources in Webstudio
- Variables – Understand how to create Resource variables
- Collection – Display multiple records from Supabase
- Airtable Integration – Alternative database option for Webstudio
- n8n Integration – Automate workflows between Webstudio forms and Supabase