Hi everyone,

I’m migrating a multi-tenant app from Node/Golang to Phoenix/Elixir. Here’s how our data is set up:

• Each tenant has a separate MongoDB database (tenant_${tenant_id}).
• There’s a master DB with metadata about tenants.
• We don’t use schema validation—collections are schema-less and structure is only enforced by the application.

In my old stack, I could connect to any tenant’s DB as needed. In Elixir, I see the mongodb_driver requires the DB name when starting the connection/pool, usually at app boot.

My main questions:

• How do Elixir/Phoenix apps usually handle selecting and connecting to the correct tenant database at runtime?
• Is it common to start a connection pool per tenant, or are there better patterns for this?
• Any advice, examples, or “gotchas” from folks who have done this before?

Appreciate any guidance or sample code. Thanks in advance!