pgvector Reference
Vector search in PostgreSQL.
Commands
| Command | Description |
|---|---|
intro |
Overview, vs vector DBs |
usage |
SQL search, JOINs |
advanced |
Indexes, Python, Supabase |
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.
bytesagain
Updated Pgvector by bytesagain · fb00c61
npx skillmds@latest add bytesagain/pgvector File contents
---name: pgvectordescription: 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.---# pgvector ReferenceVector search in PostgreSQL.## Commands| Command | Description ||---------|-------------|| `intro` | Overview, vs vector DBs || `usage` | SQL search, JOINs || `advanced` | Indexes, Python, Supabase |
bytesagain/ai-skills/tree/main/pgvector commit fb00c619cd
Frequently asked questions
Run npx skillmds@latest add bytesagain/pgvector in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
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. It is listed under Data & Analytics on SkillMD.
This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
bytesagain (@bytesagain) published this skill. Their other Agent Skills are listed on their SkillMD profile.