Installing and using DB Browser for SQLite

Downloading the software

1. Go to sqlitebrowser.org/dl.

2. Find the appropriate download link for your machine/operating system, and download and install that version of DB Browser for SQLite.

   • If you have a Mac, you should either:

     • Download the provided Mac .dmg file and double-click on the file, which will open up a window. Then drag the application’s icon to your Applications folder.

     • Follow the provided instructions on how to use HomeBrew to install the application.

   • If you have a Windows machine, you should download the Standard installer for 64-bit Windows (which is an .msi file). Double-click on the file to run the installer. You should be able to use all of the default options.

   • If you are unable to install DB Browser on your own machine, you can use it on the virtual desktop.

Using the software

1. Launch the program.

2. Click the Open Database button, and find and open the appropriate database file. (One option: our university database from lecture: university.sqlite)

3. To explore the schema of the database, click on the Database Structure tab, and then click on the arrows to the left of the table names.

4. To explore the contents of the tables, click on the Browse Data tab, and then choose the appropriate table from the drop-down menu.

5. Use the Execute SQL tab to perform queries on the database. Enter your SQL command in the space provided, and press F5 or Ctrl-R to run it. (There is also a small button that you can click; it has a triangular shape that looks like the Play button of a music player.)

Last updated on January 31, 2026.