# pgvector

> Source: https://agentsindex.ai/pgvector

Open-source Postgres extension that stores vectors beside relational data and runs similarity search in SQL.

pgvector is an open-source PostgreSQL extension that adds vector column types and exact or approximate nearest neighbor search with HNSW and IVFFlat indexes. Embeddings live in the same database as the rest of an application's data and are queried with ordinary SQL.

- Best for: Developers who want vector search inside Postgres without adding a separate database.

Starting price

Free

From [github.com/pgvector/pgvector/blob/master/LICENSE](https://github.com/pgvector/pgvector/blob/master/LICENSE), checked 12 November 2026

- MCP server Not stated
- API Yes
- Open source Yes
- Self-host Yes

- GitHub stars: 23.3k

[Docs](https://github.com/pgvector/pgvector#readme) [GitHub](https://github.com/pgvector/pgvector)

What we checked

- Pages last read: 12 November 2026
- Facts checked: 1 fact · From 1 source, read 30 October 2026
- AI answers: Too few read · 58 buyer-question answers read, November 2026

[How we check](https://agentsindex.ai/methodology) [Editorial policy](https://agentsindex.ai/editorial-policy#not-for-sale)

[Visit pgvector](https://agentsindex.ai/go/pgvector) [Compare](https://agentsindex.ai/compare?cat=agent-tools-and-integrations&products=pgvector)

## At a glance

- Category: [Agent tools and integrations](https://agentsindex.ai/categories/agent-tools-and-integrations)
- Tags: Freemium, Open source, Self-hosted

### Code

- Last push: 8 October 2026

### For developers

- Works with: Docker, Homebrew, PGXN, APT, Yum, pkg and 24 more

## pgvector in our research

[All research](https://agentsindex.ai/blog)

Study 19 October 2026 – 16 November 2026

### [AI Tool Pricing Index, November 2026](https://agentsindex.ai/data/ai-tool-pricing-index)

Pricing

Free only

29 of the 361 tools we checked are free with no paid plan.

Edition price, checked 12 November 2026.

Pricing pages of the AI tools, November 2026 edition as of 16 November 2026 n = 361 tools checked

## What it actually is

pgvector is a Postgres extension (C, built with the standard Postgres extension build system) that adds a `vector` column type plus supporting index types (HNSW, IVFFlat) and distance operators (L2, inner product, cosine, L1, and — for binary vectors — Hamming and Jaccard). It's maintained by Andrew Kane (creator of many similar 'ann' extensions across languages) as a single-purpose extension, not a company or hosted product. Everything runs inside your existing Postgres instance: same backups, same replication, same transactions, same JOINs against your relational data.

## Technical capabilities, verified against the current release (v0.8.6)

Vector storage: `4 * dimensions + 8` bytes per vector, up to 2,000 dimensions for indexed `vector` columns, 4,000 for `halfvec` (half-precision), and 64,000 for binary-quantized `bit` vectors; raw (unindexed) `vector` columns can go up to 16,000 dimensions. Supports exact search out of the box and two approximate index types (HNSW and IVFFlat), plus binary quantization, sparse vectors, iterative index scans (to recover recall lost to post-filtering), and partial/partitioned indexing for multi-tenant isolation. Requires Postgres 13+; official Docker images are published for Postgres 13 through 18. Client libraries exist for roughly 30 languages, maintained in separate `pgvector/pgvector-` repos.

## Maturity and maintenance

Created in April 2021 and actively maintained: the latest tag is v0.8.6 (29 July 2026), with bug-fix PRs merged as recently as 4 August 2026 (a race condition between HNSW insert and vacuum), and commits as recent as 15 August 2026. Release cadence has been roughly monthly through 2026 (0.8.2 through 0.8.6, plus an 0.8.7 unreleased branch already in the changelog). No security advisories are filed against the repo, and no entries appear in the OSV.dev vulnerability database. One caveat: contribution is heavily concentrated — Andrew Kane accounts for 1,915 of the commits in the top-10 contributor list against 18 for the next-most-active contributor — so this is a single-maintainer project in practice, even though it's widely deployed and gets outside code review from contributors at AWS and other Postgres vendors on individual PRs.

## License

The PostgreSQL License — a permissive, OSI-approved license structurally similar to MIT/BSD (no copyleft, no field-of-use restriction). GitHub's own license detector reports it as "Other / NOASSERTION" because the license text is PostgreSQL's own non-templated wording rather than a byte-for-byte match to a known template, not because the terms are unusual or restrictive — the actual LICENSE file text is standard permissive language used by PostgreSQL itself since the 1990s.

## Where it stops being the right tool

Independent community reporting (via Qdrant's own comparison post, so read as an interested party) and pgvector's own README agree on the shape of the ceiling: index build time and recall both degrade as the HNSW graph grows past what fits in `maintenance_work_mem`, and the graph needs to fit in memory for good query performance. Using the README's own storage formula, 10 million vectors at a common embedding size (1536 dimensions, e.g. OpenAI's text-embedding-3-small) works out to roughly 61.5 GB of raw vector storage before HNSW graph overhead — more RAM than most single Postgres instances carry by default. Timescale's Postgres extension pgvectorscale (a separate, third-party project, not part of pgvector itself) adds a disk-based DiskANN index aimed specifically at this gap; Timescale's own benchmark (their product, their numbers) claims 16x higher throughput and 28x lower p95 latency than Pinecone's storage-optimized tier at 50M vectors — useful context on the ceiling, but a vendor benchmark of their own extension, not independent.

## Where it's actually deployed

pgvector ships as an installable/preinstalled extension on Amazon RDS and Aurora PostgreSQL, Neon, Supabase, Google Cloud SQL for PostgreSQL, and Azure Database for PostgreSQL, among others — confirmed directly on AWS's and Neon's own docs. Its own README declines to maintain a hosted-provider list and instead points to a community-tracked GitHub issue, which is a reasonable choice for a project this widely adopted but means you should verify support and version on your specific provider before assuming it's current.

Our take

Check whether your embedding workload needs the Enterprise tier's data residency, SCIM provisioning, or SAML single sign-on. Those controls are only listed on Enterprise, so teams with compliance or identity requirements should verify the upgrade path before standardizing on lower tiers.

## pgvector price and terms

### Terms

- Free plan: Yes The published license grants use, copying, modification, and distribution without fee

Where these prices come from

[github.com/pgvector/pgvector/blob/master/LICENSE](https://github.com/pgvector/pgvector/blob/master/LICENSE), checked 12 November 2026

### All plans and limits

| Plan | Price | Main limits |
| --- | --- | --- |
| pgvector | Free | None stated |

Read 12 November 2026 from [github.com/pgvector/pgvector/blob/master/LICENSE](https://github.com/pgvector/pgvector/blob/master/LICENSE).

## What we checked on pgvector

What it costs to start No

### What the price counts

The no-fee license establishes a free project rather than a paid seat or usage meter.

> Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is…

LICENSE, permission grant, first paragraph [github.com/pgvector/pgvector/blob/maste…](https://github.com/pgvector/pgvector/blob/master/LICENSE) Checked 30 October 2026

## Questions about pgvector

- How much does pgvector cost?: pgvector is free to use. From github.com/pgvector/pgvector/blob/master/LICENSE, checked 12 November 2026.
- Does pgvector have an API or an MCP server?: pgvector has an API.
- Is pgvector open source, and can you host it yourself?: pgvector is open source. You can host pgvector yourself.
- What have we checked on pgvector?: 1 fact, under one heading: What it costs to start.
- How do we check pgvector?: We hold 1 fact on pgvector, quoted from 1 page. Facts last checked 30 October 2026. Price last checked 12 November 2026. Last change found 21 March 2026.

[How we check every listing](https://agentsindex.ai/methodology)

## Sources and changes

Last changed 21 March 2026

Sources 1

- Read 12 November 2026 · [github.com](https://github.com/pgvector/pgvector/blob/master/LICENSE) /pgvector/pgvector/blob/master/LICENSE

Repository

- Stars: 23,326
- Last push: 8 October 2026

## pgvector price history

We have read the price once so far, on 12 November 2026: free.

| Price | Plan | First seen | Last seen | Readings | Source |
| --- | --- | --- | --- | --- | --- |
| Free |   | 12 November 2026 | 12 November 2026 | 1 | [Pricing page, read 12 November 2026](https://github.com/pgvector/pgvector/blob/master/LICENSE) |

From our research on 12 November 2026. A date is when we read the page, not when the price changed.

## Similar in Agent tools and integrations

[See all in Agent tools and integrations](https://agentsindex.ai/categories/agent-tools-and-integrations)

- [ERIUS PHONE](https://agentsindex.ai/eriusphone) Rented cloud Android phones, each in its own container, that keep an agent's apps and sign-ins between sessions. From about $44 a month
- [TinyFish](https://agentsindex.ai/tinyfish) Web search, page fetching, cloud browsers and goal-driven web automation for AI agents, with search and fetch free. Free plan, then $0.002 per minute
- [Smithery](https://agentsindex.ai/smithery) Public MCP server registry, now run by Arcade, listing direct vendor MCP URLs after its proxy shut down. Free plan
- [UI Discovery](https://agentsindex.ai/uidiscovery) A library of real websites, iOS apps and dashboards with each one's palette, fonts and original build prompt. From $20 a month

## Is pgvector yours?

Free, and the page then carries the verified owner mark. [Claim this listing](https://agentsindex.ai/claim/pgvector?from=owner-line)

[Report an error](mailto:hello@agentsindex.ai?subject=Report%20an%20error%3A%20pgvector%20(pgvector)&body=What%20is%20wrong%20on%20the%20page%2C%20and%20where%20on%20the%20product) if a fact is wrong.
