SQLiteFlow - SQLite Editor 4+

Manage your SQLite databases

晨亮 贾

    • Free
    • Offers In-App Purchases

Screenshots

Description

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 contains features as described below:

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.
• Supports open external folders. Requires iOS 13.0 or iPadOS 13.0.
• Supports show recents files.

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

Data Editor
• View, edit or add table data.
• Multiple cells/rows/columns selection.
• View table data with a convenient filter.
• Sort records by tapping on column title.
• Edit blob data as hex or show it as preview if possible.

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

Table List:
• Supports display each table's name and records count.

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

Drag and Drop
• Supports drag and drop to import or export SQLite databases and SQL files in iPad.

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 index.
This feature may help you get more insight about your SQLite databases' data storage information, which may let you see if there're any chances to let SQLite working in a more effective way in your device.

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 content into another.
• Supports show a summary of the differences between two databases.

Import
• Supports import CSV data.
• Supports import JSON data.

Export
• In Data Editor or Query Results, supports export data to CSV, JSON, Markdown or List.
• In Data Editor, supports export data to Insert Statement or Update Statement if possible.

Multiple Windows
• Supports multiple windows for iPadOS 13 or later.

Dark Mode
• Supports dark mode.

visionOS
• Supports visionOS.

Shortcuts
• Supports "Run Query" action.
• Supports "Import CSV" action.
• Supports "Import JSON" action.

Terms of Use: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

What’s New

Version 6.3.5

• Supports show database ER diagram. You can go to Menu - Database - ER Diagram to display it.
• ER Diagram, supports toggle field type hide and show.
• ER Diagram, supports enable Relationship Guessing. If this setting is enable, the diagram would treat two tables have relationship if they have appropriate table and field name even if they are not declared have relationship. For example, a table Customer and a table Invoice (which has a field named CustomerID) will be treated have relationship even if there's no foreign key declaration on table Invoice.
• ER Diagram, supports copy as Mermaid markdown.

Ratings and Reviews

4.7 out of 5
29 Ratings

29 Ratings

Syclone Josh ,

The only SQLite tool I’ve found for my needs

I was surprised there aren’t any SQLite apps on iOS considering how iOS itself is built on SQLite.

This one works and fits my needs. It’s not perfect or the “ultimate” but they keep updating and I haven’t seen any alternatives so this is the answer regardless.

Mickey2314 ,

Yes! It works perfectly!

Honestly, I’ve tried many SQLite applications and this one is by far the best!

Studat ,

Well done!!

Perfect companion for Apple shortcuts.

App Privacy

The developer, 晨亮 贾, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.

Data Not Collected

The developer does not collect any data from this app.

Privacy practices may vary, for example, based on the features you use or your age. Learn More

Supports

  • Family Sharing

    Some in‑app purchases, including subscriptions, may be shareable with your family group when Family Sharing is enabled.

You Might Also Like

SQLite Mobile Client
Developer Tools
MySQL Mobile Client
Developer Tools
TablePlus - Database Client
Developer Tools
MySQL Client by SQLPro
Developer Tools
PostgreSQL Client
Developer Tools
SQLPro Studio database client
Developer Tools