Aqua Data Studio Features

The universal database IDE for relational, NoSQL, and cloud platforms

Diverse Database Development

Aqua Data Studio enables users to design, administer and automate the latest class of databases effortlessly.

Aqua Data Studio natively supports over 40 different data sources and runs seamlessly on Windows, macOS and Linux. For a list of supported database platforms, refer to platform support.

Aqua Data Studio Overview Video: 4 mins 42 secs

Visual Analytics

Analyze data with an easy-to-use drag & drop interface. You can pull query results into worksheets to create beautiful visualizations of your data, you can create dashboards by dragging in visualizations from many worksheets and you can save and share them in workbooks with colleagues and customers allowing them to easily navigate and interact with your data.

Learn More >

Visual Analytics Demo Video: 7 mins 49 secs

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.

Learn More >

Aqua Data Studio - Visual Query Builder

Visual Query Builder

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.

Learn More >

Aqua Data Studio - FluidShell

FluidShell

MongoShell for MongoDB

MongoShell provides an interactive JavaScript shell with nearly identical syntax and functionality to the native mongo shell. We built it on top of FluidShell in order to provide you the ultimate combined functionality of a Unix Shell with a native mongo command line.

Learn More >

Aqua Data Studio - MongoShell for MongoDB

MongoShell for MongoDB

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.

Learn More >

Aqua Data Studio - Query and Analysis Tool

Query and Analysis Tool

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.

Aqua Data Studio - Visual Object Editing

Visual Object Editing

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.

Learn More >

Aqua Data Studio - Table Data Editor

Table Data Editor

Aqua Data Studio - DBA Tools

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

Aqua Data Studio - SQL Debuggers

SQL Debuggers

Import and Export

Use our UI’s built-in ETL functionality to directly import CSV or Excel 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.

Learn More >

Aqua Data Studio - Data Import

Data Import

ER (Entity Relationship) Modeler

Create and manage ER diagrams. From a simple reverse engineering of your existing database to designing a detailed physical ER diagram involving thousands of entities, you can annotate, forward engineer, perform diffs, generate HTML reports and more.

Learn More >

Aqua Data Studio - ER (Entity Relationship) Modeler

ER (Entity Relationship) Modeler

Schema Compare and Synchronize, File and Result Diff

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. Synchronize your source schema to your target schema for the same DBMS vendor. 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.

Schema Compare with Synchronization and Data Compare
File Compare

Aqua Data Studio - Compare Tools

Compare Tools

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.

Learn More >

Aqua Data Studio - SSH Terminal

SSH Terminal

SQL History

Retrieve 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.

Learn More >

Aqua Data Studio - SQL History

SQL History

Aqua Open APIs

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.

Learn More >

Aqua Data Studio - Aqua Open APIs

Aqua Open APIs

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.

SVN Client
Git Client
CVS Client
Perforce Client

Aqua Data Studio - Version Control

Version Control

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.

Learn More >

Aqua Data Studio - Charts

Charts

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.

Learn More >

Aqua Data Studio - Autosave Workspace

Autosave Workspace

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.

Learn More >

Aqua Data Studio - Database Object Search

Database Object Search

Visual Explain Plans

Aqua Data Studio’s Visual Explain Plans for Amazon Redshift, DB2 LUW, DB2 z/OS, Greenplum, Hive, Impala, MariaDB, Microsoft SQL Server, MySQL, Netezza, Oracle, ParAccel, PostgreSQL, Spark, Sybase ASE, Sybase IQ, and Teradata Aster provide a visual display and statistics of an execution plan for a query, allowing for query tuning to enhance query and server performance. For Amazon Redshift, DB2 LUW, DB2 z/OS, MS SQL Server, Oracle, Sybase ASE and Sybase IQ, a rich graphical display is also supported.

Learn More >

Aqua Data Studio - Visual Explain Plans

Visual Explain Plans