Aqua Data Studio
Aqua Data Studio is a free application that provides a database administration and query utility, allowing developers to easily and quickly build, edit and execute SQL scripts. It also allows you to visually modify and browse database structures. The project can be used with all major relational databases.
Features at a glance
Key features include schema object management, MongoShell for MongoDB, a query and analysis tool, user configurable charts, grid and pivot charts, FluidShell, a table data editor, import and export tools, database administration tools, database IDE (Integrated Development Environment), visual analytics, as well as SQL debuggers.
Additionally, database object navigator, database visual editing tools, visual query builder, compare tools, schema and file compare functionality, SQL history, open API scripting environment, an Entity Relationship (ER) modeler, integrated Secure Shell (SSH) terminal, and version control system are also included.
The project is translated into multiple languages, including English, Spanish, French, German, Chinese Simplified, Chinese Traditional, Japanese, Korean, Portuguese, Brazilian Portuguese, Russian, Czech, Polish, Italian, Dutch, Danish, Finnish, Norwegian, Swedish, Greek and Hindi.
Supports a wide range of databases
The software is well known for offering support for a wide range of databases, including the popular MySQL, SQLite, PostgreSQL, MongoDB, Apache Cassandra, Apache Hive, Apache Derby, Oracle, as well as Microsoft SQL Server. Generic JDBC and ODBC relational databases are supported too.
In addition, the Amazon Redshift, DB2 iSeries, DB2 LUW, DB2 z/OS, Excel, Greenplum, Informix, Netezza, ParAccel Analytic Platform, SQL Database (Azure), Sybase Anywhere, Sybase ASE, Sybase IQ, Teradata Database, Teradata Aster Database, Vertica, and VoltDB databases are also supported.
Supported operating systems and availability
Aqua Data Studio is a cross-platform software that supports all the mainstream computer operating systems, including Linux, Solaris, Mac OS X and Microsoft Windows. On GNU/Linux, it is available for download as pre-built binary packages supporting all distributions, optimized for 64-bit (x86_64) and 32-bit (x86) instruction set architectures.