Skip to main content
skill CX Codex

vector-store-stinger — Claude Code skill: vector storage design

vector-store-stinger is a skill for choosing pgvector, Deep Lake, or Qdrant, configuring indexes, and planning migrations for projects storing embeddings.

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-stinger does

vector-store-stinger covers the full lifecycle of vector data: greenfield store selection, schema design, index tuning, and migration planning. The skill references guides for pgvector with Drizzle (the default for this repository), Deep Lake as an option for existing projects, and Qdrant or managed services like Pinecone.

It enforces hard rules that prevent common mistakes: embedding dimension is a schema constraint, not a runtime detail; operator class must match the distance metric; every migration is broken into steps. For pgvector, separate guides cover Drizzle schemas, indexing, hybrid search (vector plus full-text), and migrations.

The skill does not handle security audits, credential storage, or embedding generation—those are delegated to other skills. PostgreSQL with the pgvector extension or your chosen alternative store is required to function.

What it helps with

  • select a vector store for a new project with embeddings
  • design a Drizzle schema with a vector column in PostgreSQL
  • choose and configure HNSW or IVFFlat indexes
  • plan and execute a migration when dimension or index type changes
  • build hybrid search combining full-text and vector queries

Example prompts for the agent

  • Help me pick a vector store: my project runs Postgres already, but I'm not sure whether pgvector or Qdrant fits better.
  • Design a documents table with a 1536-dimensional vector column and recommend an index for fast retrieval.
  • Write a migration that adds hybrid search using both tsvector and vector columns with fusion ranking.

How to install vector-store-stinger

1Plugin marketplace

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

This installs the whole data-and-ai-tools plugin with all its skills

2Skills CLI (Vercel)

npx skills add legioncodeinc/vibe-coding-tools --skill vector-store-stinger -a claude-code

3Manually: put the files in place

~/.claude/skills/vector-store-stinger/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/vector-store-stinger/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about vector-store-stinger

How do I install vector-store-stinger in Claude Code?

Run /plugin marketplace add legioncodeinc/vibe-coding-tools, then /plugin install data-and-ai-tools@wasp-nest, then npx skills add legioncodeinc/vibe-coding-tools --skill vector-store-stinger -a claude-code. Open ~/.claude/skills/vector-store-stinger/SKILL.md afterwards.

What does vector-store-stinger do?

It guides vector storage design: selecting the right store (pgvector, Deep Lake, Qdrant), building schemas with appropriate indexes, planning migrations, and structuring hybrid search that combines full-text and vector queries.

What is the default storage option?

Neon Postgres with the pgvector extension and Drizzle. Deep Lake, Qdrant, and managed services are documented as alternatives with different tradeoffs—the choice depends on your project's needs.

Similar skills

All skills for Data and databases →

From the same set172

The whole set →
devops-stinger The devops-stinger skill helps create and audit Docker builds and GitHub Actions workflows. Use it for Compose setup, CI security, caching, image scans, or Depot migration. CX Codex +1 ★ 96repo stars payments-stinger payments-stinger — a skill for building a custom checkout with Stripe Elements instead of redirecting to Stripe's hosted page. Handles trial, payment, and access state, enforces entitlements on the server, and prepares support actions. CX Codex +1 ★ 96repo stars vercel-wasp-drone vercel-wasp-drone configures Vercel hosting for SvelteKit and Neon Postgres, handling caching rules, environment secrets, and budget guardrails. CX Codex ★ 96repo stars affiliate-referral-program-wasp-drone The affiliate-referral-program-wasp-drone subagent helps plan SaaS affiliate and referral programs, from platform choice and attribution to payout rules and fraud checks. CX Codex ★ 96repo stars customer-support-tooling-wasp-drone customer-support-tooling-wasp-drone helps SaaS teams pick helpdesk software, organize shared inboxes, integrate Linear and draft SLA policies for small founder-led squads. CX Codex ★ 96repo stars typography-font-wasp-drone typography-font-wasp-drone is a Claude Code subagent for font loading and web typography. It activates for requests about FOIT/FOUT, fluid type scales, or moving to next/font. CX Codex ★ 96repo stars mcp-tool-docs-stinger mcp-tool-docs-stinger — a skill for documenting MCP tools, TypeScript APIs, and CLIs grounded in source code: schemas, outputs, side effects, examples. Use when writing or auditing tool, API, or CLI documentation. CX Codex +1 ★ 96repo stars queen-wasp-stinger queen-wasp-stinger — an orchestrator skill for authoring, testing, and packaging Wasp Nest components, subagents, rules, and plugins in Claude Code and Codex. CX Codex +1 ★ 96repo stars

Project sponsors

Companies that keep this analytics open