Aqua Data Studio for Mac
Aqua Data Studio is a fully-featured IDE specially designed for database query, development and administration with support for most database vendors and operating systems.
Out of the box, Aqua Data Studio features support for Apache Hive, Apache Cassandra, Microsoft SQL Database and MongoDB.
User-friendly tools, shells, debuggers and editors
Thanks to Aqua Data Studio, you can easily design, administer and automate the class of databases. You may also employ FluidShell, an interactive shell that mixes the versatility of a Unix shell and the power of an SQL command line to help you speed-up your workflow.
You can use all your favorite mongo shell commands like DB methods, commands to administer and maintain your MongoDB clusters, DBCollection methods and more.
Powerful object editing toolkit, as well as inbuilt data analysis and query capabilities
Aqua Data Studio helps you to quickly connect to the desired database and run SQL queries using SQL abbreviations, intelligent Autocomplete and SQL Automation. In addition, you can preform in-depth analysis using the built-in Charts and Pivot Grid.
Furthermore, you can instantly create, delete and alter indexes, tables, users, triggers, roles and stored procedures via Aqua Data Studio’s streamlined Visual Editing UI. At the same time, the intuitive Excel-like grid editing tools help you edit your table data, result set and use features like find and replace, insert, copy, paste, delete with just a few mouse clicks.
Extensive and streamlined database administration tool collection
Moreover, Aqua Data Studio allows you to keep track and manage all your DBA activities using the provided suite of tools that can be customized according to the vendor. Session, Instance, Security and Storage Managers are just a few of the available tools.
What is more, You can debug your stored functions, procedures, functions and packages right from within Aqua Data Studio. You can even import and export data into the desired format using Aqua Data Studio’ wizards.