# Pgvector

> 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.

- Skill: `bytesagain/pgvector` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add bytesagain/pgvector`
- Raw SKILL.md: https://api.skillmd.com/api/skills/bytesagain/pgvector/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: bytesagain (https://skillmd.com/u/bytesagain)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/bytesagain/pgvector

---


# pgvector Reference

Vector search in PostgreSQL.

## Commands

| Command | Description |
|---------|-------------|
| `intro` | Overview, vs vector DBs |
| `usage` | SQL search, JOINs |
| `advanced` | Indexes, Python, Supabase |