Viewing Local SQLite Ghost Database

If you are doing some local Ghost Core development, or are simply curious what is happening to your Ghost data under the hood: There is a quick and easy way to visualize and browse your local Ghost database (or any SQLite .db files).

1. Download and install a SQLite DB Browser

Here is a cross-platform open-source option: http://sqlitebrowser.org/

2. Open Ghost's .db file

• Launch your SQLite Browser and click on "Open Database".
• Select the ghost-dev.db file found inside of your local ghost install i.e.:

ghost-0.7.1/content/data/ghost-dev.db

3. You are in business!

You can select the table you want to view from the drop down. Below is a screen shot of my posts table.