Supabase

This guide shows how to analyze the data in your Supabase Postgres database in Deepnote. We configure an integration that allows you to query the data and use them in an analysis or an automation workflow.

Supabase is an open source Firebase alternative. Start your project with a Postgres Database, Authentication, instant APIs, Realtime subscriptions and Storage.

Setup

Step 1: Create a Supabase project

Go to supabase.com and create a free account, and start a new project.

Step 2: Get your database credentials ready

You will need the connections details for the database: host, database, port, user and password. You can find them in the settings of your Supabase project, in the Database section.

Step 3: Create a Postgres integration in Deepnote

Open Integrations in the left side bar, and select the Postgres integration. You will be prompted for the credentials from the previous step.

Step 4: Create a new project, and start querying your data

When you create a new project, navigate to Integrations in the right side bar, and connect your database. This will allow you to:

Insert and execute SQL blocks in your notebook
Browse the schema

Use cases

Exploratory data analysis

You can ask analytical questions about your data and leverage the entire Python ecosystem. Visualize things like cumulative user count, or the popularity of various authentication providers. Create charts, forecasts or dashboards and organize them in your data workspace.