Introduction

SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.

Platform

macOS 11.0+ / iOS 14.0+

Download

Version 5.8.6 | Dec 11, 2022 | Release Notes

Features

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 in place.
• Supports open external folders in place.
• Supports show recents files.

Browse

Table List

• Supports display each table’s name and records count.

Table List

Query Editor

• Multi-query execution.
• Syntax highlighting.
• SQL auto-completion.
• Format query.

Query Editor - Multi-query Execution

Data Editor

• View, edit or add table data.
• View table data with a convenient data filter.
• Sort records by tapping on column title.
• Edit blob data as hex or show it as preview if possible.

Data Editor

Data Filter

Alter Table

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

Alter Table

Connect

• Supports let SQLiteFlow(macOS) connect databases in this app.

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

Database Statistics

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.

Database Diff

Import

• Supports import CSV data.

Import CSV data

Export • 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.

Multiple Windows

• Supports multiple windows for iPadOS 13.

Dark Mode

• Supports dark mode for iOS 13.

Shortcuts

• Supports “Run Query” action.
• Supports “Import CSV” action.

Languages

• English | 简体中文 (Chinese, Simplified) | 繁體中文 (Chinese, Traditional) | 日本語 (Japanese)

Support or Contact

Have any questions or feature requests? Please feel free to create an issue.