# SQLite Metadata Query

**URL:** <https://forums.plex.tv/t/sqlite-metadata-query/942800>\
**Category:** Plex Media Server\
**Tags:** server-linux, other-dev, metadata\
**Created:** [September 12, 2026, 6:19pm UTC](https://forums.plex.tv/t/sqlite-metadata-query/942800 "2026-09-12T18:19:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![weasel5i2](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/weasel5i2/32/97517_2.png) [@weasel5i2](https://forums.plex.tv/u/weasel5i2)\
**Post date:** [September 12, 2026, 6:19pm UTC](https://forums.plex.tv/t/sqlite-metadata-query/942800/1 "2026-09-12T18:19:56Z")

</div>

Hello,

I was just wondering if anyone has a handy answer as to what query I would need to perform in order to list all the media items in each library which have NO Tags defined. I’m sure there’s a useful INNER JOIN multi-table query which would provide this information, I’m just not as familiar with the schema as I’d like to be.

Thanks in advance if anyone can help me out!

Regards,

weasel5i2

---

<div class="post-metadata">

**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\
**Post date:** [September 12, 2026, 8:19pm UTC](https://forums.plex.tv/t/sqlite-metadata-query/942800/2 "2026-09-12T20:19:07Z")

</div>

What kind of tags are you talking about?

---

<div class="post-metadata">

**Author:** ![mans](https://avatars.discourse-cdn.com/v4/letter/m/439d5e/32.png) [@mans](https://forums.plex.tv/u/mans)\
**Post date:** [September 12, 2026, 8:31pm UTC](https://forums.plex.tv/t/sqlite-metadata-query/942800/3 "2026-09-12T20:31:14Z")

</div>

Are you able to import the db into something like dbeaver? Then the primary keys should join across tables after import on the database view in dbeaver, then query. If I may ask, what are you trying to find? Whats the goal here?