Products

Tab Layout

Coding and Querying

Analytics and BI

DB Management

Enterprise Ready

AI Enabled

Multi-platform IDE

SQL Debugger

JSON and SQL Support

Visual Query Builder

Visual Explain Plans

Query Analyzer

Reusable Assets

Access Data Sources

Connect natively to over 40 relational and NoSQL DBMS platforms (Oracle, SQL Server, Db2, Sybase, Hive, MongoDB, MySQL, Snowflake, and many more) from one easy-to-use IDE interface. Access your diverse data sources whether they are hosted on premises or in the cloud (including Amazon, Azure, and Google).

Debug SQL

Trace and debug stored procedures, functions, and packages to identify any development or production issues. Single-step through code, pause and set breakpoints and evaluate variables and conditional flow. Available for select platforms.

Write SQL Code

Produce high-performing SQLand JSON code for diverse database platforms with the Visual Query Builder and the advanced SQL Editor. One consistent interface lets developers work easily across multiple database platforms to maximize database development efficiency.

Visually Build Queries

Construct sophisticated database queries without ever writing a line of SQL. Select tables and columns from the graphical user interface. Leverage the rich set of visual options including joins, group bys, sort order, and equality comparisons.

Explore Visual Explain Plans

View a visual display and statistics of an execution plan for a query to tune query enhance query and server performance. Available for select platforms.

Analyze Queries

Connect to any database and execute SQL queries effortlessly. Automatically format SQL, color syntax, and complete SQL. Perform advanced analysis by viewing query results in text, grid, pivot, and form views with quick filtering and one-click export to Excel.

Access SQL History

Quickly retrieve and reuse any previously executed queries with the automatic recording of all queries. Filter and archive queries to ensure efficient scaling.

Statistical Analysis

Data Visualization

Pivot Grids

Import / Export Capabilities

Charting Tools

Statistical Analysis

Rapidly create advanced data visualizations for data analytics by applying statistical analysis with R. Create calculated fields to invoke R commands and then plot the resulting data similar to any other field.

Data Visualization

Create engaging data visualizations and dashboards to explore and share with others. Identify patterns and trends to find opportunities for further analysis. Apply filters, data labels, table calculations, and statistical analysis with R to create charts to improve business decisions, limit risk and solve difficult problems.

Pivot Grids

Edit the result-set of an executed query in a data grid using a convenient graphical interface. Easily alter data, and add and delete rows using an editable, Excel-like grid. Preview the resulting SQL statements prior to executing them.

Import / Export Capabilities

Import and export data of different formats to and from databases, tables, objects, and files. Use convenient import and export wizards to quickly select options.

Charting Tools

Create combination charts within one worksheet representation of a dataset. By pivoting on multiple measure fields, you may choose to display different chart types for each series of data, whether it be as individual or merged charts to provide a combination within one graph.

DB Administration Tools

Data Modeling

Compare and Synchronize

Table Data Editor

DB Object Navigator

DB Administration Tool

Administration tools allow you to manage the core aspects of your servers to keep them accessible, secure, and performative. For most databases, there are Instance, Storage, Security, and Session Managers. Plus there is a wide range of platform specific features available that include things like Rollback, Log, and SGA Managment, additional Agent Managers and Query History. Find details on your platform here.

Model Entity Relationship Diagrams

Create and manage entity relationship (ER) diagrams. Reverse engineering existing databases, and design detailed physical ER diagrams involving thousands of entities. Annotate, forward engineer, compare ,convert, and generate reports.

Compare

Compare the data definition language (DDL) of schema objects from different database platforms in an easy to navigate graphical interface. See database and object level differences. Also compare query results and folders and files on local machines.

Table Data Editor

Aqua Data Studio's Table Data Editor that allows you to edit the result-set of an executed query on a table using a convenient graphical interface. This makes it easy to alter data and add or delete rows using an editable, Excel-like grid.

Manage Database Objects

Browse database objects (including tables, indexes, triggers, users and roles, and stored procedures) and visually edit them with a few simple clicks. Create, alter and delete without having to write a single line of code.

Version Control

SSH - Terminals and Tunnels

Session Management

SSO, AD and LDAP Support

Automation and Scripting

Security First Approach

Flexibile Licensing

Collaboration

Version Control

A full and integrated version control client for Subversion, CVS, Git and Perforce allows you to manage your SQL scripts and other database files from within the tool.This provides for a much smoother working environment, and integration into your existing enterpriser workflow.

Terminals and Tunnels

Securely Login to Servers — Securely login to any server with the built-in SSH client. The client provides a rich feature set including copy and paste, find in buffer, Unicode, encryption cyphers, and support for multiple terminal emulators. Configure SSH tunnel connections within the tool, including port forwarding and server connections bound to the tunnels.

Session Management

Monitor and control active sessions across multiple database platforms to ensure performance, security, and operational continuity. Aqua Data Studio's session management tools allow you to track resource usage, manage user sessions, terminate problematic connections, and prevent long-running queries from affecting database performance to help enterprises maintain secure and stable environments.

Support

Aqua Data Studio integrates with Enterprise standards like Single Sign-On (SSO), Active Directory (AD), and LDAP, allowing centralized user authentication and access control. These features simplify login management, enhance security by enforcing enterprise authentication policies, and streamline access to databases through unified credential management.

Automation and Scripting

A scripting development environment with a set of Open APIs allows you to develop and debug scripts to automate your database tasks using the full set of functionality of the product.

Security First Approach

From secure coding practices such as SAST and SCA in our development process to Role-Based Access Control, encryption support, audit trails, and seamless integration with enterprise security features like SSO, LDAP, and AD, it's clear that security is a top priority for Aqua Data Studio.

Flexibile Licensing

Provides scalable options for enterprises, allowing easy management of multiple users with a single license key, supporting both large groups and variable user counts with quarterly reconciliation.

Collaboration

Collaborate using shared workspaces through workbook and dashboard functionality. Integrated version control systems like Git, SVN, CVS, and Perforce allow teams to manage, share, and track SQL scripts. Users can also export reports and dashboards to formats such as PDF, Excel, or HTML for easy sharing.

Private and Secure

NL Code Assist

NL Reporting

Voice Assist

Cross-platform AI Actions

Private and Secure

As the leader in enterprise-grade database management, Aqua Data Studio is built for the complexity of modern enterprise environments, where security, compliance, and scalability are non-negotiable. Our AI integration upholds that same commitment. With security and data privacy at the core of our enterprise approach, we’ve chosen OpenAI’s API as our initial AI provider for its strict privacy controls, enterprise-grade encryption, and compliance with global security standards.

Learn More

NL Code Assist

With Natural Language Querying (NLQ) Code Assist, users can describe their data queries in plain language, such as “Show the sales growth for the last six months,” and Aqua Data Studio will instantly translate these requests into database-specific SQL. This eliminates the need for manual query writing and allows users to interact with databases more intuitively, making data exploration more accessible to all team members, regardless of their SQL expertise.

Coming Soon

Stay tuned for exciting update just around the corner.

Coming Soon

Stay tuned for exciting update just around the corner.

Coming Soon

Stay tuned for exciting update just around the corner.

Aqua Data Studio

The go-to IDE for data professionals seeking a reliable and intuitive solution to streamline tasks and navigate today’s complex data landscape, where they often wear many hats.

Aqua Data Studio

Standard Edition

Access Data Sources

Debug SQL

Write SQL Code

Visually Build Queries

Explore Visual Explain Plans

Analyze Queries

Access SQL History

Statistical Analysis

Data Visualization

Pivot Grids

Import / Export Capabilities

Charting Tools

DB Administration Tool

Model Entity Relationship Diagrams

Compare

Table Data Editor

Manage Database Objects

Version Control

Terminals and Tunnels

Session Management

Support

Automation and Scripting

Security First Approach

Flexibile Licensing

Collaboration

Private and Secure

NL Code Assist

Coming Soon

Coming Soon

Coming Soon

Aqua Data Studio

Ultimate Edition

Random Table and Data Generator

Task Scheduling

Advanced Data Handling: Import/Export JSON Files for MongoDB

Take control of your data with Aqua Data Studio

Standard Annual licensing

$499

Ultimate Annual licensing

$699

Enterprise Ultimate Custom licensing

Contact Salesfor Pricing

Aqua Data Studio supports over 40 of the most popular data source platforms on Windows, macOS, and Linux.

Join our mailing list

Contact Sales
for Pricing