SQLiteFlow - SQLite Editor

SQLiteFlow - SQLite Editor

Mac OS Developer Tools

Free
Own Wish Buy Buy

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 with custom style.
• 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 and show it as image if possible.
• Copy data to CSV.

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

Remote Connect
• Supports open remote SQLite databases on SQLiteFlow(iOS).

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.

Export
• In Data Editor, supports export data from a table/view to a CSV file.
• In Query Result, supports export data from query result or query message to a CSV file.

Dark Mode
• Supports Dark Mode for macOS Mojave.

Drag and Drop
• Open databases and SQL scripts.
• Create multiple windows.

Handle Database File Name or Directory Changes
• For instance, 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 feature that could save lots of your time from writing ATTACH DATABASE commands.

REGEXP Operator
• Supports REGEXP operator for local databases when 'REGEXP operator' is enabled in Preferences.

Inside Explorer
• Show inside data structure of SQLite database file, journal file, WAL file or WAL-Index file.

Show More...

What's New

• Supports SQLite version 3.35.3 (2021-03-26).
• Query Editor, supports create a view from right click menu if user selected string has prefix "SELECT".
• Data Editor, add a floating row header to data editor, it offers on more way to select rows, and could let user select a row without triggering editing.

My Rating

App Store Rating