(It might make sense for an admin to merge this into your earlier thread at https://community.metabrainz.org/t/converting-data-to-a-sqllite3-database/708651.)
I agree with the earlier comment that trying to get the data into SQLite will be a ton of work. It’ll be easier to just use PostgreSQL, especially if you already have it set up.
IIRC, you should be able to run something like this in your musicbrainz-docker checkout to get a psql prompt:
sudo docker-compose run musicbrainz psql postgres -U musicbrainz -h db
After that, you should be able to query it like you would any SQL database. There are a lot of pages online describing PostgreSQL-specific commands. A few from a search:
- PostgreSQL: Documentation: 7.0: psql
- Psql | Postgres Guide
- Top psql commands and flags you need to know | PostgreSQL
- https://www.commandprompt.com/education/postgresql-basic-psql-commands/
- etc.
If there’s something specific that you’re trying to do and having problems with, please describe it.