SQLiteFlow

SQLiteFlow is an SQLite editor that always makes its best to be intuitive, stable and reliable for you to use.

Query Editor:

• Multi-query execution
• Customize syntax highlighting
• SQL auto-completion
• Format query
• Supports wrap lines
• Copy query with custom style
• Explain query
• Cmd+ to make the font bigger, Cmd- to make the font smaller

Data Viewer:

• View, edit or add table data
• View table data with a convenient data filter
• Copy data to CSV

Alter Table:

• 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 database on iPhone or iPad with SQLiteFlow(iOS) installed

Database Statistics:

• Display table counts and each table's record count
• Display each table's storage consumed and storage consumed detail, including table data storage consumed and indexes storage consumed. (* Available on macOS 10.13+)

Dark Mode:

• Supports Dark Mode for macOS Mojave

Other features:

• Drag and drop to open databases
• Handle database file name or directory changes. This makes SQLiteFlow can work friendly with your SQLite database in iOS simulator
• Attach opened databases without any code. This is a very handy feature that could save lots of your time from writing ATTACH DATABASE commands