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 a keyboard shortcut issue when using dvorak layout.
+ Fixed an issue where exporting as Pipe would not always work. [#498](https://github.com/hankinsoft/SQLPro/issues/498)
+ Multi cursor improvements with arrow up/down cursor selection.
+ Fixed an issue with query line numbers display.
+ Fixed an issue that could cause a crash when inserting/duplicating rows, deleting rows, then cancelling actions together on the results grid.
Ratings and ReviewsSee All
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.
Fast, accurate and fun to use
It will get the fifth star when
1) cmd-return executes a query, and
2) I can have more than one query window open on a table.
I encourage everyone to buy this so he (or she) can afford to add features. It's a good program.
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.
With Family Sharing set up, up to six family members can use this app.