Create dashboards for Supabase

Hey hey, Tom here. I'm going to show you how to set up a dashboard inside of Basedash for Supabase, which is one of our favorite products. We use it for all of our demo data here at Basedash.

I'll walk you through:

• Connecting Supabase to Basedash

• Setting up a dashboard to track KPIs and adoption stats

• Creating a dashboard to inspect a specific user within your application

Step 1: Connecting the Database

I’ve already got the Supabase database hooked up.

You’ll see an indicator showing it’s connected.

We’re using a schema called Doc Hunt, which is pretty basic:

• users

• docs

• apps

This app lets you share items in your doc—like a micro social media site we built.

Step 2: Create a KPI Dashboard

Click New Dashboard, and name it KPIs.

Now let’s add some charts:

Key Metrics

• User signups over time

• Total number of users

• Number of apps added

This gives us a good snapshot:

• Who’s signing up

• How many users we have

• What’s being added to the platform

Step 3: Ranking Metrics

Let’s go further by ranking data.

• “Show me the top apps by number of times they appear in a doc.”

• “Show me the top users by number of followers.”

This gives us a nice leaderboard:

• Google Chrome is the most added app, followed by Visual Studio Code.

• We can also see top users by app usage or popularity.

Step 4: Dashboard Customization

You can rearrange the dashboard components however you like:

• Make primary metrics smaller

• Move charts around

• Change chart types (e.g., line chart → time bar)

Basedash also adds variables at the top of the dashboard so you can:

• Change date ranges

• Choose how data is grouped (e.g., daily, weekly)

You can also:

• Expand charts full screen

• View full chat history

• Roll back to previous versions

• Edit queries directly in the SQL editor

The schema browser on the side helps you explore and copy values into your queries.

Step 5: App Details Dashboard

Let’s build another dashboard called App Details.

This dashboard will let us inspect specific apps:

“Show me the details of an app.”

Basedash interprets this and looks for:

• A table that matches your request

• A variable that can drive a selector (dropdown) for the app

It picked one (alphabetically), but I’ll set the default to Basedash.

Step 6: App Profile View

Now let’s add more details:

• “Show me the icon of the app.”

• “Show me the people who have this app in their doc.”

• “Show me the count of times this app has been docked.”

This creates a profile view of the app:

• Icon at the top

• Docked user list (e.g., you’ll see me there)

• Total count as a top-line KPI

You can also switch apps (e.g., select Figma) and see:

• Figma has been docked 98 times

• The list of people using it

Step 7: Bringing in Additional Data

One of the best parts of Basedash is you can bring in any connected data.

Right now, we’re just using Supabase—but you could also connect:

• Stripe (to show invoices, sales over time)

• Sentry (to show errors over time)

• Google Analytics

• Google Ads

• LinkedIn Ads

• Event tracking tools like PostHog

• Email marketing tools like ActiveCampaign

There are over 600+ data sources you can connect in Basedash.

Just go to Data Sources > Add Source and choose what you need.

Final Thoughts

Using natural language, you can build powerful dashboards from multiple services—all within Basedash.

I’m excited to see what you build. Let us know if you have any questions.

That’s all for today. See you!