SQLiteFlow vs SmartQuery

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. One use case is that you can debug query performance issue on your iPhone or iPad directly through your Mac. 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 display 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. Create Function • Supports create scalar function using a simple JavaScript routine. Terms of Use: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/

Supports PostgreSQL, MySQL, and SQLite. 100% local and open-source. Get tailor-made queries from a schema-aware AI assistant: Copilot generates queries based on your database schema, including tables, columns, enums, constraints, and more. Rows are never passed to Copilot. Insert, update, and delete with ease: Generate SQL to modify your data with an intuitive user experience. Includes inputs optimized for each data type. Bring your data to life with charts: Easily generate line, bar, and pie charts from your SQL results. Also, Copilot will automatically suggest appropriate charts for generated SQL. Ask your database anything: Use natural language to get precise answers from your database. Get prompt suggestions and comfortably explore your data. Generate complex modifications tailored to your database schema. Thoughtful, customizable design: SmartQuery has a strong focus on user experience and accessibility. Adjust the theme and primary color to your liking. Security and transparency: SmartQuery is open source and 100% local—no accounts, no subscriptions, no cloud. When handling credentials and table data, there is no room for compromise. Here's how we keep things secure and private: - 100% local: SmartQuery runs entirely on your device. Credentials, connections, queries, and all data stay local. There is no cloud—no accounts, no syncing—so your database access never leaves your machine. - Your credentials, your device: Connection details and credentials are stored only on your device. Nothing is uploaded to our servers because we don't store user data—everything stays under your control. - Need-to-know basis: Your data is never stored or logged by us. When you use AI features, only the minimum necessary data (e.g. schema information) is sent to the AI provider—row data is never sent. - Web best practices: Data is always transferred via HTTPS and protected from man-in-the-middle attacks. The web app is protected against XSS and XSRF attacks and other web vulnerabilities.