Choosing a Client

As described in Structured & Unstructured Embeddings, AI workloads come in many forms.

For data science or ephemeral workloads, the Supabase Vecs client gets you started. You need a connection string and vecs handles setting up your database to store and query vectors with associated metadata.

For production python applications with version controlled migrations, we recommend adding first class vector support to your toolchain by registering the vector type with your ORM. pgvector provides bindings for the most commonly used SQL drivers/libraries including Django, SQLAlchemy, SQLModel, psycopg, asyncpg and Peewee.