lovable-cloud-migration-sync
/lovable-cloud-migration-sync
Post-apply cleanup for Lovable-duplicated migrations: diff originals, db reset, delete, open PR. TRIGGER when: the user signals Lovable's migration apply step completed, regardless of exact wording. DO NOT TRIGGER when: all originals already deleted, or user asks about mechanics without signaling completion.
- Author
- jcdendrite ↗
- Repository
- claude-config ↗
- Licence
- MIT
- Last repository change
- 27.10.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 27.10.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Post-apply cleanup for Lovable-duplicated migrations: diff originals, db reset, delete, open PR. TRIGGER when: the user signals Lovable's migration apply step completed, regardless of exact wording. DO NOT TRIGGER when: all originals already deleted, or user asks about mechanics without signaling completion.
Original author description
Post-apply cleanup for Lovable-duplicated migrations: diff originals, db reset, delete, open PR. TRIGGER when: the user signals Lovable's migration apply step completed, regardless of exact wording. DO NOT TRIGGER when: all originals already deleted, or user asks about mechanics without signaling completion.
How it works
- Procedure
SKILL.md preview
---
name: lovable-cloud-migration-sync
description: >
Post-apply cleanup for Lovable-duplicated migrations: diff originals, db reset, delete, open PR.
TRIGGER when: the user signals Lovable's migration apply step completed, regardless of exact wording.
DO NOT TRIGGER when: all originals already deleted, or user asks about mechanics without signaling completion.
user-invocable: true
disable-model-invocation: true
---
# Lovable Migration Sync
> _The workflow shape (identify unsynced migrations → diff against originals → db reset → delete originals → open PR) is generic; file names like `migration-sync-pr.yml` and test commands like `npm run verify` are project-specific examples — adapt for your project._
**This is the engineer-reviewed fallback flow** — its safety rests on an engineer reviewing the resulting PR before merging; contexts that delete without that review need a dedicated, project-provided gated procedure that fails closed, not this one.
Lovable Cloud's Supabase instance has two non-obvious behaviors:
1. **It will not apply migration files it didn't create.** Migration files
committed by Claude Code or engineers sit in the repo but are never
executed on Lovable's database.
2. **Its migration runner is not a superuser.** Enforcement triggers fire
during migrations, blocking data modifications to protected columns.
## Procedure
### 1. Identify unsynced migrations
Check the commit author for each migration file. Lovable commits use its bot
signature; anything else (Claude Code, engineer) is a candidate for being
unapplied:
```bash
git log --diff-filter=A --format='%an %s' -- supabase/migrations/
```
Confirm by checking `src/integrations/supabase/types.ts` — if objects from a
migration are absent from types, that migration was not applied on Lovable Cloud.
### 2. Determine dependency order
Read the unsynced migration files and identify dependencies between them (e.g.,
table creation before FK references, function creation before trigger creation).
Order them so dependencies are satisfied.
### 3. Reference the PR comment (do not regenerate the message)
Your project's migration-sync workflow should post a comment on the PR with the
copy-paste Lovable message and a checklist. Direct the user to that comment —
do NOT regenerate the message in the terminal when the PR comment already exists.
The PR comment should include:
- The list of newly-added migration filenames.
- A copy-paste message in second person (to Lovable).
- A checklist item confirming Lovable has committed duplicate migrations.
- A caveat that ticking the box does not apply the migrations — only commits
from Lovable's bot on `main` do.
**If the PR comment is missing**, the workflow has a bug — fix the workflow,
do not draft the message manually.
### 4. Pull and verify duplicates
After Lovable commits, switch to `main` and pull:
```bash
git stash # if on a feature branch with uncommitted changes
git checkout main && git pull
```
Diff each Lovable-created duplicate against its original:
```bash
diff <(sed 's/[[:space:]]*$//' supabase/migrations/ORIGINAL.sql) \
<(sed 's/[[:space:]]*$//' supabase/migrations/LOVABLE_UUID.sql)
```
**Acceptable differences:**
- Stripped or reworded comments (cosmetic)
- Added `DROP TRIGGER/POLICY IF EXISTS` before create (more idempotent)
- Added `IF NOT EXISTS` guards (more idempotent)
- Trigger disable/re-enable wrapping
- Extra `DROP POLICY IF EXISTS` for Lovable-specific policy name variants
- Whitespace, trailing newline differences
**Unacceptable differences:**
- Changed function logic (different WHERE clauses, missing conditions)
- Missing sections (tables, policies, triggers not created)
- Different column definitions or constraint logic
- Weakened security checks (removed role checks, relaxed RLS policies)
If unacceptable differences exist, do **not** proceed. Investigate and resolve
with the user.
### 5. Verify locally before deleting
```bash
cd <absolute repo path> && supabase db reset
```
Run reset before verify — verify otherwise checks pre-replay state. Expected `DROP IF EXISTS` NOTICEs during reset are harmless: Lovable's duplicates run later in timestamp order than the originals.
An "already exists" failure on reset is a local timestamp-ordering artifact (original runs before duplicate locally; only the duplicate runs on Lovable Cloud) — not a bug in the duplicate; the FAIL-blocks-step-6 rule still applies to real logic errors (wrong predicates, missing DDL, weakened security checks).
Fix: delete the original (step 6) first, then re-run reset with only the duplicate present — never edit the duplicate to add DROP IF EXISTS guards, even as a harmless no-op, since it must match exactly what Lovable Cloud executed.
Once the reset completes, run your project's verify entry point inline:
```bash
cd <absolute repo path> && npm run verify # or pytest / make verify / etc.
```
If verify fails, diagnose from the output directly. Do not proceed to step 6
(delete originals) on FAIL.
### 6. Delete originals
**Guard against deleting a Lovable emit instead of a human original.** You are
deleting human-authored slug-named files, never the UUID-named files Lovable
emitted. For each path you pass to `git rm`, extract that filename's segment
between the first `_` and `.sql`; if it matches a UUID shape
(`^[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}$`), abort — the
file is a Lovable UUID emit, not a human original. Delete the human-authored
slug-named file instead, then wait for Lovable to re-emit.
```bash
git rm supabase/migrations/ORIGINAL_1.sql supabase/migrations/ORIGINAL_2.sql ...
```
Never manually restore a deleted emit. Re-adding it by hand races Lovable's own re-emit and produces duplicate UUID files. If an emit was deleted in error, delete the human original instead and let Lovable re-emit on its own.
### 7. Commit and PR
Create a branch, commit the deletions, push, and open a PR. The commit message
should reference which originals were replaced by which Lovable UUID files.
Versions
The database has no other skills named lovable-cloud-migration-sync.
Database snapshot: 13.11.2026 · package version 968dfaa519bb (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 86lovable-sync
Synchronize Lovable projects with GitHub safely. Use when pulling the latest main branch, checking GitHub/Lovable drift, initializing `.lovable-agent`, migrating the legacy Claude test workspace, or committing and pushing changes for Lovable two-way sync. - 91lovable
Read, create, edit, and deploy web apps and projects in Lovable. Use to turn a product brief into a working website or prototype, inspect existing project code, update pages and features, and publish changes through Lovable's official MCP server. - 100lovable-cloud-knowledge
Lovable's UI knowledge fields and workspace skill files — `.lovable/*.md` repo-mirror workflow, `.agents/skills/` propagation model, Project/Workspace scope split, precedence, review criteria. TRIGGER when: authoring or reviewing changes to `.lovable/*.md` or… - 96lovable-testing
Run and maintain Lovable Preview tests from Codex, Claude Code, or another Agent Skills runtime. Use for test-plan generation, smoke/changed/all runs, test workspace migration, preview token handling, or keeping tests synchronized with changed features. - 90lovable-cloud-edge-functions
Supabase edge function authentication, config.toml, and Lovable Cloud deployment. TRIGGER when: adding, modifying, or reviewing an edge function in a Lovable Cloud project, or modifying a file that configures one (e.g. supabase/config.toml) or invokes one (e.g. pg_cron). DO NOT… - 100lovable
Lovable (formerly GPT Engineer) is a browser-based AI app builder that turns a natural-language description into a working full-stack web app with a built-in backend, authentication, database and one-click publishing. Use when the user wants to prototype or ship a web app with…