# Plex 9 DB Schema
**URL:** https://forums.plex.tv/t/plex-9-db-schema/5049
**Category:** Dev/API Corner
**Tags:** other-dev
**Created:** [September 7, 2010, 1:56pm UTC](https://forums.plex.tv/t/plex-9-db-schema/5049 "2010-09-07T13:56:59Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@vdubeau](https://forums.plex.tv/u/vdubeau)
#### Post date: [September 7, 2010, 1:56pm UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/1 "2010-09-07T13:56:59Z")
Any chance of finding the DB schema somewhere?
---
### Author:  [@mkh](https://forums.plex.tv/u/mkh)
#### Post date: [September 7, 2010, 2:28pm UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/2 "2010-09-07T14:28:24Z")
You can find the media databases here
~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases
---
### Author:  [@sansnipple](https://forums.plex.tv/u/sansnipple)
#### Post date: [September 7, 2010, 7:02pm UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/3 "2010-09-07T19:02:53Z")
however, it is now an pretty bad idea to directly mess with the sqlite database. there are several new abstraction layers on top of the db, and trying to interact with the raw sqlite is just asking for trouble. you should interact with the library through either the plex media server http/xml api, or the plex media scanner command line interface. the new smart library backend is extremely complex and no longer just a simple dumb db, dont mess with the sql.
---
### Author:  [@mkh](https://forums.plex.tv/u/mkh)
#### Post date: [September 7, 2010, 9:50pm UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/4 "2010-09-07T21:50:15Z")
Then some doc on the API would be nice 😃
---
### Author:  [@mkh](https://forums.plex.tv/u/mkh)
#### Post date: [September 9, 2010, 10:04am UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/5 "2010-09-09T10:04:32Z")
I like the fact that dev people keep saying dont do this and dont do that
well, then bring us some infomation on the API’s…
jeezz
---
### Author:  [@atrus](https://forums.plex.tv/u/atrus)
#### Post date: [September 9, 2010, 11:32am UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/6 "2010-09-09T11:32:14Z")
> [@](#):
>
> I like the fact that dev people keep saying dont do this and dont do that
>
> well, then bring us some infomation on the API's...
>
> jeezz
Chill man. Either the devs fix the major bugs or they create the documentation, at the moment the choice is pretty clear at least for me.
---
### Author:  [@TMwNN](https://forums.plex.tv/u/TMwNN)
#### Post date: [October 3, 2010, 5:00am UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/7 "2010-10-03T05:00:08Z")
I’d like to see a little stand-alone python code on how to retrieve meta-information from the database.
I want to make some utilities to do things; like show movies that weren’t scraped for some reason, etc.
---
### Author:  [@hrcolb0](https://forums.plex.tv/u/hrcolb0)
#### Post date: [October 12, 2010, 11:00pm UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/8 "2010-10-12T23:00:04Z")
> [@](#):
>
> I'd like to see a little stand-alone python code on how to retrieve meta-information from the database.
>
> I want to make some utilities to do things; like show movies that weren't scraped for some reason, etc.
are you talking about movies that haven't been scanned? Would those movies even be in the database? Or are you talking about movies that do show up in Plex media manager but that don't find a match with freebase so that no metadata information is filled in?
---
### Author:  [@system](https://forums.plex.tv/u/system)
#### Post date: [December 20, 2019, 8:44pm UTC](https://forums.plex.tv/t/plex-9-db-schema/5049/9 "2019-12-20T20:44:32Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.