SQLite database client2026.278 - App Store

SQLite client is a premium database client and management tool for SQLite & core data databases.

Some of the great features include:
+ Intellisense/SQL autocompletion.
+ Syntax highlighting with customizable themes (including dark).
+ Tabbed based interface for an optimal user experience (iPad).
+ Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more!
+ Query history
+ The ability to execute multiple queries at one and view the result sets.

Privacy Policy:
https://hankinsoft.com/privacypolicy.html

Terms of Use:
https://hankinsoft.com/termsofuse.html

Price:
SQLPro requires a Premium upgrade in order to interact with database result sets. Premium is available as a Subscription with Monthly and Yearly options. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. Your Account will be charged for renewal (based on your selected plan) within 24-hours prior to the end of the current period. Any unused portion of a free trial period, if offered, will be forfeited when the user purchases a subscription to that publication, where applicable. Payment will be charged to your iTunes Account at confirmation of purchase.

Version History - Picks up where you left off: after a restart the app brings back your open session and tabs, or offers to.
- Fixes a freeze at launch when restoring a session that used a SQLite database. 2026.278 Oct 5 • Database connections now stay open while you switch to another app, so temporary tables, session settings and open transactions are no longer lost.
• The database tree shows which database is selected and that it can be changed.
• Toolbar buttons use symbols, and the table designer uses the system tab bar.
• Fixes and refinements throughout, including groundwork for iPhone Duo. 2026.266 Sep 24 + General improvements 2026.261 Sep 18 Fixes adding new rows to a table, plus a redesigned results action bar. 2026.238 Aug 27 Updates and improvements. 2026.180 Jul 7 + Improved reliability and performance under the hood.
+ Various bug fixes and refinements. 2026.170 Jun 16 + Fixed an issue that could cause the app to lockup when opening some sqlite files. 2026.160 Jun 8 - Moved some logic that should have been on a background thread, from a foreground thread to a background thread. 2026.109 May 25 - Opening a SQLite file no longer freezes the UI while the schema is read, especially on large or iCloud-backed databases.
- Autocomplete: debounce on keystroke updates, plus O(1) allowed-tables lookup per entry. Large schemas no longer slow typing in the query editor.
- Connection-pool teardown no longer blocks the UI while a remote database closes its socket. Disconnect and tab-close return immediately even when the database is unreachable.
- Result-set sort treats signed numeric strings as NSDecimalNumber so "-100" sorts below "-50" instead of the other way around.
- Fixed a crash when copying a geometry cell value. 2026.108 May 23 - Sort order for negative numbers ([#1131](https://github.com/hankinsoft/SQLPro/issues/1131)). Sorting a column of numeric values now orders negative numbers correctly. Previously a column containing both positive and negative values could end up out of order when the database returned numeric values as strings (most commonly with Oracle).
- iPad schema sidebar crash. Fixed a table-view crash when removing the last table from a database in the schema sidebar.
- Large-cell tooltips. Faster scrolling and pointer-driven tooltips on result grids that contain very large string values (multi-megabyte JSON / log columns no longer cause UI hitches).
- Open from Files / Share sheet. Opening a `.sql` file from the Files app or a Share-sheet provider no longer freezes the app on slow sources (iCloud Drive, Google Drive, OneDrive). The file is now read on a background thread with a *Loading…* placeholder in the destination tab. 2026.92 May 4 - Fixed a rare launch hang on memory-constrained devices when first loading the autocomplete favorites cache. 2026.90 Apr 30 - Geometry / spatial viewer: preview POINT, LINESTRING, POLYGON, and other shape data right inside the result grid, with "Open in Maps" for point data.
- Improvements to Auto-reconnect when the server drops the connection (idle timeouts, brief network blips, server restarts).
- Various crash fixes and stability improvements. 2026.81 Apr 22 - Fixed an issue where some users when importing a sqlite file would see no UI. 2026.52 Apr 2 + Split view on iPhone: Query editor and results now display simultaneously in a top/bottom split view, replacing the old tab+based layout
+ "Run selected" support: Select a portion of your query and the Run button changes to "Run selected" to execute just that part
+ Run menu dropdown: Tap the chevron next to Run to access all actions ++ Run current, Run all, Save, Export, Format, Find, History, and Favorites all in one place
+ Execute query at cursor: Run just the query under your cursor without selecting it
+ Tappable line links in messages: Message output now shows clickable "(Line N)" links that highlight the corresponding query
+ Error highlighting: Query errors now show a red squiggly underline on the problematic text, matching the desktop app
+ Redesigned Alter Table: Columns, Indexes, Foreign Keys, and Triggers tabs rebuilt with a modern look and inline validation
+ Export from connection list: Long press a database and tap Export to share the .sqlite file directly
+ Connection list context menu: Long press any database for quick Connect, Export, or Delete actions
+ Live dark/light mode switching: Theme changes now apply instantly, including syntax highlighting colors, without restarting the app 2026.50 Mar 27 + Improved support for iOS 26. 2026.10 Feb 20 + Fixed an issue where the 'Run Query' button could disappear. 2025.81 12/03/2025 + iOS 26 improvements. 2025.80 12/02/2025 + Improvements with line number displays for queries.
+ Fixed a crash some users could have when modifying sqlite databases.
+ Improvements to modifying sqlite table ddl.
+ Fixed an issue where scripting views would not always work. 2025.57 09/23/2025 + Fixed a crash that could occur when long-pressing a connection. 2025.15 02/20/2025 + Fixed a crash some users were seeing when making a connection. 2024.53 07/01/2024 + Fixed a few crash issues some users were seeing. 2024.15 05/01/2024 2023.50 08/02/2023