Skip to main content
subagent CX Codex

vector-store-wasp-drone — Claude Code subagent: pgvector, Drizzle

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.

AGPL-3.0-or-later ★ 96 updated 2026-10-18

Install into Claude Code · Plugin marketplace All methods and platforms ↓
/plugin marketplace add legioncodeinc/vibe-coding-tools
/plugin install data-and-ai-tools@wasp-nest
Open on GitHub

What vector-store-wasp-drone 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.

What it helps with

  • 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 for the agent

  • 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

How to install vector-store-wasp-drone

1Plugin marketplace

/plugin marketplace add legioncodeinc/vibe-coding-tools
/plugin install data-and-ai-tools@wasp-nest

2Manually: put the files in place

.claude/agents/vector-store-wasp-drone.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean

Questions about vector-store-wasp-drone

How to install vector-store-wasp-drone in Claude Code?

Run /plugin marketplace add legioncodeinc/vibe-coding-tools, then /plugin install data-and-ai-tools@wasp-nest. The agent file lands at .claude/agents/vector-store-wasp-drone.md.

What does vector-store-wasp-drone do?

It designs vector storage: the column and its dimensions, the index with a matching operator class, hybrid search wiring, migrations and dataset versions. The default stack is Neon Postgres with pgvector and Drizzle.

What does it hand off to other subagents?

Schema PRD writing, secret and PII audits, and recall tuning or embedding-model choice stay with other wasp-drones. This one flags those concerns and passes them on.

Similar subagents

All subagents for Data and databases →

From the same set172

The whole set →
git-wasp-drone git-wasp-drone — a Git subagent for rebase, conflict recovery, hooks, worktrees, and large files. Use it when a routine Git task turns into a history or workflow problem. CX Codex ★ 96repo stars alt-ads-platforms-wasp-drone alt-ads-platforms-wasp-drone is a Claude Code subagent that diagnoses paid ad platform fit and helps design campaigns with CAPI tracking. CX Codex ★ 96repo stars website-wasp-drone website-wasp-drone scaffolds complete SvelteKit 5, Payload CMS, and Supabase monorepos from project briefs using a 12-phase delivery playbook. CX Codex ★ 96repo stars tauri-stinger tauri-stinger guides Tauri 2 desktop and mobile work, from project inspection and migration to testing and release. Use it when a change depends on Tauri-specific behavior. CX Codex +1 ★ 96repo stars crm-integration-wasp-drone crm-integration-wasp-drone architects CRM pipelines, maps entity schemas, and designs sync logic. Connects your product to HubSpot, Salesforce, Attio, or Pipedrive without data loss. CX Codex ★ 96repo stars product-feedback-roadmap-wasp-drone product-feedback-roadmap-wasp-drone helps choose a customer feedback platform, group duplicate requests, and shape a product roadmap. Use it when feedback is scattered across tools or priorities are unclear. CX Codex ★ 96repo stars ai-tools-platform-wasp-drone ai-tools-platform-wasp-drone picks the AI gateway, cloud provider, model tier and GPU cloud for a given task. Triggers on requests like "which AI provider should I use" or "set up Portkey". CX Codex ★ 96repo stars rust-stinger rust-stinger guides bounded Rust development across Cargo workspaces, Tokio runtimes, SQLx persistence, and test validation before release. CX Codex +1 ★ 96repo stars

Project sponsors

Companies that keep this analytics open