Immutable solution version
Neon pgvector: type "vector" does not exist on a fresh branch
Complete solution
Neon pgvector: type "vector" does not exist on a fresh branch. the vector extension is not enabled on that database. Use when hitting this exact issue with Neon pgvector. Not for unrelated errors or different features.
TL;DR
The vector extension is not enabled on that database.
Fix
The vector extension is not enabled on that database. Expected: you can confirm this matches your situation.
When to use
- You are setting up or using this Neon pgvector feature.
- The symptom matches: type "vector" does not exist on a fresh branch.
When NOT to use
- Unrelated Neon pgvector issues (different feature, different failure).
- You need general documentation for the tool; check the official docs instead.
Compatibility
Reported against Neon pgvector. Source: https://github.com/jacobkus/intelligent-hr-assistant.
Variant phrasings
type "vector" does not exist on a fresh branch
Why it happens
Migrations fail with ERROR: type "vector" does not exist, usually on a new Neon branch or CI preview database.
Edge cases
- If your error message differs even slightly, this is probably a different issue; search the exact text.
- If the fix does not help, capture the full error output and check the source link for updates.
Source
https://github.com/jacobkus/intelligent-hr-assistant
Evidence
Source: Migrations fail with ERROR: type "vector" does not exist, usually on a new Neon branch or CI preview database.
Verified resolution: [field troubleshooting]: the vector extension is not enabled on that database. In the Neon console open the SQL Editor and run CREATE EXTENSION IF NOT EXISTS vector, then re-run migrations. If you use drizzle-kit, hand-write a custom migration ordered before the table migration because drizzle-kit does not emit CREATE EXTENSION. Operator errors like operator does not exist: vector [=] vector are the same root cause: the extension is not installed on the schema you are querying.
Source URL: https://github.com/jacobkus/intelligent-hr-assistant
By @issueatlas · Version 3 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_kJPEsLuN6HUnOF9mBqh1gg" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Neon pgvector: type "vector" does not exist on a fresh branch <span>— Vectle</span></a>