chore(supabase): adopt declarative schema and sync config with remote projects by ivasilov · Pull Request #52031 · supabase/supabase · GitHub
Skip to content

chore(supabase): adopt declarative schema and sync config with remote projects - #52031

Draft
ivasilov wants to merge 10 commits into
masterfrom
ivanvasilov/fe-4662-resolve-replication-slot-blocker-and-upgrade-live-supabase
Draft

chore(supabase): adopt declarative schema and sync config with remote projects#52031
ivasilov wants to merge 10 commits into
masterfrom
ivanvasilov/fe-4662-resolve-replication-slot-blocker-and-upgrade-live-supabase

Conversation

@ivasilov

@ivasilov ivasilov commented Oct 20, 2026

Copy link
Copy Markdown
Member

Problem

The repo's supabase/ project had drifted from the live project: migrations no longer matched prod, config was missing remote settings, and there was no failover project setup. This blocks upgrading the live project (FE-4662).

Solution

  • Bump the Supabase CLI to ^2.120.0.
  • Set up a declarative schema in supabase/schemas/ (db.migrations.schema_paths), covering public, content, metrics, storage, utils and cluster-level extensions.
  • Add the 20261019120000_sync_remote_drift migration to capture the drift between the existing migrations and the prod project. Add a qualifier to 20240723155310_add_lw12_ticketing_schema (functionally unchanged).
  • Pull remote config into config.toml (pooler, SSL enforcement, storage analytics and image transformation, storage buckets) and add a remotes.failover project.
  • Download the edge functions from prod.
  • Add agent instructions for the declarative schema in supabase/AGENTS.md, linked from the root AGENTS.md.

Review instructions

  1. Read supabase/AGENTS.md for the declarative schema workflow.
  2. Run supabase db diff against a local database and confirm the schemas match the migrations plus the drift migration.
  3. Check supabase/config.toml against the prod project settings.

Checklist

🤖 Generated with Claude Code

@vercel

vercel Bot commented Oct 20, 2026 •
edited
Loading

Copy link
Copy Markdown

@coderabbitai

coderabbitai Bot commented Oct 20, 2026

Copy link
Copy Markdown
Contributor

Important

Draft PR not reviewed

Draft PRs are not automatically reviewed by default.

  • Trigger a manual review

To automatically review draft PRs, update your CodeRabbit configuration:

reviews:
  auto_review:
    drafts: true
  • Autofix · Keep fixing CodeRabbit findings and required CI, and resolving merge conflicts

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

Comment @coderabbitai help to get the list of available commands.

@supabase

supabase Bot commented Oct 20, 2026 •
edited
Loading

Copy link
Copy Markdown

Updates to Preview Branch (ivanvasilov/fe-4662-resolve-replication-slot-blocker-and-upgrade-live-supabase) ↗︎

Deployments Status Updated
Database ✅ Wed, 21 Oct 2026 15:54:39 UTC
Services ✅ Wed, 21 Oct 2026 15:54:39 UTC
APIs ✅ Wed, 21 Oct 2026 15:54:39 UTC

Tasks are run on every commit but only new migration files are pushed.
Close and reopen this PR if you want to apply changes from existing seed or migration files.

Tasks Status Updated
Configurations ✅ Wed, 21 Oct 2026 15:54:40 UTC
Migrations ✅ Wed, 21 Oct 2026 15:54:40 UTC
Seeding ✅ Wed, 21 Oct 2026 15:54:41 UTC
Edge Functions ✅ Wed, 21 Oct 2026 15:54:43 UTC

View logs for this Workflow Run ↗︎.
Learn more about Supabase for Git ↗︎.

@blacksmith-sh

blacksmith-sh Bot commented Oct 20, 2026 •
edited
Loading

Copy link
Copy Markdown
Contributor

Found 4 test failures on Blacksmith runners:

Failures

Test View Logs
[Features] › features/
cron-jobs.spec.ts:114:7 › Cron Jobs › Cron Jobs Integration › Cron Jobs CRUD Operations
› can create a new cron job 		View Logs
[Features] › features/
cron-jobs.spec.ts:114:7 › Cron Jobs › Cron Jobs Integration › Cron Jobs CRUD Operations
› can create a new cron job 		View Logs
Cron Jobs › Cron Jobs Integration › Cron Jobs CRUD Operations/can create a new cron job View Logs
Cron Jobs › Cron Jobs Integration › Cron Jobs CRUD Operations/can create a new cron job View Logs

Fix with [code]smith
Need help on this PR? Tag @codesmith-bot with what you need.

@github-actions

github-actions Bot commented Oct 20, 2026 •
edited
Loading

Copy link
Copy Markdown
Contributor

@github-actions github-actions Bot added the documentation Improvements or additions to documentation label Oct 21, 2026

This branch has not been deployed

No deployments
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

documentation Improvements or additions to documentation

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

1 participant

@ivasilov