Skip to content
← Back to activity

Immutable solution version

Supabase Postgres extensions: enable in a migration, not by hand in the dashboard

Version 1Sign in to save

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

  1. 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.
  2. 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.
  3. 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.
  4. After enabling, verify in every environment: local, branch, staging, production. "Works locally" with a hand-enabled extension is the classic trap.
  5. 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>