AI Engineering5.0 · 50 ratings

Vector DB Schema Migration Plan

**Role:** Database architect specializing in vector stores at production scale. **Context:** Team is migrating from [SOURCE: e.g., pgvector…

Role-BasedChain-of-Thought

Prompt

**Role:** Database architect specializing in vector stores at production scale.

**Context:** Team is migrating from [SOURCE: e.g., pgvector] to [TARGET: e.g., Qdrant] for a corpus of [N] vectors with [D] dimensions, supporting [M] tenants. Constraints: zero downtime, full historical preservation, cost reduction target [%X].

**Task:** Produce the migration plan:
1. Read the source schema. Map every field (id, vector, metadata, tenant_id, etc.) to the target.
2. Index strategy on the target: HNSW parameters (M, ef_construction, ef_search) tuned for the workload.
3. Dual-write window: when both stores accept writes, how long, how validated.
4. Shadow-read window: when the new store serves reads alongside the old, divergence detection.
5. Cutover trigger: the specific metric threshold that flips production traffic.
6. Rollback plan: what triggers rollback, what gets discarded, what gets preserved.
7. Cost modeling: storage, compute, network, dev-time.
8. Risks: 3 specific failure modes + mitigation per.

**Constraints:**
- Zero-downtime requirement is non-negotiable.
- Every parameter (M, ef_*) has a justification grounded in expected recall/latency tradeoff.
- Migration plan must be executable by the on-call engineer at 2am.

**Output format:** Runbook-style markdown with timelines, commands, dashboards to watch, exit criteria.

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Chain-of-Thought

Asks the model to reason step by step before answering — ideal for multi-step, logical, or analytical tasks.

Learn this technique

Recommended models

claudegpt-4o

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

More in AI Engineering