Today, Algolia is launching a new Supabase Connector, making it easier than ever to index your Postgres data and power world-class search experiences without writing a single line of code.
With just a few clicks, you can connect your Supabase database to Algolia, select the tables you want to sync, and configure how often the data updates. Algolia handles the rest. You get a fast, reliable, scalable search index, and your team gets to focus on building.
Supabase is more than a backend. It is a growing ecosystem of tools that work well together so developers can build faster, scale more easily, and stay focused on their product.
Partners like Algolia bring best-in-class functionality (in Algolia’s case, fast and flexible search) directly into the Supabase workflow. For developers, that means fewer workarounds, no glue code, and a smoother path from idea to production.
For partners, integrating with Supabase means more than technical compatibility. It means product visibility to tens of thousands of active projects. Supabase regularly features integrations in our docs, Launch Weeks, blog, and community programs. Developers discover and adopt your product in the context where they’re already building.
Read on to see how the Algolia Connector for Supabase works.
To get started with Algolia’s connector, prepare the data in your Supabase database, create Supabase as a source in Algolia’s dashboard, set up your Algolia index and configure your sync job. Here’s how you can get started in just a few minutes.
1. Prepare your data in Supabase#
Before you connect to Algolia, you will want to ensure all the fields you want to make searchable are in one place. If the fields you want to index live in more than one table, you can stitch them together in a Postgres View, allowing Algolia’s connector to get all the data you want to index.
For example, imagine you’re creating an app that allows you to easily find a movie to watch. You want to search across movie titles, genres, rating and actors. However, movies and actors are in two separate tables. You can create a view (e.g., movies_view) that combines the columns you need:
_12
create view movies_view as
_12
select
_12
m.id as objectID, -- Algolia’s unique key
_12
m.title,
_12
array_agg(distinct c.actor_name) as actor_name,
_12
m.genre,
_12
m.rating,
_12
m.vote_count
_12
from
_12
movies as m
_12
left join movie_cast as c on c.movie_id = m.id
_12
group by m.id, m.title, m.rating, m.vote_count;
Later in the Algolia dashboard, you will be able to pick exactly which columns you want to index.
2. Go to Algolia dashboard#
- In Algolia, go to Data Sources → Connectors
- Find "Supabase" in the list and click Connect
3. Configure your data source#
First, you will need to fill in your Supabase connection info. From the Supabase dashboard:
- Click the Connect button found in the top of our header
- Scroll down to Connection Info → Transaction Pooler and copy host, port, database name, and username
- Paste the database credentials into the Algolia setup screen
- Enter your Supabase database password
- Select your schema (usually
public) - Give your source a name like
supabase_movies - Algolia will check the connection and confirm your credentials
4. Configure your destination#
Once you create Supabase as a data source, you'll need to tell Algolia where to index your data.
- Select an existing or create a new Algolia index (e.g.
supabase_movies_index) - Add Index Credentials to this destination by clicking Create one for me
- Click Create destination
5. Configure your task and run your sync job#
- Choose how often you want it to sync your data (e.g. every 6 hours)
- Pick whether to do full syncs or partial updates
- Select the table or view you want to index. We recommend selecting only one table or view for each index
- Choose your objectID (usually your primary key)
Once configured, create the task. Algolia will start syncing records from Supabase into your search index (in the YouTube demo above, 8,800+ movie records were synced in under a minute).
You can now instantly search your Supabase data using Algolia's lightning-fast API.
With the Algolia + Supabase connector, you don’t need to build or maintain custom data pipelines. With Algolia, you don’t need to worry about scaling your own search infrastructure. With Algolia’s API clients, you just connect and go.