Improve database migration traceability and drift detection

[AnnabelJoe]

Category: Backlog

Description: Improve database migration traceability and drift detection.

Note: recreated without labels after earlier label errors.

[devcarole]

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

GM maintainer, I would like to work on this issue

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