
pgvector-python
pgvector support for Python
The Lens
pgvector-python is the Python client for pgvector, the extension that turns Postgres into a vector database. If you are building AI search, the kind where your app finds things by meaning instead of exact keywords, and you already run Postgres, this lets you store and query embeddings in the database you've got. No separate vector store to provision. It speaks to psycopg, asyncpg, SQLAlchemy, Django, and the rest of the Python data stack.
There is nothing to operate beyond the Postgres you already run. Install the package, make sure the pgvector extension is enabled on your database, and you are inserting and querying vectors. The whole appeal is consolidation: one database for your relational data and your embeddings, one backup story, one thing to monitor, instead of bolting a dedicated vector service onto your stack.
Solo developers and small teams building RAG or semantic search on an existing Postgres should reach for this before paying for a managed vector database. It is free, it is boring in the good way, and it scales further than people expect.
The catch is that it is a thin client, not the engine. The performance ceiling is pgvector and Postgres themselves, and at very large scale or very high query volume a purpose-built vector database like a self-hosted Qdrant or Milvus will outrun it. For most apps you will never hit that wall, but know it is there.
Free vs Self-Hosted vs Paid
fully freeFree: The client library is free and open source, as is pgvector itself.
Self-hosted reality: Install the package and enable the pgvector extension on your Postgres. Nothing new to run.
Paid: None for the client. If you use a managed Postgres that bills for compute and storage, that is your only cost, and it is Postgres you were likely paying for anyway.
Completely free and open source. The only thing you operate is the Postgres you already run.
Get tools like this every Wednesday
One featured tool, three on the radar. No fluff.
License: MIT License
Use freely, including commercial. Just keep the license.
Commercial use: ✓ Yes
About
- Owner
- pgvector (Organization)
- Stars
- 1,496
- Forks
- 95
Explore Further
More tools in the directory
openclaw
Your own personal AI assistant. Any OS. Any Platform. The lobster way. 🦞
377.9k ★everything-claude-code
The agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond.
212.9k ★claw-code
The repo is finally unlocked. enjoy the party! The fastest repo in history to surpass 100K stars ⭐. Join Discord: https://discord.gg/5TUQKqFWd Built in Rust using oh-my-codex.
193.6k ★