SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.
It includes the following features:
Customize syntax highlighting.
Copy query as code.
Paste recent query sessions.
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.
View, edit or add table fields, indexes, foreign keys, checks.
Preview the query that for altering table.
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.
Supports generate SQL text that can let you transform a database into another.
Supports show a summary of the differences between two databases.
Supports import CSV data to a table.
In Data Editor or Query Results, supports export data to CSV, JSON or Markdown.
In Data Editor, supports export data to Insert Statement or Update Statement if possible.
Supports access encrypted SQLite database which is encrypted by SQLCipher library.
Supports open remote SQLite databases on SQLiteFlow(iOS).
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 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.
Show binary data structure of SQLite database file, journal file, WAL file or WAL-Index file.