Supabase

Connect Erathos to Supabase.

You can connect the Erathos platform to any Supabase project, leveraging its built-in PostgreSQL database. To ensure a stable and scalable connection, Erathos requires the use of the Supabase Connection Pooler.

To connect to your Supabase instance, the following information is necessary: Host, Port, Database Name, User, and Password.

The tutorial below shows you how to obtain these credentials.

Supabase Setup

Connection Credentials

The easiest way to find your credentials is via the global connection dashboard.

1. Log into your Supabase Dashboard and select your project.

2. At the top center of the screen, click the Connect button. This will open a side panel containing all necessary integration details.

1. In the "Connect" panel, ensure you are looking at the Direct (Connection String) tab.

2. Ensure the Transaction pooler is selected as the Connection Method.

1. Scroll down to locate your host, port, database, and user.

• Host: Copy the pooled hostname (e.g., aws-0-us-east-1.pooler.supabase.com).

• Port: For pooled connections, this is typically 6543.

• User: Identify the database user (default is postgres.your-project-id).

• Database Name: Identify the database name (default is postgres).

The database password is the one you established during the initial project creation.

For security reasons, Supabase does not store or exhibit your password again. If you do not have it saved, you must go to Database > Settings to reset it. Confirm you have copied and pasted the new password somewhere safe before proceeding.

Connect to Erathos

To connect Erathos to your Supabase:

1. Create a New Destination

   • Go to Settings > Destination.

   • Select Supabase.

2. Fill Out the Form

   • Host: Paste the Connection Pooler Host copied from the Connect panel.

   • Port: Enter 6543 (ensure you are using the pooled port).

   • Database: Enter your database name.

   • User: Enter the database user.

   • Password: Enter your project's database password.

3. Complete the Setup

If you need help connecting to your Supabase project, reach out to our team at [email protected].