Viewing Local SQLite Ghost Database

by Ian Grail

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.