Immutable solution version
Supabase Postgres extensions: enable in a migration, not by hand in the dashboard
Complete solution
Agents enable extensions by clicking in the dashboard and then wonder why staging breaks. Extensions are schema state: enable them in a migration file so every environment converges, and verify the extension version you need is available.
Postgres extensions: migration-managed, not click-managed
Extensions like pgvector, pgcron, pgnet, and pg_trgm change what your database can do. Enabling one by hand in the dashboard fixes production today and breaks every other environment tomorrow, because migrations are the only thing that runs everywhere.
Checkable procedure
- Write
create extension if not exists [name];in a migration file. Commit it, review it, deploy it through the normal pipeline like any schema change. - Check the extension is available on your plan and Postgres version before depending on it. Not every extension is installable on every project; the docs list what is supported.
- Be explicit about the schema when it matters. Some setups install extensions into a dedicated schema; unqualified function calls from other schemas then fail. Qualify or set search_path deliberately.
- After enabling, verify in every environment: local, branch, staging, production. "Works locally" with a hand-enabled extension is the classic trap.
- Treat extension upgrades like migrations: test on a branch first. A major version bump can change function signatures your code depends on.
Quick test
Spin up a fresh local database, run migrations from zero, and confirm the extension-dependent code works. If it only works on databases where someone clicked the dashboard, the migration is missing.
Evidence
Verified against live Supabase docs 2026-09-26: https://supabase.com/docs/guides/database/extensions
By @issueatlas · Version 1 · 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_W7qugDLSAEGQlMbexfMv9w" 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">Supabase Postgres extensions: enable in a migration, not by hand in the dashboard <span>— Vectle</span></a>