Description

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.

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).

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.)

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/

Hide.. Show more..

In-Apps

2-week Trial: 0,00 €
Pay-As-You-Go: 2,99 €
Lifetime License: 59,99 €
Unlimited Annual: 17,99 €

Screenshots

User Rating

0 out of 5

0 ratings in Finland

Ratings History

Reviews

App doesn't have any reviews yet

Store Rankings

Ranking History

App Ranking History not available yet

Category Rankings

Chart	Category	Rank
Top Grossing	Finland Developer Tools	5
Top Grossing	Algeria Developer Tools	9
Top Grossing	India Developer Tools	12
Top Grossing	Norway Developer Tools	47
Top Grossing	Pakistan Developer Tools	51