How to enable pgvector in Supabase

pgvector is an extension for PostgreSQL using which we can store and query vector data in the database.

It supports indexing and querying via the most popular methods and supports any Postgres client as well.

To use vector (embedding) in your database, you'll need to enable it first.

Enable pgvector via SQL

You can run this SQL statement to enable it for your database.

create extension vector;

Alternatively, you can enable it via the dashboard as well.

Head over to your Supabase dashboard → Database → Extensions

And enable the Vector extension.

Happy vector data!