pgvector

Vector stores

pgvector is an open-source extension for Postgres that adds a vector column type and distance operators, so embeddings live in ordinary tables and are queried with SQL. The README gives install routes for Linux, macOS and Windows builds, Docker images, APT, Homebrew and other package managers, and says the extension is available on several hosted Postgres providers. A table of languages links client libraries for dozens of languages, including Python and JavaScript or TypeScript.

Pinout

  • MCP server: not checked yet
  • HTTP API: not checked yet
  • command line: not checked yet
  • Python SDK: supported, verified
  • TypeScript SDK: supported, verified
  • OpenAPI description: not checked yet
Where each pin comes from
InterfaceStatusSource we readRead on
MCP serverNot checked yet——
HTTP APINot checked yet——
Command lineNot checked yet——
Python SDKSupported, verifiedREADME, Languages table, Python row
TypeScript SDKSupported, verifiedREADME, Languages table, JavaScript/TypeScript row
OpenAPI descriptionNot checked yet——

Facts

Facts about pgvector
License fileLICENSE begins with 'Portions Copyright (c) 1996-2026, PostgreSQL Global Development Group' and 'Portions Copyright (c) 1994, The Regents of the University of California'. GitHub repository, LICENSE file, read .
Install from sourcegit clone --branch v0.8.7 https://github.com/pgvector/pgvector.git, then make install. README, installation, read .
Docker imagedocker pull pgvector/pgvector:pg18-trixie; tags cover Postgres 13 through 18. README, installation, read .
Package managersAPT (postgresql-18-pgvector), Homebrew (brew install pgvector), plus PGXN, Yum/dnf, apk, conda-forge. README, installation, read .
Hosted PostgresREADME says pgvector is available on hosted providers listed in an issue. README, installation, read .
Client languagesREADME table links libraries for 35 language rows, including Python, JavaScript/TypeScript, Go, Java, Rust, Ruby. README, Languages, read .
Enable the extensionCREATE EXTENSION vector;. README, getting started, read .
Last commit. GitHub API, latest commit on the default branch of pgvector/pgvector, read .

Call example

SELECT * FROM items ORDER BY embedding <-> '[3,1,2]' LIMIT 5;

Strengths

  • Vectors are queried with plain SQL inside Postgres.
  • Install routes cover source builds, Docker, APT and Homebrew.

Alternatives to pgvector

All vector stores tools for agents
  1. Embedded vector database library with Python, TypeScript and Rust SDKs.

    Vector stores
  2. Open-source vector database with Lite, Standalone and Kubernetes deployments.

    Vector stores
  3. Rust vector database with REST, gRPC, SDKs and an MCP server.

    Vector stores
  4. Open-source vector database with hybrid search, SDKs and a built-in MCP server.

    Vector stores

Last check: . Method: public repository and docs read automatically, page and day written down. Next check due within 90 days. How we check

Is this your tool? Write to hello@agent-tools.directory from an address on its domain to correct a pin or a fact.