Postgres schema migration idempotency tests

[Miracle656]

Background

A migration that fails halfway leaves prod in a wedged state. Up/down idempotency proofs guard against this.

What to build

Tests that run every migration up, then down, then up again, asserting schema-hash stability.

Key files

• tests/integration/migrations.test.ts (new)

Acceptance criteria

• All current migrations pass
• CI runs it on every PR

Drips Wave · Complexity: Intermediate · 150 points

[Geff115]

@Geff115 has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi maintainer,

I would like to work on this issue. Please assign this to me.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Geff115 to this issue.

[amina69]

@amina69 has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

hi, let me work on this.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @amina69 to this issue.

[drips-wave]

Congratulations, @amina69! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 2, 2026.

🧑‍💻 @amina69: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊