Aqua Data Studio ships with an integrated Random Table & Data Generator that runs on Windows, macOS, and Linux. This allows you to generate the synthetic data that the modern enterprise data…
With one click, the built-in Automate functions allow inserting frequently used statements such as SELECT, DELETE or INSERT in your code. Another powerful and flexible feature is the Abbreviation support…
Aqua Data Studio supports SQL, JSON, AquaScript, Text, HTML, XML, JavaScript, and Java Editors. Features such as syntax highlighting, autocompletion, code folding, find and replace, lens mode, zooming, punctuation completion,…
Invoke query results in an editable, Excel-like grid. The Execute Edit feature is useful for altering, inserting, deleting, cloning and formatting data in the Table Data Editor.
Aqua Data Studio’s Visual Explain Plans, available for multiple database platforms, provide a visual display and statistics of an execution plan for a query, allowing for query tuning to enhance…
Speed up the creation of your SQL scripts with the autocompletion feature for database tables, columns and views. Autocompletion is invoked instantly as you type in the SQL Editor. Aqua…
The SQL Editor allows you to quickly format SQL statements for readability. Ctrl+B invokes the various options to beautify SQL keywords, case keywords, alignments, operators, punctuation marks, line breaks and…
With the Parameterized Scripts feature, you can define variables in your SQL Scripts using a leading “&”. Once you run the script, a popup will prompt you to enter the…
Aggregate multiple datasets and build pivot tables and chart visualizations of your data in worksheets. Execute queries, pull them into your workbooks, then easily drag and drop to create custom…
Augment your datasets with calculated fields and parameters. Users may add calculated fields which are new fields in your dataset where the values are based on user defined expressions of…
