SQLite Client by SQLPro
sql and core data tool
Only for Mac
$49.99
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.
Features include:
+ 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.
more + Added support for field and table CHECK constraints (#480)
+ Fixed table designer changes (columns, indexes, foreign keys, triggers) not being applied.
2026.248 5 Sept
+ Data tab: added an "All rows" option to the rows-per-page picker (also in Settings > General) so a whole table can be browsed without paging. (#993)
+ Fixed restoring a purchase not unlocking the app until relaunch, and the trial screen sometimes appearing on a cold launch for licensed users. (#1173, #1169)
2026.247 4 Sept
+ Sidebar text size: Settings > Sidebar lets you enlarge the database tree text (14 to 24 pt) with a live preview. Icons, row heights and indentation grow with the text. (#1170)
+ Refreshed icon set for the sidebar tree and autocomplete, redrawn as crisp vector art that stays sharp at every size.
+ Results grid: new selection aggregates strip. Select cells and see Count, Sum, Average, Min, Max, Median and Mode at the bottom of the results. Toggle it per tab with the Σ button, or turn it on by default in Settings > Results grid. (#286, #948)
+ Results grid: right-click a column header and choose "Select column" (or Cmd-click the header) to select every cell in that column, handy with the aggregates strip. (#1172)
+ Results grid: "Copy with headers as..." now offers CSV, TSV and other separators, and you can set a preferred separator in Settings. (#1167, #1168)
+ Added a "Copy nulls as blank string" option so NULL cells paste as empty values instead of the text NULL. (#1157)
+ Sidebar keyboard shortcuts: press Delete on a table to drop it (with confirmation) or Return to rename it. (#1162)
+ Renaming a table no longer fails part-way with "no such table", and views and triggers that reference the table are rewritten correctly.
+ Saving now copies the database file directly instead of routing it through memory, which is faster and uses far less memory on large databases.
+ The table designer no longer blocks the interface while it acquires a database connection.
+ Duplicate table now reveals the copy in the sidebar and only opens the designer when you ask for it. (#1158)
+ Autocomplete: fixed columns of tables named in the query going missing from suggestions. (#1166)
+ Edited cells are now marked in amber (inserted rows stay green) so pending edits no longer look like deletions.
+ Settings: the Appearance font field is clickable and the font picker stays on screen (#1151); keyboard shortcuts such as Cmd-Return no longer change after reopening Settings (#1160); section headers, button spacing and clipped labels tidied up (#1161); spelling fixes across the interface (#1159).
+ Sidebar: fixed stale selection text colour and softened the unfocused selection highlight.
2026.237 25 Aug
+ Fixed an issue where UTF-16LE SQLite databases fail to open.
2026.208 29 Jul
+ There is now a pagination for the data grid. [993](https://github.com/hankinsoft/SQLPro/issues/993)
2026.203 23 Jul
- 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.
2026.90 30 Apr
+ Improved support for macOS 26.
+ Improvements for https://github.com/hankinsoft/SQLPro/issues/1030.
+ Improvements for https://github.com/hankinsoft/SQLPro/issues/1021
2026.30 26 Mar
+ Fixed an issue with UUID display. [#1077](https://github.com/hankinsoft/SQLPro/issues/1077)
+ macOS 26 improvements.
2025.77 12/11/2025
+ Fixed a crash some users were seeing.
2025.52 05/09/2025
+ Improvements for importing. #1030
Can now assign constants or expressions.
+ Improvements for titlebar. #1063
+ Improvements for clearing up temp files.
2025.35 18/08/2025
+ Fixed a crash that could occur on older devices.
2025.27 25/06/2025
+ Improvements to imports.
2025.26 24/06/2025
+ Fixed an issue where editing records via the editor dialog was not working properly. [#1047](https://github.com/hankinsoft/SQLPro/issues/1047)
+ Fixed an issue where the 'contains' filter was not always working with nulls. [#1046](https://github.com/hankinsoft/SQLPro/issues/1046)
2025.07 20/03/2025
+ Favorites editor:
+ New and modified favourites now shows an astrix and are green.
+ Removed favourites are red and have a strikethrough.
+ Fixed an issue where autocomplete only suggests a single order by entry. [#1031](https://github.com/hankinsoft/SQLPro/issues/1031)
+ After deleting a row, the next row is now selected. [#1036](https://github.com/hankinsoft/SQLPro/issues/1036)
+ When inserting a favourite, the favourites name is now added as a comment to the top of the SQL. [#1033](https://github.com/hankinsoft/SQLPro/issues/1033)
+ Fixed an issue with the favourites dropdown where entries would be missing after filtering and selecting an entry. [#1034](https://github.com/hankinsoft/SQLPro/issues/1034)
2025.06 05/02/2025
+ Fixed an issue where you could not truncate a table with a hypen in its name. [#1028](https://github.com/hankinsoft/SQLPro/issues/1028)
+ Added an option to export JUST the selected rows from a result set. [#1027](https://github.com/hankinsoft/SQLPro/issues/1027)
+ The 'edit row' window now has a split view and can be resized. [#1026](https://github.com/hankinsoft/SQLPro/issues/1026)
+ Fixed an issue where editing a column that has the string 'null' as a primary key would not work properly.
+ Changed the date format display to be 2024-11-08 21:16:34 rather than 2024/11/08 21:16:34 which is better inline with ISO standards. [#1014](https://github.com/hankinsoft/SQLPro/issues/1014)
2025.02 31/01/2025
+ Fix for String field "NULL" is interpreted as NULL instead of as a string. [#1021](https://github.com/hankinsoft/SQLPro/issues/1021)
2025.01 23/01/2025
+ Fixed an issue where the app name was sometimes displaying as blank.
2024.79 09/01/2025
+ Fixed an issue with exporting to json. [#1000](https://github.com/hankinsoft/SQLPro/issues/1000)
2024.78 26/08/2024
+ Fixed a crash some users were seeing.
2024.61 30/07/2024
+ Fixed an encoding issue where some columns may display null even though the contents are not null. [#990](https://github.com/hankinsoft/SQLPro/issues/990)
+ Updated to the latest SQLite version.
2024.31 11/06/2024
+ Fixed an issue where the app may lock up when loading rows. [#983](https://github.com/hankinsoft/SQLPro/issues/983)
+ Fixed an issue where importing from csv may be slow, or could cause hangs. [#982](https://github.com/hankinsoft/SQLPro/issues/982)
2024.30 28/05/2024
+ Fixed a crash that could occur when renaming columns. [#967](https://github.com/hankinsoft/SQLPro/issues/967)
2024.21 11/04/2024
+ Performance improvements.
2024.10 24/01/2024
+ Working on fixing a hanging crash some users were seeing.
2023.52 30/08/2023
+ Fixed a crash on macOS 10.13.
2023.50 04/07/2023
+ Added support for field and table CHECK constraints (#480)
+ Fixed table designer changes (columns, indexes, foreign keys, triggers) not being applied.
more Version 2026.248 5 Sept
Data Not Linked to You The following data may be collected but it is not linked to your identity:
