Comment by bicijay

Don't overthink unless you really need it.

Use a single database and RLS + session id to ensure queries already come filtered for that tenant without the need to add "where tenant_id = ?" around the application layer.