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 includes the following features:
Query Editor
• Multi-query execution.
• Customize syntax highlighting.
• SQL auto-completion.
• Format query.
• Copy query as code.
• Paste recent query sessions.
• Explain query.
Data Editor
• View, edit, add or remove records.
• View table data with a convenient data filter.
• Edit blob data as hex or show it as preview if possible.
• Edit JSONB as JSON.
• Copy data to CSV，JSON, Markdown, and to Insert Statement or Update Statement if possible.
Table Schema
• View, edit or add table fields, indexes, foreign keys, checks.
• View triggers.
• View DDL.
• Preview the query that for altering table.
Database Statistics
• Display tables count and each table's records count.
• Display total size of each table, size of each table's content and size of each table's indexes.
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 into another.
• Supports show a summary of the differences between two databases.
Import
• Supports import CSV data to a table.
• Supports import JSON data to a table.
• Supports import data by SQL file.
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.
Database Encryption
• Supports access encrypted SQLite database which is encrypted by SQLCipher library.
Remote Connect
• Supports open remote SQLite databases on SQLiteFlow(iOS). One use case is that you can debug query performance issue on your iPhone or iPad directly through your Mac.
Dark Mode
• Supports Dark Mode for macOS Mojave or later.
Drag and Drop
• Open databases and SQL scripts.
• Create multiple windows.
Access Apple simulator
• Supports access Apple simulator. So you can open your app's Documents directory more easily than before when developing your apps.
Handle Database File Name or Directory Changes
• One of a cool thing that benefit from this feature is, this makes SQLiteFlow can work friendly with your SQLite databases in iOS simulator.
Attach Database
• Attach opened databases without any code. This is a very handy way to do attach database thing, and could save a lot of your time from writing ATTACH DATABASE commands if your business mode relies on it.
Inside Explorer
• Show binary data structure of SQLite database file, journal file, WAL file or WAL-Index file.
Shortcuts
• Supports "Run Query" action.
• Supports "Import CSV" action.
• Supports "Import JSON" action. (Requires macOS 14.0 or later.)
Create Function
• Supports create scalar function using a simple JavaScript routine.
Load Extension
• Supports SQLite load extension.
LLDB Co-worker
• Supports sfopen command. Let you open a copy of a temporary local database that originally in debugged device.
• Supports sfsave command. Let you copy the temporary local database (that originally created by sfopen command) to debugged device.
Terms of Use: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/
This app hasn’t received enough ratings or reviews to display an overview.
Impressive, extremely convenient
alototski
I got this app to try and was surprised to find a rich set of convenient features that made the work with SQLite db so easy and efficient. This going to be my only app for SQLite work.
Extremely Useful!
tckneisly
Exactly what I needed. The UI manages to be clean and intuitive without sacrificing essential features. I'm also a big fan of the inclusion of Shortcuts integration -- this wasn't critical for me, but I find myself using it a lot since it was included.I'm also really glad to see the developer making regular updates. There are too many dev tools in the app store that have been abandoned, but this doesn't seem to be one of them. Thanks, dev!
Makes Dev Life So Much Easier
lackey.codes
Hated trying to browse the iOS Simulator to find the sqlite file. This makes it such a breeze and the editor is great. Love it!
Crashes once a day on M1 MacBook Pro
FattyMoBookyButt
The application is wonderful when it works. Does everything I’d like in regards to SQLite functionality.I use it for work but pay the subscription myself because it is useful.But it crashes at least once a day and you lose anything that is not saved. It is a pain when that happens.It’s been happening for the 8 months or so I’ve had it installed. If the devs can’t fix the crashing, the least they could do is save the opened files in temp or cloud storage on the OSX filesystem and recover when the app crashes.
Developer Response
Could you send us the crash report alongside reproduce steps via Menu - Help - Report an Issue so we can investigate it and fix it?
• Update SQLite library to version 3.53.0 (2026-04-09).
• Open database dialog now will default display the options view.
• Open database dialog now can persist the option "Allow select all file types".
Version 6.8.3
The developer, 晨亮 贾, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .
Data Not Collected
The developer does not collect any data from this app.
Privacy practices may vary, for example, based on the features you use or your age. Learn More
Accessibility
The developer has not yet indicated which accessibility features this app supports. Learn More
Information
Seller
晨亮 贾
Size
7.7 MB
Category
Developer Tools
Compatibility
Requires macOS 14.0 or later.
Mac Requires macOS 14.0 or later.
Languages
English and 3 more
English, Japanese, Simplified Chinese, Traditional Chinese
