lovable-cloud-migration-sync
/lovable-cloud-migration-sync
Porządkuje migracje zduplikowane przez Lovable po ich zastosowaniu: porównuje oryginały, wykonuje db reset, usuwa duplikaty i otwiera pull request.
- Autor
- jcdendrite ↗
- Repozytorium
- claude-config ↗
- Licencja
- MIT
- Ostatnia zmiana repozytorium
- 27.10.2026
Ocena i bezpieczeństwo
- Pliki w paczce
- 1
- Skrypty
- 0
- Komentarze HTML
- 0
- Adresy URL w SKILL.md
- 0
Brak sygnałów. Repozytorium zmienione 27.10.2026, bez odwołań do wycofanych modeli i API.
MIT, otwarta: można używać i zmieniać, z zachowaniem informacji o autorze.
Co robi i kiedy
Porządkuje migracje zduplikowane przez Lovable po ich zastosowaniu: porównuje oryginały, wykonuje db reset, usuwa duplikaty i otwiera pull request.
Oryginalny opis (EN)
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.
Jak działa
- Procedure
Podgląd SKILL.md
---
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.
Wersje
W bazie nie ma innych skilli o nazwie lovable-cloud-migration-sync.
Migawka bazy z 13.11.2026 · wersja paczki 968dfaa519bb (skrót SHA-256 całej paczki)
Pobrania w ostatnich 30 dniach: 0 · ranking
Zgłoś problem z tym skillem: szkodliwa treść, błędny opis albo prośba autora o usunięcie.
Podobne skille
- 86lovable-sync
Bezpiecznie synchronizuje projekt Lovable z GitHubem: pobiera najnowszą gałąź główną, sprawdza rozbieżności i wysyła zmiany. - 91lovable
Czyta, tworzy i wdraża aplikacje webowe w Lovable: zamienia opis produktu w prototyp, aktualizuje strony i publikuje zmiany. - 100lovable-cloud-knowledge
Opisuje pola wiedzy w interfejsie Lovable i pliki skilli obszaru roboczego, w tym lustro .lovable/*.md, propagację .agents/skills/, zakres projektu i obszaru oraz kryteria przeglądu. - 96lovable-testing
Uruchamia i utrzymuje testy podglądu Lovable: generuje plany testów, puszcza je i synchronizuje z funkcjami. - 90lovable-cloud-edge-functions
Pilnuje uwierzytelniania i konfiguracji funkcji brzegowych Supabase w projektach Lovable Cloud, w tym pliku config.toml i wywołań pg_cron. - 100lovable
Pomaga pracować z Lovable, przeglądarkowym kreatorem aplikacji AI: skuteczne prompty, połączenie z Supabase lub GitHub, przegląd reguł bezpieczeństwa i przeniesienie projektu do własnego edytora.