Compare database files by dragging and dropping them. View differences in schema and data with yellow highlighting. Analyze tables, columns, triggers, indexes, and views. Display changed SQL code and data records for easy review.
Edit with a Sublime-like interface. Open and edit local and remote files via Dropbox, OneDrive, FTP, SFTP/SSH. Support multitasking, split-screen, and iPadOS mouse. Use Siri Shortcuts for automation. Enable multi-caret editing for efficient coding.
Manage databases with SQL query execution and syntax highlighting. Connect securely via SSL or SSH tunnel. Sync connections across devices using iCloud. Support multitasking on iPad. Edit and run SQL code directly.
The app opens Microsoft Access MDB and ACCDB files. Users can view and export data immediately to CSV and SQL formats, with support for MySQL, Postgres, Oracle, Sybase, and SQLite.
The app provides visual editors for database management, including schema, diagram, data, and SQL editors. It also offers server administration tools and utilities for importing, exporting, and diagnosing databases.
Learn programming with code examples for and SQL. Access solutions for substring extraction, generalized methods, database queries, table joins, grouped data sorting, and SQL Server data types. Find curated code from books and online resources.
Learn SQL fundamentals with interactive lessons on SELECT, INSERT, UPDATE, and DELETE. Practice filtering and grouping using WHERE, GROUP BY, HAVING, and ORDER BY. Explore table relationships through JOIN types.
Browse and manage files including databases, SQL files, CSV files, and folders. Import databases from iCloud Drive. Open external SQL, CSV, and filter files. Rename, duplicate, or remove files and folders. Edit databases with intuitive tools.
View and interact with data visualizations from devices. Explore dashboards offline with interactive previews. Mark favorites and save views. Share insights via email or social media. Sync data in real-time when connected.