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:

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.:


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.

About Author: Ian Grail
Ian Grail

Software Developer. Aspiring Pool Lounger.