The CONTRIBUTING.md does not describe how to add a new migration, run the test suite with a local database, or update sqlx offline metadata

[Lost-Z]

Summary

CONTRIBUTING.md covers basic dev setup but omits three critical workflows for contributors: (1) how to create a new database migration and update the .sqlx offline metadata, (2) how to run the Postgres-backed tests that are marked #[ignore] by default, and (3) how to update the contract_summaries trigger or other schema objects and verify the change. A contributor unfamiliar with SQLx will spend significant time discovering these workflows.

Expected Behavior

CONTRIBUTING.md should document the full workflow for schema changes and database-backed testing.

Proposed Solution

Add a Database changes section to CONTRIBUTING.md covering:

• How to create a new migration file (sqlx migrate add <name>)
• How to apply it locally (cargo run -p lumenqraph-indexer)
• How to regenerate .sqlx offline metadata (cargo sqlx prepare)
• How to run the ignored Postgres-backed tests (TEST_DATABASE_URL=... cargo test -- --ignored)

Affected Files

• CONTRIBUTING.md

[Obaara293]

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

Hi maintainer, I've reviewed the issue and I've recognized the solution, kindly assign this to me to get the best result.

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

[Emzux]

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

Hello Maintainer, I’ve looked through the task and I’m available to take it on.

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

[pepkodex56]

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

Hi Maintainer! I’m interested in contributing to this task and can ensure timely delivery with clean implementation.

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

[Adotse10066]

@Adotse10066 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. I deliver high impact solutions, ensuring seamless workflow and client satisfaction

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

[bested4lyf-lang]

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

Hi Maintainer, I’ve reviewed the contributor workflow gaps and can document the complete database-change process clearly, including migrations, SQLx offline metadata, local Postgres tests, and schema/trigger verification. I’ll keep the guidance consistent with the project’s existing setup so contributors can follow it without additional guesswork. I’d be happy to take this on.

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

[Oluwatomilola]

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

I would love to fix this issue, kindly assign.

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

[williamsokperez-arch]

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

id love to work on this issue

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

[drips-wave]

Congratulations, @williamsokperez-arch! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @williamsokperez-arch: 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 🌊

[drips-wave]

This issue has been completed by @williamsokperez-arch as part of the Stellar Wave Program's 8th Wave 🥳

😎 @williamsokperez-arch: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.