CI: backend tests run without running DB migrations or provisioning a database

[Cedarich]

Problem
CI workflows do not run database migrations or provide a database service before running backend integration/e2e tests. This leads to failing tests or false negatives in CI.

Evidence

• Repo contains Rust/TypeScript backend and database-related SQL/PLpgSQL files; no CI workflow for migrations detected.

How to reproduce

1. Run backend test pipeline in a fresh environment without DB migrations — tests fail or are skipped.

Suggested fix

• Add a postgres service to CI workflow and run migrations (e.g., prisma migrate deploy or Diesel migrations) before tests.
• Use a test DB URL injected via environment variables and secret management.

Files to check

• .github/workflows/**
• backend/migrations or prisma/
• ci scripts

[omosvico]

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

Hi maintainer, can this task be assigned to me?

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

[Emelie-Dev]

@Emelie-Dev has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi, I would love to work on this issue

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

[sublime247]

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

would love to work on this

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

[drips-wave]

Congratulations, @Emelie-Dev! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

🧑‍💻 @Emelie-Dev: 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 🌊

[Bidex-cmyk]

@baedboibidex-cmyk has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

i will love to work on this issue please assign me

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

[egwujiohaifesinachiperpetual-max]

@egwujiohaifesinachiperpetual-max has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Please assign
ETA is 4 hours

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