---
title: Using SQLiteStudio with Studio
date: "2025-01-29"
author: "Birgit Pauli-Haack"
url: "https://icodeforapurpose.com/using-sqlitestudio-with-studio/"
categories: ["Studio"]
---

The WordPress.com developer docs provide under Studio> FAQs  the section on “[How can I manage the Studio site’s SQLite database?](https://developer.wordpress.com/docs/developer-tools/studio/frequently-asked-questions/#13-how-can-i-manage-the-studio-site-s-sqlite-database-)“. It lists the details of how to use SQLite tools with your Studio Site. I found them sufficient as they remove all barriers to be successful.

The database of each Studio site is located in the folder `wp-content/database` as a hidden file .ht.sqlite`.

Two ways are recommended for managing the SQLite database files on your computer: [SQLite3](#sql3) or [SQLiteStudio](#sqlstudio)

## sqlite3

sqlite3 is a command line tool and comes preinstalled on a Mac.

```
sqlite3 wp-content/database/.ht.sqlite
```

Although I am a fan of command line tools, for database handling I like to have a GUI and as my typing skills are not the best.

The screenshot shows you a list of usage hints after you invoke `sql3lite .ht.sqlite` from within the database folder of your Studio site and type “.help”.

![](https://icodeforapurpose.com/wp-content/uploads/2025/01/Screenshot-2025-01-29-at-18.20.21.png)

## SQLiteStudio

After a download of [SQLiteStudio](https://sqlitestudio.pl/) you might get a warning from Apple that it can’t verify the file, so it won’t open the installer. If that’s the case, got to your Settings > Security screen and scroll to section where it lists which file it blocked. You can click on Open Anyway to continue with the installation.

![](https://icodeforapurpose.com/wp-content/uploads/2025/01/Screenshot-2025-01-29-at-17.43.43.png)

After I successfully installed it, I opened it and with a drag and drop of the file  `/wp-content/database/.ht.sqlite` in the left sidebar, I was able to connect the SQLite Studio with the database from Studio.

In below video you see me clicking through some of the screens, to open a table, look at the data, or the structure, and then hover over some of the buttons. I also found the SQL editor I can use to create queries on the raw data.

		
		
### Like this:
Like Loading…