Whilst I tag all new albuns using Picard and also contribute release metadata to MusicBrainz my music collection is extensive and a lot of it was tagged in years prior to Picard.
With Lyrion now supporting browsing a music collection by virtually any tag I would like to enrich my existing metadata by adding producer, engineer and recording location metadata to the rest of my music collection, without going through Picard.
I already have all my metadata relating to all files in my library stored in a sqlite table and have written and used a series of enrichment routines (e.g. adding MBIDs for all artists, standardising artist names etc.) by querying the relevant table(s) directly from a download of the MusicBrainz database.
My question is where in the schema do engineer, producer and recording location reside - I don’t see any of them in the database schema: MusicBrainz Database / Schema - MusicBrainz
They do exist e.g. https://musicbrainz.org/release/1a8c4ac3-6f47-4570-aedb-f1928a0498ea and I’d like to pull it and incorporate it into my file based metadata.
Any pointers much appreciated.