Phoenix will run migrations against whichever postgres database is configured via connection URL in its env vars.
PHOENIX_SQL_DATABASE_URL=postgresql://postgres:postgres@db:5432/postgres
Phoenix manages its own tables and schema by running migrations on boot. How do you plan on hosting your database? That can help inform setup details