Introduction

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

Platform

macOS 13.0+ / iOS 16.1+

Download

Version 6.3.6 | Apr 15, 2024 | Release Notes

Features

Query Editor

• Multi-query execution.
• Customize syntax highlighting.
• SQL auto-completion.
• Format query.
• Copy query as code.
• Paste recent query sessions.
• Explain query.

Query Editor - Multi-query Execution

Query Editor - Copy Query as Code and It’s Setting

Data Editor

• View, edit or add table data.
• 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.

Data Editor

Table Schema

• View, edit or add table fields, indexes, foreign keys, checks.
• View triggers.
• View DDL.
• Preview the query that for altering table.

Alter Table - Fields

Alter Table - Preview

Import

• Supports import CSV data to a table.
• Supports import JSON data to a table.
• Supports import data by SQL file.

Import from CSV Text

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.

Database Statistics

• Display table counts and each table’s record count.
• Display total size of each table, size of each table’s content and size of each table’s indexes.

Database Statistics

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.

Remote Connect

• Supports open remote SQLite database in iPhone or iPad with SQLiteFlow(iOS) installed.

Remote Connect

Dark Mode

• Supports Dark Mode for macOS 10.14+.

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.

Attach Opened Databases

Drag and Drop

• Drag and drop to open databases and sql scripts.
• Create multiple windows.

Inside Explorer

• Show inside data structure of SQLite database file, journal file, WAL file and WAL-Index file.

Inside Explorer

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

Database Encryption

• Supports handle encrypted SQLite databases which are encrypted by SQLCipher library.

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.

Languages

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

Support or Contact

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