SQLPro for SQLite is the top SQLite editor for OS X.
Features
Automatic data reloading when the database gets modified externally.
Backwards compatibility with SQLite 2.
Version integration. Mucked your database? Rollback to a previous version.
Semiautomatic dependency resolution.
Column reordering.
Import or export your data in CSV, mySQL, XML, or JSON formats.
Export custom result sets to CSV, XML, or JSON.
Full-screen support.
Inline filters allowing you to customize the way your data is displayed.
What's new in version 2026.85
Fixed: a hang when opening very large SQL files. The editor's scroller workaround used to force full-document layout and could trip the watchdog on multi-MB files.
Fixed: a crash when "Copy as SQL update" was triggered on certain result sets (column metadata is now fetched off the main thread).
Fixed: alias-aware syntax highlighting after restoring a query from History (and inside the History preview).
Fixed: a SQLite crash on the auto-refresh path that could fire when external processes (Python, etc.) were inserting data into the database while the app had it open.
Does anyone of you by any chance has the last version before new logo and going to MAS.
Probably 1.0.64 I need it for my older machine and today when I clicked install I overwrite from MAS that older version :/
I use it mostly for reading SQLite files and not so much for writing, but so far it has always worked correctly. Previous versions of this app, when it had a different name, had some annoying bugs particularly in the user interface. But I have not seen any bugs in SQLPro for SQLite 1.0.109.