# \#database **URL:** https://community.metabrainz.org/tag/database/5.md [Latest](https://community.metabrainz.org/latest.md) · [Categories](https://community.metabrainz.org/categories.md) · [Tags](https://community.metabrainz.org/tags.md) --- ## [Confused about tags vs. genres in the database](https://community.metabrainz.org/t/confused-about-tags-vs-genres-in-the-database/813680)
**Author:** [@AlbertDeTerre](https://community.metabrainz.org/u/AlbertDeTerre)\ **Replies:** 2\ **Last updated:** [November 5, 2025, 10:05pm UTC](https://community.metabrainz.org/t/confused-about-tags-vs-genres-in-the-database/813680 "2025-11-05T22:05:58Z")
Hi everyone, I’m trying to understand how tags and genres work in the MusicBrainz database. I noticed there’s a genre table linked to release\_group through l\_genre\_release\_group, but that link table only contains 9 row… --- ## [Release Type Error](https://community.metabrainz.org/t/release-type-error/811582)
**Author:** [@Anakor](https://community.metabrainz.org/u/Anakor)\ **Replies:** 3\ **Last updated:** [October 15, 2025, 4:20pm UTC](https://community.metabrainz.org/t/release-type-error/811582 "2025-10-15T16:20:03Z")
Name: Big Generator MBID: 435fa6ec-a874-43c2-ac17-13ee8fe980ac Label should be Atco Records. --- ## [How to identify cover art of release group PSQL DB?](https://community.metabrainz.org/t/how-to-identify-cover-art-of-release-group-psql-db/796651)
**Author:** [@AlbertDeTerre](https://community.metabrainz.org/u/AlbertDeTerre)\ **Replies:** 1\ **Last updated:** [September 15, 2025, 9:20pm UTC](https://community.metabrainz.org/t/how-to-identify-cover-art-of-release-group-psql-db/796651 "2025-09-15T21:20:37Z")
Hi everyone, I’m trying to figure out how to retrieve the cover art for a given release\_group directly from the MusicBrainz database. I saw that there’s a table called release\_group\_cover\_art, but it doesn’t seem to in… --- ## [Request to Add Official Genres to Stand High Patrol Artist and Our Own Way Release Group](https://community.metabrainz.org/t/request-to-add-official-genres-to-stand-high-patrol-artist-and-our-own-way-release-group/782003)
**Author:** [@LanaFox](https://community.metabrainz.org/u/LanaFox)\ **Replies:** 1\ **Last updated:** [August 10, 2025, 10:10am UTC](https://community.metabrainz.org/t/request-to-add-official-genres-to-stand-high-patrol-artist-and-our-own-way-release-group/782003 "2025-08-10T10:10:20Z")
Hello MusicBrainz community, I would like to request that the official genres dub, reggae, and electronic be added to both the artist Stand High Patrol (MBID: 6d6e26a8-e747-4a99-bdc7-ea73aa6a2bd4) and the release group O… --- ## [Pages numbers for Works included in an Edition, like in a natural TOC ?](https://community.metabrainz.org/t/pages-numbers-for-works-included-in-an-edition-like-in-a-natural-toc/757574)
**Author:** [@coolpisc](https://community.metabrainz.org/u/coolpisc)\ **Replies:** 1\ **Last updated:** [April 30, 2025, 3:06pm UTC](https://community.metabrainz.org/t/pages-numbers-for-works-included-in-an-edition-like-in-a-natural-toc/757574 "2025-04-30T15:06:53Z")
Am i the only one who feels that the database needs them? Was MusicBrainz lacking track lengths for the first decade of its existence? It’s such a natural way to represent 1) order of works inside a book 2) relative siz… --- ## [Mirror Server Search Broken](https://community.metabrainz.org/t/mirror-server-search-broken/743732)
**Author:** [@spongeboy](https://community.metabrainz.org/u/spongeboy)\ **Replies:** 2\ **Last updated:** [February 16, 2025, 7:37am UTC](https://community.metabrainz.org/t/mirror-server-search-broken/743732 "2025-02-16T07:37:51Z")
I just finished following the docker guide for setting up a mirror server, and everything is working except for search. When using indexed search through the API or web interface, it returns no results. Switching to dire… --- ## [Orange highlights not going away after pending edits are closed](https://community.metabrainz.org/t/orange-highlights-not-going-away-after-pending-edits-are-closed/540297)
**Author:** [@tigerman325](https://community.metabrainz.org/u/tigerman325)\ **Replies:** 10\ **Last updated:** [February 9, 2025, 12:40am UTC](https://community.metabrainz.org/t/orange-highlights-not-going-away-after-pending-edits-are-closed/540297 "2025-02-09T00:40:09Z")
I’m seeing instances where edits have closed, but they are still highlighted in orange. Release “Live at the BBC: The Collection” by The Beatles - MusicBrainz All recordings still orange. I had put in a merge edit for … --- ## [Artist recordings ordered by release date query](https://community.metabrainz.org/t/artist-recordings-ordered-by-release-date-query/735207)
**Author:** [@xeitor](https://community.metabrainz.org/u/xeitor)\ **Replies:** 1\ **Last updated:** [January 1, 2025, 9:04pm UTC](https://community.metabrainz.org/t/artist-recordings-ordered-by-release-date-query/735207 "2025-01-01T21:04:13Z")
hi there, I am working on a query to obtain all the recordings from a given artist ordered by release data. after examining the musicbrainz’s database scheme, I ended up with this query: WITH oldest\_release\_group AS ( … --- ## [Pulling Engineer, Producer and recording location data directly from the underlying musicbrainz database files](https://community.metabrainz.org/t/pulling-engineer-producer-and-recording-location-data-directly-from-the-underlying-musicbrainz-database-files/713497)
**Author:** [@audiomuze](https://community.metabrainz.org/u/audiomuze)\ **Replies:** 1\ **Last updated:** [September 10, 2024, 1:53pm UTC](https://community.metabrainz.org/t/pulling-engineer-producer-and-recording-location-data-directly-from-the-underlying-musicbrainz-database-files/713497 "2024-09-10T13:53:06Z")
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 mu… --- ## [Accessing data from the postgresql server](https://community.metabrainz.org/t/accessing-data-from-the-postgresql-server/711898)
**Author:** [@EatableAvacadoes](https://community.metabrainz.org/u/EatableAvacadoes)\ **Replies:** 4\ **Last updated:** [August 31, 2024, 2:23pm UTC](https://community.metabrainz.org/t/accessing-data-from-the-postgresql-server/711898 "2024-08-31T14:23:02Z")
I apologise in advance for the very simple question, I am very inexperienced in with databases. I have the PostgreSQL sever installed with docker compose, I am working with this data for a reserach paper. Would it be be… --- ## [How to handle what seems like duplications](https://community.metabrainz.org/t/how-to-handle-what-seems-like-duplications/711044)
**Author:** [@starlisa](https://community.metabrainz.org/u/starlisa)\ **Replies:** 1\ **Last updated:** [August 26, 2024, 3:38pm UTC](https://community.metabrainz.org/t/how-to-handle-what-seems-like-duplications/711044 "2024-08-26T15:38:41Z")
Looking at King Crimson (as an example), and Ian McDonald, an original member, in the l\_artist\_artist table, there are five separate links. Each of these links has two attribute tags, one being “original” and the other b… --- ## [Is there a table of locales?](https://community.metabrainz.org/t/is-there-a-table-of-locales/708079)
**Author:** [@starlisa](https://community.metabrainz.org/u/starlisa)\ **Replies:** 4\ **Last updated:** [August 26, 2024, 2:34pm UTC](https://community.metabrainz.org/t/is-there-a-table-of-locales/708079 "2024-08-26T14:34:14Z")
All of the alias tables have a locale, as opposed to an area. And I see that for some Japanese locales, it specifies the writing method. --- ## [Converting data to a sqllite3 database](https://community.metabrainz.org/t/converting-data-to-a-sqllite3-database/708651)
**Author:** [@EatableAvacadoes](https://community.metabrainz.org/u/EatableAvacadoes)\ **Replies:** 3\ **Last updated:** [August 11, 2024, 1:33pm UTC](https://community.metabrainz.org/t/converting-data-to-a-sqllite3-database/708651 "2024-08-11T13:33:00Z")
I need a fairly large sample (or the whole dataset, if possible) for some academic research and analysis. I first thought I should download the database dumps, however I do not know have a lot of knowledge with server a… --- ## [Release event country](https://community.metabrainz.org/t/release-event-country/706079)
**Author:** [@starlisa](https://community.metabrainz.org/u/starlisa)\ **Replies:** 1\ **Last updated:** [July 24, 2024, 2:48pm UTC](https://community.metabrainz.org/t/release-event-country/706079 "2024-07-24T14:48:49Z")
I see that release\_country and release\_unknown\_country give the release event information. But there’s no country table. There’s a country\_area table, but it only has a single field, which is area. Is that simply to join… --- ## [Releases, release groups, duplicates](https://community.metabrainz.org/t/releases-release-groups-duplicates/705840)
**Author:** [@starlisa](https://community.metabrainz.org/u/starlisa)\ **Replies:** 12\ **Last updated:** [July 23, 2024, 1:31am UTC](https://community.metabrainz.org/t/releases-release-groups-duplicates/705840 "2024-07-23T01:31:48Z")
I’m still trying to figure out exactly what the differences are between releases and release groups. Right now, I’m running into situations where there are two separate releases that appear to be the same. Same barcode, … --- ## [Release details](https://community.metabrainz.org/t/release-details/705850)
**Author:** [@starlisa](https://community.metabrainz.org/u/starlisa)\ **Replies:** 1\ **Last updated:** [July 22, 2024, 5:57pm UTC](https://community.metabrainz.org/t/release-details/705850 "2024-07-22T17:57:25Z")
I’m trying to find the sources in the database of the various pieces of information displayed on the webpages. For the release of “The Wall” found at Release “The Wall” by Pink Floyd - Details - MusicBrainz, the right h… --- ## [Length of recordings](https://community.metabrainz.org/t/length-of-recordings/705455)
**Author:** [@starlisa](https://community.metabrainz.org/u/starlisa)\ **Replies:** 1\ **Last updated:** [July 19, 2024, 4:31pm UTC](https://community.metabrainz.org/t/length-of-recordings/705455 "2024-07-19T16:31:26Z")
I’m unclear about how recording length is stored. Is it the number of milliseconds? --- ## [Fingerprint Database Download](https://community.metabrainz.org/t/fingerprint-database-download/619467)
**Author:** [@simonhopkin](https://community.metabrainz.org/u/simonhopkin)\ **Replies:** 3\ **Last updated:** [March 1, 2023, 10:33am UTC](https://community.metabrainz.org/t/fingerprint-database-download/619467 "2023-03-01T10:33:16Z")
I’m struggling to download the database dump files from https://data.acoustid.org. For example if I try to download the following file the connection fails after around 50mb: https://data.acoustid.org/fingerprint\_track… --- ## [Data fields in MusicBrainz artist\_credit file](https://community.metabrainz.org/t/data-fields-in-musicbrainz-artist-credit-file/615205)
**Author:** [@raywood](https://community.metabrainz.org/u/raywood)\ **Replies:** 1\ **Last updated:** [December 23, 2022, 12:54am UTC](https://community.metabrainz.org/t/data-fields-in-musicbrainz-artist-credit-file/615205 "2022-12-23T00:54:38Z")
I am looking at a file named artist\_credit, in a folder named mbdump, downloaded from MusicBrainz. This file appears to have seven data fields and no headers. The Schema map does not appear to show any artist\_credit file… --- ## [Artist\_credit and artist\_credit\_name in database schema](https://community.metabrainz.org/t/artist-credit-and-artist-credit-name-in-database-schema/608371)
**Author:** [@moyenin660](https://community.metabrainz.org/u/moyenin660)\ **Replies:** 3\ **Last updated:** [November 7, 2022, 4:11pm UTC](https://community.metabrainz.org/t/artist-credit-and-artist-credit-name-in-database-schema/608371 "2022-11-07T16:11:24Z")
Hi all, Could someone please describe what the entities artist\_credit and artist\_credit\_name are? What does each of their fields represent( in the same way primary entities and their fields are described)? (bonus point … --- ## [What table are external links in?](https://community.metabrainz.org/t/what-table-are-external-links-in/599193)
**Author:** [@mbnewb](https://community.metabrainz.org/u/mbnewb)\ **Replies:** 2\ **Last updated:** [August 30, 2022, 6:54am UTC](https://community.metabrainz.org/t/what-table-are-external-links-in/599193 "2022-08-30T06:54:51Z")
For an artist such as Megan Thee Stallion - Relationships - MusicBrainz, what table are those Wikidata, Wikipedia, etc., links actually stored in? Presumably they’re associated with the gid or the artist ID (1638056), bu… --- ## [Setting up MusicBrainz Database MIrror server alone without web and API service](https://community.metabrainz.org/t/setting-up-musicbrainz-database-mirror-server-alone-without-web-and-api-service/594854)
**Author:** [@imhans4305](https://community.metabrainz.org/u/imhans4305)\ **Replies:** 6\ **Last updated:** [August 12, 2022, 1:11pm UTC](https://community.metabrainz.org/t/setting-up-musicbrainz-database-mirror-server-alone-without-web-and-api-service/594854 "2022-08-12T13:11:51Z")
I am trying to setup musicbrainz database mirror server in my local machine. I was referring https://github.com/metabrainz/musicbrainz-docker for this and in the README, its suggested that If you want to mirror the Post… --- ## [Artist Works in music brainz website and database gives different result](https://community.metabrainz.org/t/artist-works-in-music-brainz-website-and-database-gives-different-result/595521)
**Author:** [@imhans4305](https://community.metabrainz.org/u/imhans4305)\ **Replies:** 2\ **Last updated:** [August 3, 2022, 5:23am UTC](https://community.metabrainz.org/t/artist-works-in-music-brainz-website-and-database-gives-different-result/595521 "2022-08-03T05:23:17Z")
I have setup musicbrainz database alone in my local machine. And when i search for a particular artist and work For example for the artist Snoop Dogg I am getting only 58 results. The query used is select artist.name, w… --- ## [Query based on portion of artist and work to get the complete matched name](https://community.metabrainz.org/t/query-based-on-portion-of-artist-and-work-to-get-the-complete-matched-name/595397)
**Author:** [@imhans4305](https://community.metabrainz.org/u/imhans4305)\ **Replies:** 1\ **Last updated:** [August 1, 2022, 7:16pm UTC](https://community.metabrainz.org/t/query-based-on-portion-of-artist-and-work-to-get-the-complete-matched-name/595397 "2022-08-01T19:16:13Z")
I am trying to create a query based on both artist and work of the artist. For example : If I use select \* from artist WHERE NAME::text ILIKE '%beethoven%'; it will return the list of artists whose name has “beethoven”… --- ## [Does 2×12" Vinyl have a medium format associated with it?](https://community.metabrainz.org/t/does-2x12-vinyl-have-a-medium-format-associated-with-it/593718)
**Author:** [@tangibletracks](https://community.metabrainz.org/u/tangibletracks)\ **Replies:** 3\ **Last updated:** [July 23, 2022, 1:01pm UTC](https://community.metabrainz.org/t/does-2x12-vinyl-have-a-medium-format-associated-with-it/593718 "2022-07-23T13:01:54Z")
I downloaded the data dumps and imported into Postgres, and what I have noticed is I can query by media id (31 for vinyl) just fine, but it skips over releases that are stated as 2×12" on the website. Does 2×12" Vinyl ha… --- ## [How to solve mbslave:command not found error](https://community.metabrainz.org/t/how-to-solve-mbslave-command-not-found-error/588391)
**Author:** [@jho88](https://community.metabrainz.org/u/jho88)\ **Replies:** 30\ **Last updated:** [June 20, 2022, 11:35am UTC](https://community.metabrainz.org/t/how-to-solve-mbslave-command-not-found-error/588391 "2022-06-20T11:35:39Z")
I want to find the quickest way to get a fully setup Core data database. I don’t need a server, just the core data itself. I’ve read through all the documents on the MusicBrainz site and believe the best solution is se… --- ## [How to get a list of unique songs from an artist](https://community.metabrainz.org/t/how-to-get-a-list-of-unique-songs-from-an-artist/589137)
**Author:** [@jho88](https://community.metabrainz.org/u/jho88)\ **Replies:** 11\ **Last updated:** [June 16, 2022, 10:32am UTC](https://community.metabrainz.org/t/how-to-get-a-list-of-unique-songs-from-an-artist/589137 "2022-06-16T10:32:59Z")
Hi, I’m looking to link one artist to a list of single instances of their songs. E.g. Led Zeppelin → Stairway to Heaven Going to California Battle of Evermore Kashmir Whole Lotta Love … If I go via the track table, … --- ## [Recording marked as having an "open edit" but actually not](https://community.metabrainz.org/t/recording-marked-as-having-an-open-edit-but-actually-not/567016)
**Author:** [@vzell](https://community.metabrainz.org/u/vzell)\ **Replies:** 3\ **Last updated:** [May 19, 2022, 9:09pm UTC](https://community.metabrainz.org/t/recording-marked-as-having-an-open-edit-but-actually-not/567016 "2022-05-19T21:09:40Z")
The following recording https://musicbrainz.org/recording/15b100bc-e536-4352-991c-8e4de82a5b0f is marked as having an “open edit” but actually doesn’t have one Could somebody confirm ? Thx… --- ## [Having a big problem with MusicBrainz database and Picard tagger, help please](https://community.metabrainz.org/t/having-a-big-problem-with-musicbrainz-database-and-picard-tagger-help-please/572346)
**Author:** [@newclassical](https://community.metabrainz.org/u/newclassical)\ **Replies:** 17\ **Last updated:** [March 17, 2022, 8:06am UTC](https://community.metabrainz.org/t/having-a-big-problem-with-musicbrainz-database-and-picard-tagger-help-please/572346 "2022-03-17T08:06:53Z")
Good morning, I am really hoping someone can help me with my problem, I’ve been spending the last few days trying to solve this but I feel stupid and hopeless. I don’t understand. I was so excited when I found Picard be… --- ## ["Original members" of a music act](https://community.metabrainz.org/t/original-members-of-a-music-act/537491)
**Author:** [@Almanackist](https://community.metabrainz.org/u/Almanackist)\ **Replies:** 3\ **Last updated:** [June 12, 2021, 5:01am UTC](https://community.metabrainz.org/t/original-members-of-a-music-act/537491 "2021-06-12T05:01:33Z")
Consider the data on members of King Crimson here: https://musicbrainz.org/artist/b38225b8-8e5f-42aa-bcdc-7bae5b5bdab3/relationships Or Blind Melon: https://musicbrainz.org/artist/38c5cdab-5d6d-43d1-85b0-dac41bde186e/… [Next page](https://community.metabrainz.org/tag/database/5.md?match_all_tags=true&page=1&tags%5B%5D=database)