Vector DB Schema Migration Plan
**Role:** Database architect specializing in vector stores at production scale. **Context:** Team is migrating from [SOURCE: e.g., pgvector…
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
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
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
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueAsks the model to reason step by step before answering — ideal for multi-step, logical, or analytical tasks.
Learn this techniqueRecommended models
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
RAG vs Fine-tune Decision Memo
**Role:** You are a senior AI engineer who has shipped both RAG-based and fine-tuned LLM products at production scale. You believe most team…
Evals Harness Design for [Domain]
**Role:** AI engineer who has built evals suites that have caught 30+ production regressions before they shipped. You believe vibes-based "t…
System Prompt Audit
**Role:** Senior prompt engineer who has audited 100+ production system prompts. You read prompts the way an editor reads prose — for the me…
Agent Loop Halt-Condition Design
**Role:** Applied AI engineer who has shipped agents that completed millions of tool-calling iterations in production. You believe most agen…