SQLPro for SQLite is an advanced sqlite editor. It has an easy to navigate interface, with the ability to perform the most basic to advanced tasks.
+ Syntax highlighting and query intellisense/auto-complete.
+ Advanced multi-query execution.
+ Pick from multiple included themes, or design your own.
+ Automatic external change detection reloads a database when modified outside of SQLPro.
+ Version integration. Mucked your database? Rollback to a previous version.
+ Runtime loadable extension support.
+ Semiautomatic dependency resolution.
+ Export your data to csv, mysql, xml or json.
+ Backwards compatibility with SQLite 2.
+ Fullscreen support.
+ Column reordering.
+ Inline filters allowing you to customize the way your data is displayed.
If you have any issues with this application, please see our support forum: https://sqlitepro.com/forum or send us a message on Twitter: @SQLProApp.
This product is an independent management tool for SQLite.
SQLPro for SQLite is not affiliated or endorsed by the SQLite development team.
+ Fixed query execution keyboard shortcut always requiring shift.
+ Fixed an issue where the data tab may sometimes display duplicate columns.
+ Fixed an issue with creating new SQLite documents.
Ratings and Reviews
Reloading Database is infuriating!!!!
OMG, it just did it while I'm typing this. Whenever there's a change in the database, it brings the window forward.
I had a two DBs open in separate windows. One much more active than the other. When I was using the less active DB window, the other one kept bringing itself forward, making it nearly impossible for me to do what I needed.
On top of that, the entire window becomes completely locked whenever it's in that loading mode. So, good luck if you're trying to write a query or something with an active DB open.
In Preferences, you can disable "Reload database on external changes" but toggling that doesn't seem to have any effect. It still keeps reloading itself every few seconds.
This is the only app I've found so far that checks off pretty much every requirement I have for a sqlite GUI, so I'd really like to keep using it, but this "reloading database" nonsense is getting tiresome.
Does what’s on the tin, but leaves me wanting
To inspect and manage SQL databases this app works great. The “reloading database” feature holds this app back the most:
- When the DB changes, the app pops itself up and says “reloading database”. Pops itself up from the bottom of my window stack to just behind my foremost window—still very visually distracting.
- While it’s “reloading database” the app is completely hung: can’t keep working on my SQL query; can’t resize the window; completely hung.
- You can turn this feature off; but it will run all your SQL queries against a cached version of the database instead of the live one.
I rarely write unfavorable reviews, but I just lost a couple of hours worth of work because the app wasn’t saving my changes, and I didn’t discover this until closing and re-opening the file. Hard to trust a database editor that silently ignores saves.
With Family Sharing set up, up to six family members can use this app.