# Is there a standalone plex sqlite tool?

**URL:** <https://forums.plex.tv/t/is-there-a-standalone-plex-sqlite-tool/804446>\
**Category:** Metadata & Adding Files\
**Tags:** server-windows\
**Created:** [August 14, 2022, 1:43pm UTC](https://forums.plex.tv/t/is-there-a-standalone-plex-sqlite-tool/804446 "2022-08-14T13:43:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![doncaruana](https://avatars.discourse-cdn.com/v4/letter/d/f6c823/32.png) [@doncaruana](https://forums.plex.tv/u/doncaruana)\
**Post date:** [August 14, 2022, 1:43pm UTC](https://forums.plex.tv/t/is-there-a-standalone-plex-sqlite-tool/804446/1 "2022-08-14T13:43:58Z")

</div>

I’d like to be able to edit a copy of the database on my windows machine and plex itself is running on ubuntu. But the windows-based tool in the install requires the server to be running. Is there a standalone tool available anywhere?

---

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [August 14, 2022, 1:53pm UTC](https://forums.plex.tv/t/is-there-a-standalone-plex-sqlite-tool/804446/2 "2022-08-14T13:53:16Z")

</div>

> [@doncaruana](#):
>
> But the windows-based tool in the install requires the server to be running

Not so, in fact it’s STRONGLY recommended to shut down PMS before using the tool

Ref: [https://support.plex.tv/articles/repair-a-corrupted-database/#toc-2](https://support.plex.tv/articles/repair-a-corrupted-database/#toc-2)

---

<div class="post-metadata">

**Author:** ![doncaruana](https://avatars.discourse-cdn.com/v4/letter/d/f6c823/32.png) [@doncaruana](https://forums.plex.tv/u/doncaruana)\
**Post date:** [August 14, 2022, 2:01pm UTC](https://forums.plex.tv/t/is-there-a-standalone-plex-sqlite-tool/804446/3 "2022-08-14T14:01:00Z")

</div>

My actual plex server is running on ubuntu. What I was working on was making a copy of that database and putting it on windows and working on it there - so I would not be working on a live copy anyway.

But, as it turns out, after firing up the first time and subsequently shutting down, now I can run sqlite without it needing to run the full blown PMS on my windows machine.

---

<div class="post-metadata">

**Author:** ![doncaruana](https://avatars.discourse-cdn.com/v4/letter/d/f6c823/32.png) [@doncaruana](https://forums.plex.tv/u/doncaruana)\
**Post date:** [August 14, 2022, 3:46pm UTC](https://forums.plex.tv/t/is-there-a-standalone-plex-sqlite-tool/804446/4 "2022-08-14T15:46:42Z")

</div>

Once I proved everything out on Windows, I was able to change the added\_at date of over 200 movies from my dvd collection super quickly via ssh to my ubuntu server. Magic! 😀

---

<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:** [November 12, 2022, 3:47pm UTC](https://forums.plex.tv/t/is-there-a-standalone-plex-sqlite-tool/804446/5 "2022-11-12T15:47:05Z")

</div>

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