Annotate, forward engineer, compare,convert, and generate reports.

Automatically format SQL, color syntax, and complete text to save time in writing SQL statements.

View query results in text, grid, pivot, and form views and export to common formats.

Identify patterns and trends to find opportunities for further analysis.

Easily alter data, and add and delete rows using an editable, Excel-like grid.

Forward engineer to model tables, views, indexes, constraints, and relationships and generate SQL scripts.

Reverse engineer existing databases to visualize a database model.

Quickly convert models from one database platform to another.

Leverage the rich set of visual options including joins, group bys, sort order, and equality comparisons.

Update all charts in real time based on the query result set.

Use filters, data labels, and table calculations to create charts.

Preview the resulting SQL statements prior to executing them.

Create calculated fields to invoke R commands and then plot the resulting data similar to any other field.

Use convenient import and export wizards to quickly select options to extract, transform, and load (ETL).

One consistent interface lets developers work easily across multiple database platforms to maximize database development efficiency.

Access your diverse data sources whether they are hosted on premises or in the cloud (including Amazon, Azure, and Google).

Create, alter and delete without having to write a single line of code.

For Oracle, manage rollbacks, logs, and system global area (SGA).

For Amazon Redshift, Netezza and Vertica, view query history.

Also compare query results and folders and files on local machines.

Aqua Data Studio 4.7