How to Enable pgvector on Supabase

How to fix it

// try these in order, the most common fix is first

1. FIX 1Dashboard

   Copy steps
   1. 01Database > Extensions
   2. 02Search for vector and enable it
   Did this fix it? Yes No

2. FIX 2SQL

   Copy steps
   1. 01Run create extension vector with schema extensions;
   2. 02Create a column such as extensions.vector(384) matching your model
   Did this fix it? Yes No

3. FIX 3Filtering

   1. 01For filtered queries use iterative index scans as the docs suggest
   Did this fix it? Yes No

Symptoms

Unsure how to turn on vectors in a Supabase project.

Why it happens

• C-01Extension not enabled
• C-02Dimension mismatch with model

// this guide also covers

• enable pgvector supabase
• supabase vector extension
• supabase create extension vector

Other pgvector errors

• pgvector Error: extension "vector" is not available
• pgvector HNSW Index Build Slow
• pgvector "operator does not exist: vector <=>" Error
• pgvector Dimension Limit: Cannot Index More Than 2000 Dimensions
• pgvector "different vector dimensions" Error
• pgvector Query Returns Fewer Results Than LIMIT With Filter
• pgvector Index Not Being Used
• pgvector HNSW Build Out of Memory or Shared Memory Error