This application offers a robust set of features designed for efficient database management and interaction. It ensures secure connections through TLS encryption or SSH tunnels, enhancing the protection of sensitive data during transactions. The application supports various forms of database authentication, including plain text, MD5, and SASL methods, such as SCRAM-SHA-256. It also facilitates SSH authentication by utilizing Secure Enclave Key technology and U2F/FIDO NFC Keys for added security. With these features, users can feel confident that their database connections are robust and safe from unauthorized access.
User experience is further simplified through features such as assisted table creation and the ability to alter table structures easily. The application allows users to explore, filter, sort, and quickly search through table data for more efficient data management. Additionally, it provides an A.I.-assisted query script feature that helps in composing database queries and analyzing plans, making complex data interactions more accessible for users, whether they are novices or experienced database administrators.
The tool also includes comprehensive management functions, enabling users to monitor database statistics, manage sessions, and visualize server statuses through graphs. An Entity-Relationship (ER) Diagram Viewer is integrated, which helps in understanding the structure and relationships within the database visually. Users can manage database objects like tables, views, and stored procedures with ease, all while utilizing an advanced data grid for browsing and editing data, along with conditional formatting capabilities.
Moreover, the app supports the import and export of data in multiple formats, enhancing its versatility for various applications. Users can sync their SQL and JavaScript scripts via iCloud and analyze SQL execution plans for optimization. The inclusion of charts and widgets, along with a job activity monitor, adds a layer of interactivity and monitoring. It’s important to note that while some features are freely available, others may require a paid in-app lifetime unlock. The application is compatible with PostgreSQL versions 9.5 through 12, and users are encouraged to provide feedback or suggestions through the provided contact email.