Quick Look Previews

Base provides Quick Look previews in the Finder.

Select a database file in the Finder and press the spacebar to show a preview of the tables, views, indexes and triggers in that file:

Indexes and triggers are listed under their parent table or view. Click the chrevron next to a table name to expand the list.

This image shows which icons correspond to each icon:

Note

The Quick Look preview has a limitation when previewing databases using the WAL journal mode due to a security feature in macOS called the App Sandbox.

Databases in WAL mode use multiple files to store your data. For example, database.sqlite3, when open, will have files next to it called database.sqlite3-wal and database.sqlite3-shm. The previewer doesn't have permission to open these files, only the main database file. This means that if you've recently made changes to the database, and those changes haven't been copied back into the main file yet, the preview won't show them.