SQLite (and SQL) Viewer

• Quick Look SQLIte: .sqlite, .sqlite3, .db: plus .sql scripts and dumps
• Open in the app to browse the data, sort/filter the columns
• Adjustable column display
• View the schema

SQLite is the most widely deployed database in the world and it turns up everywhere: app data, Core Data stores, exports, browser history, IoT logs. On a Mac, a .sqlite or .db file is a blank icon and a trip to the terminal.

Fast SQLite Viewer opens them instantly. A sidebar lists tables and views, the grid pages lazily so million-row tables scroll smoothly, and you can sort by any column and filter across the whole table. The schema inspector shows columns, types, keys and indexes. Thumbnails and Quick Look show real data, so you can tell which database is which without opening any of them.

It is strictly read-only - the database is opened with SQLite's immutable flag, which means no lock files, no journal or WAL sidecars created next to your data, and no possibility of this app modifying a file.

Generic .db files are magic-checked, so it will tell you politely when a file is not actually SQLite rather than showing you nonsense.

SQLite Pro adds an entity relationship diagram drawn from the schema, schema SQL export, and CSV export of any table or all of them.

Demo

Pro Features (available as IAP from Mac App Store)

• Schema view and export
• CREATE schema and data export to CSV and SQL
• ER Diagrams
• GeoPackage - MapKit integration
• ... more!

Requirements

Universal binary, so it runs on both Intel and Apple Silicon Macs.

• macOS 14 (Sonoma) or later
• Intel Mac or Apple Silicon (M1 or newer)

Installation

Download the file, unzip it, and copy it into your Applications folder. Open it once and it registers the Quick Look handler itself. Instructions are included with the download.

Apps downloaded here are signed by Apple, so you shouldn't see any Gatekeeper warnings.

Licence

What you may do: install and use the software, at no cost, on any Mac you own or control, for personal or business purposes.

What you may not do: sell, rent, lease, sublicense or otherwise charge anyone for the software; redistribute, repackage, bundle or host it for download (please point people at the official download page instead); or modify, adapt, translate, reverse-engineer, decompile or disassemble it, except to the limited extent applicable law expressly permits.

The software is licensed, not sold. All rights not expressly granted above are reserved by the copyright holder, who may offer future or paid versions under different terms.

Privacy

100% on-device. No accounts, no tracking, never connects to the internet, collects no data whatsoever.

Feedback

Please contact me with any feedback, issues, suggestions or requests!