Supabase

Configure Supabase as a data source for Zing Data

Supabase is an open-source Firebase alternative that provides a Postgres database, Authentication, instant APIs, Edge Functions, and more. It allows developers to build scalable backends quickly.

You can connect Zing to Supabase as a data source from the Zing web console.

You’ll need:

  • An active Supabase project
  • An active Zing Data account

Setup Steps

  1. Login to your Supabase project dashboard.

  2. In the top navigation bar, click on Connect.

  3. Under the “Connection String” section, select PSQL as the “Type”. Locate the Connection string for your database. You’ll typically find options for direct connection, session pooler, and transaction pooler. For general data visualization, the Session pooler connection string is often recommended.

  4. Copy and save this connection string somewhere safe. It will contain your host, port, database name and username.

  5. Login to the Zing web console, and click on the ‘data sources’ tab.

  6. Click ‘New Data Source’.

  7. Select ‘PostgreSQL’ as the data source.

  8. Enter the Host, Port, User, Password, and Database Name gathered from your Supabase connection string in step 4. Take note: Database Password is the password used on creation of the Project.

    Steps to Reset Database Password - head to Project Settings, under Database tab, select Reset database password in the Database password section.

     

  9. Tap ‘Check Connection’, and Zing will confirm that a connection can be established. A list of all tables in that database will then be shown.

  10. By default, all the tables in your database will be made visible, but you can optionally turn off certain tables from being displayed by turning the switch for an individual table off, then hitting ‘save’.

  11. The data source you just added will be available to everybody in your organization.

A step by step video is here: