pgvector-setup

Instructions

This skill provides complete pgvector setup for Supabase databases, enabling vector search capabilities for AI applications, RAG systems, and semantic search.

Phase 1: Enable pgvector Extension

1. Run the setup script to enable pgvector:

   bash scripts/setup-pgvector.sh [SUPABASE_DB_URL]
   

   This creates the pgvector extension and sets up basic embedding tables.

2. Choose your embedding dimensions based on your model:

   • OpenAI text-embedding-3-small: 1536 dimensions
   • OpenAI text-embedding-3-large: 3072 dimensions
   • Cohere embed-english-v3.0: 1024 dimensions
   • Custom models: Check model documentation