Introduction
SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.
Platform
macOS 13.0+ / iOS 17.0+
Download
Version 6.5.3 | Nov 13, 2024 | 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.
- Supports import JSON data to a table.
- Supports import data by SQL file.
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.
visionOS
- Supports visionOS.
Shortcuts
- Supports “Run Query” action.
- Supports “Import CSV” action.
- Supports “Import JSON” action.
Languages
Support or Contact
Have any questions or feature requests? Please feel free to create an issue.