SQLiteFlow - SQLite Editor6.8.6 - App Store

Two-week free trial! So you can purchase SQLiteFlow after you know you like it! SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.
It contains features as described below:

Browse
. Manage files. Supports add, remove, duplicate, rename folders, SQLite databases, SQL files, CSV files, etc.
. Supports import database from iCloud Drive by the file picker.
. Supports open external SQL files, CSV files and Filter files.
. Supports open external folders. Requires iOS 13.0 or iPadOS 13.0.
. Supports show recents files.

Query Editor
. Multi-query execution.
. Syntax highlighting.
. SQL auto-completion.
. Format query.

Data Editor
. View, edit or add table data.
. Multiple cells/rows/columns selection.
. View table data with a convenient filter.
. Sort records by tapping on column title.
. Edit blob data as hex or show it as preview if possible.

Alter Table
. View, edit or add table fields, indexes, foreign keys, checks.
. View triggers.
. View DDL.

Table List
. Supports display each table's name and records count.

Connect
. Supports let SQLiteFlow(macOS) connect databases in this app. One use case is that you can debug query performance issue on your iPhone or iPad directly through your Mac.

Drag and Drop
. Supports drag and drop to import or export SQLite databases and SQL files in iPad.

Database Statistics
. Supports show records count of each table.
. Supports show total size of each table
. Supports show size of each table's content.
. Supports show size of each table's index.
This feature may help you get more insight about your SQLite databases' data storage information, which may let you see if there're any chances to let SQLite working in a more effective way in your device.

ER Diagram
. Supports display ER diagram.
. Supports toggle field type hide or show.
. Supports Relationship Guessing.
. Supports copy as Mermaid markdown.

Database Diff
. Supports generate SQL text that can let you transform a database content into another.
. Supports show a summary of the differences between two databases.

Import
. Supports import CSV data.
. Supports import JSON data.

Export
. In Data Editor or Query Results, supports export data to CSV, JSON, Markdown or List.
. In Data Editor, supports export data to Insert Statement or Update Statement if possible.

Multiple Windows
. Supports multiple windows for iPadOS 13 or later.

Dark Mode
. Supports dark mode.

visionOS
. Supports visionOS.

Shortcuts
. Supports "Run Query" action.
. Supports "Import CSV" action.
. Supports "Import JSON" action.

Create Function
. Supports create scalar function using a simple JavaScript routine.

Terms of Use: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

Version History • Hex Editor. Fix an issue that may cause user can't input character in ascii section.
• Dump Database. Views structure now will be exported.
• Additional bug fixes and stability improvements. 6.8.6 Sep 12 • Dump Database. Remove the option "Data Only". Add two options "Include DDL" and "Include Data".
• Additional bug fixes and stability improvements. 6.8.5 Aug 4 • Bug fixes and stability improvements. 6.8.4 Aug 3 • Bug fixes and stability improvements. 6.8.3 Jul 24 • The database view now persists the expand/collapse state of sections.
• Additional bug fixes and stability improvements. 6.8.2 Jul 15 • Bug fixes and stability improvements. 6.8.1 Jul 9 • Table Schema. Avoid generating same default new field name when adding new fields.
• Table Schema. When remove a column through UI, if this column has a single-column unique constraint, this unique constraint will be removed alongside with this column to avoid further alter table grammar error. 6.8.0 Mar 14 • Bug fixes and stability improvements. 6.7.5 Feb 3 • Bug fixes and stability improvements. 6.7.4 Jan 15 • Fix an issue that lead to load database failed if there's unrecognized tokenizer on a virtual table.
• Additional bug fixes and stability improvements. 6.7.3 11/05/2025 • Data Editor. Enhanced support for external keyboards.
• Additional bug fixes and stability improvements. 6.7.2 10/21/2025 • Fix an issue that may cause app crash at launch on iPadOS 26.0.1.
• Additional bug fixes and stability improvements. 6.7.1 10/14/2025 • Supports iOS 26.
• Additional bug fixes and stability improvements.
• This version of SQLiteFlow now requires iOS 18.0 or later. 6.7.0 10/03/2025 • Bug fixes and stability improvements. 6.6.3 03/12/2025 • Bug fixes and stability improvements. 6.6.2 03/11/2025 • Data Editor, change the "Copy as Hex String" item of the context menu of BLOB data cell to "Copy as BLOB Literal" since it's more useful in practice.
• Hex Editor, supports copy hex data as BLOB literal.
• Additional bug fixes and stability improvements. 6.6.1 02/20/2025 • Auto completion, supports auto complete most of SQLite internal functions with placeholders as parameters tips.
• Dump Database, fix an issue that may cause later import failed when some kind of triggers exist.
• Additional bug fixes and stability improvements. 6.6.0 02/16/2025 • Fix a crash issue when creating a FTS table. 6.5.6 01/02/2025 • Create Function. Supports create scalar function using a simple JavaScript routine.
• Additional bug fixes and stability improvements. 6.5.5 12/02/2024 • Create Function. Supports create scalar function using a simple JavaScript routine.
• Additional bug fixes and stability improvements. 6.5.4 11/27/2024 • Data Editor & Query Result, add an option to the Text Editor to let user format text as JSON. 6.5.3 11/13/2024 • Query Editor. Now some database relate UI will automatically be refreshed after execute queries that may change database schema.
• Additional bug fixes and stability improvements. 6.5.2 10/23/2024 • Browse. When tap a not downloaded file, now app will try to open it automatically after finished downloading.
• Data Editor. Supports change font size. You can go to Settings - Data Editor to change it.
• Shortcut. Run Query action. Fix an issue that when query is empty and the setting Include Query Message in Result in turned on, query message is not included in result.
• This version of SQLiteFlow now requires iOS 17.0 or later.
• Additional bug fixes and stability improvements. 6.5.1 10/03/2024 • Browse. When tap a not downloaded file, now app will try to open it automatically after finished downloading.
• Data Editor. Supports change font size. You can go to Settings - Data Editor to change it.
• Shortcut. Run Query action. Fix an issue that when query is empty and the setting Include Query Message in Result in turned on, query message is not included in result.
• This version of SQLiteFlow now requires iOS 17.0 or later.
• Additional bug fixes and stability improvements. 6.5.0 10/02/2024 • Query Editor, supports toggle comments, intent lines, back indent lines through context menu or a connected physical keyboard (with hotkey command + /, tab, shift + tab respectively). 6.4.0 07/26/2024