[Chore] Add multi-database architecture for testing

[alexjustesen]

📃 Description

Half-baked thought but it stems from https://bsky.app/profile/jbrooks.uk/post/3ldjrdggw4s2s conversation.

[svenvg93]

For testing the GH Actions locally https://github.com/nektos/act