Connect Supabase
Last updated
Last updated
Supabase is an open-source alternative to Firebase, providing a complete backend solution for building and scaling applications. It offers features like real-time databases, authentication, and storage, all powered by PostgreSQL. Supabase simplifies the process of setting up a robust backend, allowing developers to focus on building great applications without worrying about the infrastructure.
Airbook integrates seamlessly with Supabase, enabling you to leverage your Supabase data for collaborative analytics and insights. Here’s how you can use Supabase on Airbook:
Connect Easily: Use Airbook's PostgreSQL connector to link your Supabase instance with just a few clicks. All you need are your Supabase credentials (host, database name, port, user, and password).
Real-Time Data Sync: Once connected, Airbook syncs your Supabase data in real-time, ensuring that your analyses are always based on the most current information.
Collaborative Querying: On Airbook, you can collaboratively query your Supabase data. This means multiple team members can work together on creating queries, building models, and sharing insights.
Advanced Analytics: Utilize Airbook's powerful querying capabilities to join multiple tables from your Supabase instance. You can write SQL queries or use Airbook’s no-code tools to generate complex analytics.
Visualizations and Reports: Create charts, graphs, and reports directly from your Supabase data. Airbook makes it easy to visualize your data, making insights more accessible and actionable.
When you first log into Airbook, you'll land on the home page. Look for the "Make a Connection" action and click on it.
This will take you to a page where you can connect to various databases and business applications.
Since Supabase uses a PostgreSQL database, we'll use the PostgreSQL connector available here.
Click on the PostgreSQL connection option. You'll be prompted to fill in several fields with your Supabase credentials. Here's a list of what you'll need:
Host
Port
Database Name
Username
Password
To find these credentials, log into your Supabase account and select your project.
Navigate to the database configuration section, where you'll see all the necessary details.
Here’s where you can find each piece of information:
Host: Located in the database configuration details.
Database Name: Also found in the same section.
Port: Provided alongside the host information.
User: Your Supabase database username.
Password: The password for your database user.
Now, switch back to Airbook and enter the retrieved details into the respective fields. Here’s an example of how to do it:
Give the connection a name
Fill in the Host and Port using the details from Supabase.
Enter the Database Name.
Input the Username & Password for your Supabase instance.
After entering all the required details, click on the "Submit" button. Airbook will start processing and establishing a connection to your Supabase instance.
Once the connection is successful, Airbook will begin syncing your data. This may take a few minutes. You'll be notified once the syncing process is complete.
After syncing is finished, you can continue to Airbook where you'll find all your Supabase tables listed on the right-hand side. Here's how to start querying your data:
Open the tray to view all your Supabase tables.
Select the table you want to query.
Click on "Query," and hit "Run."
Airbook allows you to join multiple tables from your Supabase instance using SQL join queries. Additionally, you can create charts and other visualizations to gain deeper insights into your data.
And that's it! You've successfully connected your Supabase instance to Airbook and can now collaboratively query and analyze your data.
