How to build Dashboards from Supabase data

Building Dashboards from Supabase data, which is an open-source Firebase alternative. Draxlr lets you visualise your Supabase data and helps you make better business decisions.

Posted by Vivek on 2023-09-07
How to build Dashboards from Supabase data

Supabase is an open-source Firebase alternative that lets you create Postgres databases with the option to perform CRUD operations on the database.

Supabase also provides these features:

  • APIs to access your data and perform queries.
  • Authentication: Give access to your data to users with row-level permission.
  • Write custom code that can be scaled.
  • Store images or videos.
  • Integrate with machine learning platforms.

Using Draxlr to build Dashboards from Supabase data

Draxlr is a no-code BI tool that helps you build dashboards, get data alerts, and embed dashboards on customer-facing sites.

Draxlr is a technology partner with Supabase to allow Supabase users to build dashboards and get data alerts.

Here is a quick video walkthrough of how to build a dashboard from Supabase data in Draxlr:

How to build Dashboards from Supabase data

Ok, let's get started.

Connecting Supabase with Draxlr

In Supabase, you can have multiple organisations, and each organisation can have multiple projects. Each project has a Postgres Database. You can connect to a Supabase project database to generate insights into your data.

  1. Login into Draxlr, visit the Add Database page, and select Supabase. Draxlr Select Supabase
  2. Click on Connect Supabase and select the organisation that hosts your database. Draxlr Select Supabase Organization
  3. Select the project from the list of projects for the organisation. Draxlr Select Supabase Project
  4. Draxlr will fetch the database credentials from Supabase except the database password; you can enter the password manually and click Next. Draxlr Set Supabase Password
  5. You can now select the database schema; by default, it is public. Draxlr Set Supabase Schema
  6. Now you can see the list of tables, and you can start exploring your data. Draxlr List Tables

Generating Queries and Visualizing the data

After connecting Supabase with Draxlr, you can build Dashboards from your Supabase data.

  1. You can use Draxlr's no-code query builder to generate data using Filters, Joins, Sort, Summarize, and Group by options.
  2. Once you have the desired data result, you can visualise it using multiple graph options like bar, pie, line, area, and more. Draxlr Supabase Graph Options
  3. After you have completed the Graph setup, you can save the query and also add it to a Dashboard. Draxlr Supabase Add to Dashboard
  4. And that's it; your dashboard is ready! Draxlr Supabase - Dashboard View
  5. You can share the dashboard with your team and embed the dashboard in your customer-facing application.

With Dashboards built from your data, you can make better business decisions. You can also set data alerts to get notified via Email or Slack when your data changes.

- Vivek

Let’s get you started

This website uses cookies to ensure you get the best experience.