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 This application simply dose not work with my python created files.
This application simply dose not work with my python created files.
+ 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:
