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
| Interface | Status | Source we read | Read on |
|---|---|---|---|
| MCP server | Not checked yet | — | — |
| HTTP API | Not checked yet | — | — |
| Command line | Not checked yet | — | — |
| Python SDK | Supported, verified | README, Languages table, Python row | |
| TypeScript SDK | Supported, verified | README, Languages table, JavaScript/TypeScript row | |
| OpenAPI description | Not checked yet | — | — |
Facts
| License file | LICENSE 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 source | git clone --branch v0.8.7 https://github.com/pgvector/pgvector.git, then make install. README, installation, read . |
| Docker image | docker pull pgvector/pgvector:pg18-trixie; tags cover Postgres 13 through 18. README, installation, read . |
| Package managers | APT (postgresql-18-pgvector), Homebrew (brew install pgvector), plus PGXN, Yum/dnf, apk, conda-forge. README, installation, read . |
| Hosted Postgres | README says pgvector is available on hosted providers listed in an issue. README, installation, read . |
| Client languages | README table links libraries for 35 language rows, including Python, JavaScript/TypeScript, Go, Java, Rust, Ruby. README, Languages, read . |
| Enable the extension | CREATE 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
Embedded vector database library with Python, TypeScript and Rust SDKs.
Open-source vector database with Lite, Standalone and Kubernetes deployments.

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

Open-source vector database with hybrid search, SDKs and a built-in MCP server.
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.