# Editing the database

**URL:** <https://forums.plex.tv/t/editing-the-database/64064>\
**Category:** General Discussions\
**Created:** [April 19, 2014, 12:23pm UTC](https://forums.plex.tv/t/editing-the-database/64064 "2014-04-19T12:23:30Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![dunnieboy](https://avatars.discourse-cdn.com/v4/letter/d/41988e/32.png) [@dunnieboy](https://forums.plex.tv/u/dunnieboy)\
**Post date:** [April 19, 2014, 12:23pm UTC](https://forums.plex.tv/t/editing-the-database/64064/1 "2014-04-19T12:23:30Z")

</div>

Is there a backend tool for editing the database ? I mean stuff like genres etc. Since my media exists in more than one place I have multiple folders named comedy, drama etc. because that is how I organized the actual file locations. So browse by folder is pretty useless.

&nbsp;

The problem is there are WAY too many genres for browse by genre. How do you guys find yourselves browsing your media.&nbsp;

&nbsp;

I wish there was a better interface for organizing metadata like collections, genres etc.

&nbsp;

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\
**Post date:** [April 19, 2014, 12:35pm UTC](https://forums.plex.tv/t/editing-the-database/64064/2 "2014-04-19T12:35:28Z")

</div>

> Is there a backend tool for editing the database ? I mean stuff like genres etc. Since my media exists in more than one place I have multiple folders named comedy, drama etc. because that is how I organized the actual file locations. So browse by folder is pretty useless.
> 
> The problem is there are WAY too many genres for browse by genre. How do you guys find yourselves browsing your media.&nbsp;
> 
> I wish there was a better interface for organizing metadata like collections, genres etc.

I found it is always better to edit tags on source files using third party products. For music it would be product like mp3tag.&nbsp;

Suggest doing a google search. For example a simple search without even mentioning the word plex in the search unearthed [PlexEditor tool&nbsp;](https://forums.plex.tv/topic/44777-plexeditor-for-windows/)

This was just by doing search: "editing metadata for movies genres"

---

<div class="post-metadata">

**Author:** ![faidwen2](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/faidwen2/32/4353_2.png) [@faidwen2](https://forums.plex.tv/u/faidwen2)\
**Post date:** [April 20, 2014, 2:38am UTC](https://forums.plex.tv/t/editing-the-database/64064/3 "2014-04-20T02:38:35Z")

</div>

I use SQLiteStudio to modify the Plex databases and tables directly. &nbsp;But I would be very cautious.

---

<div class="post-metadata">

**Author:** ![reallistic](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/reallistic/32/5677_2.png) [@reallistic](https://forums.plex.tv/u/reallistic)\
**Post date:** [September 24, 2014, 2:30pm UTC](https://forums.plex.tv/t/editing-the-database/64064/4 "2014-09-24T14:30:56Z")

</div>

> I use SQLiteStudio to modify the Plex databases and tables directly. But I would be very cautious.

  
Where are these database files have you modified located?  
  
  
Sent from my iPhone using Tapatalk

---

<div class="post-metadata">

**Author:** ![jmckee](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/jmckee/32/8332_2.png) [@jmckee](https://forums.plex.tv/u/jmckee)\
**Post date:** [September 25, 2014, 3:56am UTC](https://forums.plex.tv/t/editing-the-database/64064/5 "2014-09-25T03:56:23Z")

</div>

> Where are these database files have you modified located?  
>   
>   
> Sent from my iPhone using Tapatalk

Depends on the OS of the server.

On my windows server they are at:

C:\Users\\AppData\Local\Plex Media Server\Plug-in Support\Databases

The main db is&nbsp;com.plexapp.plugins.library.db

---

<div class="post-metadata">

**Author:** ![jalarab](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/jalarab/32/2322_2.png) [@jalarab](https://forums.plex.tv/u/jalarab)\
**Post date:** [December 12, 2016, 4:57am UTC](https://forums.plex.tv/t/editing-the-database/64064/6 "2016-12-12T04:57:39Z")

</div>

someone knows where are the database for Plex Cloud?

---

<div class="post-metadata">

**Author:** ![Elijah\_Baley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elijah_baley/32/10336_2.png) [@Elijah\_Baley](https://forums.plex.tv/u/Elijah_Baley)\
**Post date:** [December 12, 2016, 5:10am UTC](https://forums.plex.tv/t/editing-the-database/64064/7 "2016-12-12T05:10:26Z")

</div>

> @jalarab said:  
> someone knows where are the database for Plex Cloud?

As far as I know you cannot directly edit the database for Plex cloud. You can download them from:  
[https://plex.tv/users/cpms](https://plex.tv/users/cpms)  
Then you can view them but there is no access to the database.

---

<div class="post-metadata">

**Author:** ![jalarab](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/jalarab/32/2322_2.png) [@jalarab](https://forums.plex.tv/u/jalarab)\
**Post date:** [December 12, 2016, 11:27am UTC](https://forums.plex.tv/t/editing-the-database/64064/8 "2016-12-12T11:27:39Z")

</div>

What a shame. I have several collections that I want to use in Plex cloud, but is too much work to build it manually. I have some phyton scripts to update it, hopefully I can direct edit the database in a near future.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [December 21, 2019, 1:54am UTC](https://forums.plex.tv/t/editing-the-database/64064/9 "2019-12-21T01:54:07Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
