Also, is there an API or CLI mechanism to get connection details for the warehouse DB (sqlite or pgsql) so that I can connect to it from an external tool?

From the top of my head, if you are using for example `target-postgres`:

meltano config target-postgres

Will give you all your connection settings as json

ah, great, thanks!

meltano config --format env target-postgres > .env

if you want that as a .env and not as a json file

ah nice thanks!