Supabase

Use the Supabase connector to import data from a Supabase project into an Algolia index. After selecting a table or view, the connector synchronizes your index with updates.

Before you begin

You need:

• Supabase database credentials.
• A secured Algolia API key.

Select a Supabase data source

1. In the Algolia dashboard, select the Supabase connector and click Connect.

2. Enter your Supabase credentials:

   • Host
   • Transaction pooler port
   • Session pooler port
   • Database name
   • Username
   • Password
3. Give your Supabase source a name.
4. Click Create source.
5. After the connection is verified, choose a destination index and set up a synchronization task.

Select an Algolia destination index

Your Supabase data will be stored in an Algolia destination index.

1. Select an existing index or create a new one.
2. Provide the secured Algolia API key for that index.
3. Name the destination for easy identification.
4. Click Create destination.

Create a synchronization task

Tasks define how and when Algolia fetches data from your Supabase source.

1. Choose how to trigger the sync:
   • On demand: run the task from the Algolia dashboard or API.
   • Scheduled: choose a predefined schedule or enter a cron expression.
2. Choose how you want to update your Algolia index:
   • Full reindexing: replaces all records in the index.
   • Full record updates: replaces matching records based on the primary database key.
   • Partial record updates: updates specified attributes in matching records.
3. Choose the table or view to import and select which columns to include.
4. Choose a primary key from your Supabase table or view to use as the Algolia objectID.
5. Click Create task.

Create a separate task for each table or view. Avoid combining multiple sources in a single task: this merges data into one index and can lead to conflicts.

See also

• Transform your data with code