Aqua Data Studio implements a reliable database administration system that can be used for browsing database contents and running SQL scripts. It provides support for multiple types of relational databases, such as MySQL, Microsoft SQL Server, Sybase, Oracle, DB2, Apache Cassandra, Derby and Hive, Informix, MongoDB, PostgreSQL, SQLite and more.
The main advantage of Aqua Data Studio is that it does not limit the number of servers you can connect to, which means that you can work with multiple databases simultaneously. Servers and database schemas are displayed in tree-view, for easier navigation and understanding of the structure. Aqua Data Studio displays data in a structured manner, enabling you to create new tables or easily modify existing ones. You can change or create indexes, users, permissions and procedures, as well as edit the data definition language of a database object.
The integrated schema script generator assists you in creating SQL scripts. The editor features syntax highlighting, line numbering, auto-complete functionality and suggestions, all meant to significantly ease your work.
The application’s feature set is completed by the integrated database administration tools, which enable you to manage instances, connections, sessions or storage capacity, as well as generate server statistical reports.
The IDE features debugging capabilities and allows you to easily import and export data using the dedicated wizards that can guide you throughout the entire process. The ER diagram generator allows you to obtain a graphical representation of the database structure, while the integrated query builder helps you generate and execute queries and view results displayed as 2D or 3D charts.
Aside from the above, there are more features waiting to be discovered in Aqua Data Studio. It is a scalable database management tool worth trying for handling large data sets.