# Database type and file location **URL:** \ **Category:** General Discussions\ **Created:** [May 16, 2017, 9:10pm UTC](https://forums.plex.tv/t/database-type-and-file-location/192230 "2017-05-16T21:10:02Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![ttrenchj2](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@ttrenchj2](https://forums.plex.tv/u/ttrenchj2)\ **Post date:** [May 16, 2017, 9:10pm UTC](https://forums.plex.tv/t/database-type-and-file-location/192230/1 "2017-05-16T21:10:02Z")
Hi. What is the database type (and can it be converted to an MS Access, Excel, or txt file format for manipulation?) and what is the Windows file explorer path to the database location? Thanks, ttrenchj ---
**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:** [May 16, 2017, 9:22pm UTC](https://forums.plex.tv/t/database-type-and-file-location/192230/2 "2017-05-16T21:22:12Z")
SQLite no [https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database](https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database) ---
**Author:** ![ttrenchj2](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@ttrenchj2](https://forums.plex.tv/u/ttrenchj2)\ **Post date:** [May 19, 2017, 12:14am UTC](https://forums.plex.tv/t/database-type-and-file-location/192230/3 "2017-05-19T00:14:32Z")
> @OttoKerner said: > SQLite > > no > > [https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database](https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database) @OttoKerner: I’m not familiar with SQLite specifically. Would I be able to modify the com.plexapp.plugins.library.db using SQLite? ---
**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:** [May 19, 2017, 11:30am UTC](https://forums.plex.tv/t/database-type-and-file-location/192230/4 "2017-05-19T11:30:57Z")
In theory, yes. But you need to know how the tables in the DB interact with each other, or you may bring your db into an inconsistent state. I advise you to check out this tool and its source code to get some insight: > **[MovieFan's Database Tool for Plex](https://forums.plex.tv/discussion/120292/moviefans-database-tool-for-plex/p1#top)** > > Update 4/14/2015   - Change added\_at date routine now located in Library sub-routine.  Can now be done on a per library basis. - Added Find Unmatched feature.  This will identify media on your system not matched up in Plex.   ... and maybe this thread as well: > **[\[HowTo\] Plex database modification - Moving media the right/wrong way](https://forums.plex.tv/discussion/comment/1080551/#Comment_1080551)** > > Ok, wow! That was surprisingly easy. Everything seems to be working GREAT! So just so it’s clear. Following my instructions will likely mess up your Library. But it worked wonders for me. AND it is SO easy. Easier than following the nuanced... ---
**Author:** ![ttrenchj2](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@ttrenchj2](https://forums.plex.tv/u/ttrenchj2)\ **Post date:** [May 19, 2017, 7:54pm UTC](https://forums.plex.tv/t/database-type-and-file-location/192230/5 "2017-05-19T19:54:16Z")
> @OttoKerner said: > In theory, yes. > But you need to know how the tables in the DB interact with each other, or you may bring your db into an inconsistent state. > > I advise you to check out this tool and its source code to get some insight: > [https://forums.plex.tv/discussion/120292/moviefans-database-tool-for-plex/p1#top](https://forums.plex.tv/discussion/120292/moviefans-database-tool-for-plex/p1#top) > > and maybe this thread as well: > [https://forums.plex.tv/discussion/comment/1080551/#Comment\_1080551](https://forums.plex.tv/discussion/comment/1080551/#Comment_1080551) @OttoKerner: Thank you. ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [January 7, 2020, 11:16pm UTC](https://forums.plex.tv/t/database-type-and-file-location/192230/7 "2020-01-07T23:16:22Z")