Make sure you’re not using H2 as the internal database, but something like Postgres or MariaDB/MySQL:
https://www.metabase.com/docs/latest/operations-guide/start.html#migrating-from-using-the-h2-database-to-mysql-or-postgres
Then access that database and use some of the excellent queries that Andrew has put together:
Metabase Metadata SQL