Skip to main content
All CollectionsIntegrations
Supabase Integration
Supabase Integration
Patrick avatar
Written by Patrick
Updated this week

Supabase is a powerful scalable database platform that can be used to power your Frontly apps!

Steps to integrate Supabase with Frontly

Frontly requires 4 values from Supabase to be integrated correctly:

Project ID, Public Key, Host, and Database Password

For each of these values, follow the steps below and paste it into the Public Key field in the Frontly Data Source Account Connections settings.

Public Key

Go to your Supabase Dashboard, go to Project Settings => API and copy the anon public key (a large string of random characters) and

Project ID

In Supabase, go to Project Settings => General and find the Reference ID.

Host & Password

  1. In Supabase, go to Project Settings => Database, and find the Connection parameters section. Within this section, you find your Host value.
    ​

  2. The Password will not be shown, but it was a password that you would have created for the database when you created the project. If you don't know this password and you're not using Supabase for other services that would be impacted by changing the password, there is an option to Reset Database Password. Be careful, and do this at your own risk.

Other Notes

  1. Ensure your primary key is a field called 'id' in your Supabase table.
    ​

  2. In Supabase, in each table you want to use with Frontly, find the Enable Row Level Security setting and disable it. This feature only works when using Supabase's auth system, which we are not. If you don't do this, no records will appear.

  3. Unlike Google Sheets, Supabase supports pagination, meaning results coming from the database in limited pages of results. We default to 25 results per page, but you can adjust this setting with the Results Per Page setting in your Table or Grid setup.

  4. Hidden Filters operate as usual, but are currently limited to Equals, Contains, Greater Than, Less Than operators.

Connecting Supabase Tables To Frontly

In Frontly, on the Data Sources page (previously named the Google Sheets page), click the Add Supabase Table button, and type the name of your table (case-sensitive).

Your table name will look like this:
​

Press the Import Table button - if everything is setup correctly, you should see that your table is imported and becomes available for use, just like a regular Google Sheet within Frontly.

Did this answer your question?