Homebrew upgraded to 6.0 - and now the database is gone

It seems likely that you were using a custom folder location for your databasepath.

I suggest opening in the recent-files-gramps.xml file (in your Gramps User Directory) for the path of the last successfully opened tree.

See Database Locked - use force-unlock option - #11 by emyoulation