Aqua Data Studio Features
Universal IDE for Databases
Aqua Data Studio enables users to design, administer and automate the latest class of databases effortlessly.
Aqua Data Studio natively supports over 20 different databases and runs seamlessly on Windows, Mac and Linux. Databases supported include:
See everything Aqua Data Studio has to offer below.
FluidShell
Automate your database ETL tasks using FluidShell, an interactive shell which combines the power of an SQL command line with the versatility of a Unix shell.
Big Data Ready
Throw us your largest data sets and see Aqua Data Studio blaze through them. We've invested a great deal of time to ensure that Aqua Data Studio scales with your ever-growing data sets while keeping memory consumption to a minium.
Query and Analysis
Connect to any database and execute SQL queries effortlessly by using intelligent Autocomplete, SQL Abbreviations and SQL Automation. Perform advanced analysis by using the built-in Pivot Grid and Charts, or one-click export to Excel.
Watch Demo: 22 mins Download MP4
Visual Object Editing
Rapidly create, alter and delete tables, indexes, triggers, users and roles, stored procedures and much more through Aqua Data Studio's highly streamlined Visual Editing UI.
Table Data Editor
Powerful, Excel-like grid editing of your table data. Edit any resultset and access features such as find/replace, copy, paste, delete, insert, alter, copy rows with a single click. Preview the resulting SQL statements prior to executing them.
Watch Demo: 5 mins Download MP4
DBA (Database Administration)
Stay on top of your DBA activities with our suite of tools customized per database vendor. Instance Manager, Session Manager, Storage Manager, Security Manager and more.
Oracle DBA Tools
MS SQL Server DBA Tools
DB2 DBA Tools
Sybase DBA Tools
MySQL DBA Tools
Integrated SQL Debuggers
Debug your stored procedures, functions and packages within Aqua Data Studio's IDE using all the functionality you'd expect from a rich debugger. Single-step through code, pause and set breakpoints and evaluate variables and conditional flow.
Oracle SQL Debugger
DB2 LUW SQL Debugger
MS SQL Server SQL Debugger
Sybase ASE SQL Debugger
Import and Export
Use our UI's built-in ETL functionality to import data, massage it to suit your needs and even export it in a different format. Use Aqua Data Studio's wizards to walk you through, step by step, importing data into existing tables and exporting data based on your desired format.
ER (Entity Relationship) Modeler
Create and manage ER diagrams. From a simple reverse engineering of your existing database to designing a highly complex diagram involving thousands of entities, you can annotate, forward engineer, perform diffs, generate HTML reports and much more.
Watch Demo: 9 mins Download MP4
Visual Query Builder
Construct sophisticated database queries without ever writing a line of SQL. Use our UI to select tables and columns and leverage our rich set of visual options including JOINs, GROUP BYs, SORT ORDER, equality comparisons and more.
Watch Demo: 8 mins Download MP4
Schema, File and Result Set Diff (Compare)
Find differences in DDL between any two database objects and even between two different DBMS vendors, all presented in a visually easy-to-read manner. Create filters to quickly isolate the objects you want to compare. Result set diff allows you to compare the output of 2 different query results and file compare lets you diff files between any open Aqua Data Studio editor tabs.
SSH (Integrated Secure Shell)
With Aqua Data Studio's built-in SSH client, SSH into any SSH server. The client provides a rich feature set including copy/paste support, find in buffer, Unicode, encryption cyphers and support for multiple terminal emulators.
SQL History
Retreive and reuse any of your previously executed queries instantaneously, thanks to the automatic recording of all queries by SQL History. Powerful filtering and archiving features ensure that SQL History scales with your use.
Watch Demo: 5 mins Download MP4
Aqua OpenAPIs
Roll-up your sleeves and dive into programming with Aqua Open APIs, our JavaScript-based interfaces to custom build your own logic. Aqua Data Studio provides a full-fledged IDE with APIs to database access, schema DDL generation, Grid and Pivot Grid charts, version control and much more.
Integrated SVN, Git, CVS and Perforce Version Control
Use our integrated version control to manage SQL scripts, Open API projects, FluidShell scripts, your development source code or any other types of files. Aqua Data Studio provides one of the best version control clients available on the market.
Spectacular 2D and 3D Charts
Build great looking charts directly within Aqua Data Studio. Choose from a comprehensive range of chart types and customize to meet your needs. All charts are updated in real time based on your query result set. You can even pivot your data and create charts based off your pivoted data.
Intelligent Database IDE with Auto Save and Resume
Aqua Data Studio reopens right where you left off, so you never have to start from scratch again. Even unsaved tabs and documents are auto saved and their tab order is preserved after relaunching Aqua Data Studio.
Database Object Search
Quickly find any object within your database server. Filter for object type with wildcards and restrict your search to precisely what you are looking for.
