# pgvector-semantic-search

> Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semanti…

Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search.

**Trigger when user asks to:**
- Store or search vector embeddings in PostgreSQL
- Set up semantic search, similarity search, or nearest neighbor search
- Create HNSW or IVFFlat indexes for vectors
- Implement RAG (Retrieval Augmented Generation) with PostgreSQL
- Optimize pgvector performance, recall, or memory usage
- Use binary quantization for large vector datasets

**Keywords:** pgvector, embeddings, semantic search, vector similarity, HNSW, IVFFlat, halfvec, cosine distance, nearest neighbor, RAG, LLM, AI search

Covers: halfvec storage, HNSW index configuration (m, ef_construction, ef_search), quantization strategies, filtered search, bulk loading, and performance tuning.

- Type: Skill
- Made by: timescale
- Category: Databases
- Formats: Skills
- Version: 7188e43
- Source: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search
- Page: https://pluginboard.ai/skills/pgvector-semantic-search

## Works with

- ChatGPT
- Claude
- Gemini
- GitHub Copilot
- Cursor
- Claude Code
- Codex
- Antigravity
- Gemini CLI
- Replit
- OpenClaw
- OpenCode
- Hermes Agent

## Install

### ChatGPT

In ChatGPT: Download the pgvector-semantic-search folder and zip it, then Plugins → Skills → Create → Upload from your computer. Business and Enterprise plans.

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Claude

In Claude (web or desktop): Download the pgvector-semantic-search folder and zip the folder itself, then upload it in Customize → Skills.

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Gemini

In Gemini: Download the pgvector-semantic-search folder, then at gemini.google.com click Customize → Skills → Create → Upload and pick the folder (or a .zip of it).

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### GitHub Copilot

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.copilot/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Cursor

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.cursor/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Claude Code

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.claude/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Codex

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.agents/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Antigravity

In Antigravity: Copy the pgvector-semantic-search folder into ~/.gemini/config/skills (Antigravity app and IDE) or ~/.gemini/antigravity-cli/skills (Antigravity CLI).

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Gemini CLI

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.gemini/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Replit

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search .agents/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### OpenClaw

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.openclaw/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### OpenCode

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.config/opencode/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

### Hermes Agent

Run in your terminal:

```shell
npx -y degit timescale/pg-aiguide/skills/pgvector-semantic-search ~/.hermes/skills/pgvector-semantic-search
```

View the folder on GitHub: https://github.com/timescale/pg-aiguide/tree/HEAD/skills/pgvector-semantic-search

---
From Pluginboard (https://pluginboard.ai).