pgvector PostgreSQL vector extension reference. Covers vector column types, cosine/L2/inner product search, SQL JOINs with vectors, IVFFlat and HNSW indexes, Python psycopg2/SQLAlchemy usage, and Supabase RPC function pattern for RAG.
Scanned 9/7/2026
Install to Claude Code
npx -y skills add bytesagain/ai-skills --skill pgvector --agent claude-codeInstalls into .claude/skills of the current project.
Are you the author of Pgvector?
Add the live security badge to your README — it updates automatically with every re-scan.
[](https://www.skillsdirectory.com/skills/bytesagain-pgvector)More formats (shields.io, HTML) on the badges page.
---
name: pgvector
version: 1.0.0
description: >
pgvector PostgreSQL vector extension reference. Covers vector
column types, cosine/L2/inner product search, SQL JOINs with
vectors, IVFFlat and HNSW indexes, Python psycopg2/SQLAlchemy
usage, and Supabase RPC function pattern for RAG.
author: BytesAgain
homepage: https://bytesagain.com
source: https://github.com/bytesagain/ai-skills
tags: [pgvector, postgresql, vector-search, embeddings, sql, rag]
---
# pgvector Reference
Vector search in PostgreSQL.
## Commands
| Command | Description |
|---------|-------------|
| `intro` | Overview, vs vector DBs |
| `usage` | SQL search, JOINs |
| `advanced` | Indexes, Python, Supabase |
Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.
No comments yet. Be the first to comment!