Back to Tools
Vector databaseOpen sourceUpdated 2026

pgvector

Beginner to intermediate · Database extension

PostgreSQL extension for storing embeddings and running vector similarity search.

Best for

Teams that already use Postgres and want a simple RAG database path.

Why use it

Avoids adding a dedicated vector database when Postgres is already part of the stack.

Tradeoffs

Dedicated vector databases may offer better specialized retrieval features at scale.

Key features

  • Vector search in Postgres
  • SQL workflow
  • RAG-friendly extension

Alternatives

Qdrant, Chroma, Weaviate

Where it fits

pgvector belongs in the vector database layer of an open AI stack. Evaluate it against your model runtime, privacy needs, deployment target, and the amount of operational complexity your team can support.

CategoryVector databaseLicensePostgreSQL LicenseDeploymentDatabase extensionModePostgres extension
pgvector GitHub →

Recommendation

Use pgvector when Postgres simplicity beats specialized vector infrastructure.