# vector-store-wasp-drone

vector-store-wasp-drone owns embedding storage: column shape, index choice, migrations, dataset versions. Useful when a project has to settle on pgvector, Deep Lake or Qdrant.

- subagent · `type=agent` · Claude Code, Codex, Cursor · ★ 96 repo stars
- Author: Legion Code Inc.
- License: AGPL-3.0-or-later · policy=link-only · description only; the file stays with the author
- Source: https://github.com/legioncodeinc/vibe-coding-tools/tree/HEAD/plugins/data-and-ai-tools/agents/vector-store-wasp-drone.md
- Updated: 2026-10-18
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/agents/vector-store-wasp-drone

## What it does

The subagent covers embedding storage: column shape, index choice, migrations and dataset versioning. Neon Postgres with `pgvector` and Drizzle is the stack it assumes first. Deep Lake, Qdrant and managed services are documented as alternatives, with a matrix for picking between them.

Schema work goes through Drizzle's `vector({ dimensions: N })`, sized to whatever the embedding model outputs. HNSW is the default index, with the operator class matched to the distance the queries actually use. A `vector_l2_ops` index does nothing for a `<=>` query — no error, just a sequential scan, so confirm with `EXPLAIN` before deciding the index is broken.

Hybrid search pairs a `vector` column with a generated `tsvector` column and a GIN index; fusion and ranking belong to another subagent. Changing dimensions is a four-step migration: new column, backfill, cutover, cleanup. On Claude the agent file sits at `.claude/agents/vector-store-wasp-drone.md`; for Codex it is `.codex/agents/vector-store-wasp-drone.toml`.

## Requirements
- Works with: PostgreSQL

## Install

### Claude Code (native platform)

1. **Plugin marketplace**
In the agent chat (not a shell):
```text
/plugin marketplace add legioncodeinc/vibe-coding-tools
```
In the agent chat (not a shell):
```text
/plugin install data-and-ai-tools@wasp-nest
```

2. **Manually: put the files in place**
- File: `.claude/agents/vector-store-wasp-drone.md` — For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

### Codex

**Manually: put the files in place**
- File: `.codex/agents/vector-store-wasp-drone.toml` — Codex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/

### Cursor

**Manually: put the files in place**
- File: `.cursor/agents/vector-store-wasp-drone.md` — Cursor also reads .claude/agents/

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/legioncodeinc/vibe-coding-tools/tree/HEAD/plugins/data-and-ai-tools/agents/vector-store-wasp-drone.md

## When to use it
- Design a vector column that matches the model's output width
- Pick between HNSW and IVFFlat for a given query
- Wire hybrid search over `vector` and `tsvector` columns
- Plan a dimension change as a migration instead of a resize
- Decide whether pgvector is enough or Qdrant is warranted

## Example prompts
- Design an embedding table in Drizzle sized to the model's output width
- Which index should this vector column use if we search by cosine distance?
- Wire hybrid search over the `vector` and `tsvector` columns here

## Similar
- [langchain4j-vector-stores-configuration](https://affpapa.org/en/nevibecode/skills/langchain4j-vector-stores-configuration.md) — skill · 3900 installs
- [Vector Search — In-Memory TF-IDF Semantic Store](https://affpapa.org/en/nevibecode/mcp/vector-search-in-memory-tf-idf-semantic-store.md) — MCP server · 3562 installs
- [vector-database-engineer](https://affpapa.org/en/nevibecode/agents/rohitg00-vector-database-engineer.md) — subagent · ★ 2858 repo stars
- [pgvector-semantic-search](https://affpapa.org/en/nevibecode/skills/pgvector-semantic-search.md) — skill · 1000 installs
- [postgres-semantic-search](https://affpapa.org/en/nevibecode/skills/postgres-semantic-search.md) — skill · 227 installs
- [grepai-storage-postgres](https://affpapa.org/en/nevibecode/skills/grepai-storage-postgres.md) — skill · 560 installs

From the same set: [legioncodeinc/vibe-coding-tools](https://affpapa.org/en/nevibecode/by/legioncodeinc/vibe-coding-tools.md) — 172 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
