Aqua Data Studio
Just Released: 15.0

is productivity software for Database Developers, DBAs, and Analysts. It allows you to develop, access, manage, and visually analyze data. Whether you are working with relational, nosql or cloud databases, your data is easily and quickly accessible with Aqua Data Studio. It supports all major database vendors, works on all major operating systems and is localized to 21 languages.

Aqua Data Studio's Visual Analytics allows you to 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.

Who Uses Aqua Data Studio?

Aqua Data Studio is used for database management by over 300,000 IT professionals in 98 countries, across Fortune 1000, public enterprise, private companies and educational institutions.

Learn more about who our customers are.


Features

Database IDE

Aqua Data Studio is a modern IDE with a workspace environment. A Docking & Windowing framework allows tabbed documents for query windows, which can be grouped or floated for flexibility. Easily manage and navigate all of your open query windows and files. screenshots Workspace Environment | Docking and Windowing Framework

Query & Analysis Tool

An advanced Query Analyzer allows you to connect to any database server and execute SQL Queries. SQL formatter, syntax coloring, and autocomplete features save you time in writing SQL statements. Query results can be viewed in text, grid, pivot or form views with quick filtering and export functionality. SQL History allows you to quickly retrieve any previous queries without losing them. screenshots Pivot Grids | Charting Tool | Autocompletion | SQL History And Archive

Visual Query Builder Revamped in 15.0

The Visual Query Builder lets you select database tables directly from the GUI, and then specify columns to retrieve, joins, sorting options, filtering criteria and other query parameters in a grid format. Along with selecting tables and adding query parameters, the Visual Query Builder will generate a complete SQL statement that can be viewed, copied and executed from the Visual Query Builder dialog window. screenshots Visual Query Builder | Query Builder Pivot Grid Results

SQL Debuggers

Debuggers for Oracle, Sybase ASE, DB2 LUW and SQL Server allow for tracing and debugging stored procedures to identity any development or production issues. screenshots Oracle SQL Debugger | Sybase ASE SQL Debugger |
DB2 LUW SQL Debugger | SQL Server SQL Debugger

SSH Terminal

Register and connect to as many SSH servers as you need and run commands in a tabbed window GUI. For added security it also has a Key Generator and Key passphrase Agent. screenshots SSH Terminal | SSH Terminal - Key Generator

FluidShell

FluidShell is an interactive shell which combines the power of SQL command line with the versatility of a Unix shell. screenshots FluidShell

MongoShell for MongoDB

MongoShell provides an interactive JavaScript shell with nearly identical syntax and functionality to the native mongo shell. screenshots MongoShell for MongoDB

Database Support

Operating System Support

  • Windows
  • Linux
  • OSX
  • Solaris
  • Java

Visual Analytics New in 15.0

Create beautiful visualizations and dashboards of your data to explore or share with others. Identify patterns and trends to find opportunities for further analysis. Giving you the ability to improve business decisions, limit risk and solve difficult problems. screenshots Visual Analytics

Table Data Editor

Aqua Data Studio provides a 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. screenshots Table Data Editor

Import & Export Tools

The Import and Export tools allow data of different formats to be imported and exported to and from databases, tables, objects and files. screenshots Import Tool | Export Tool

Database Object Navigator and Visual Editing

Browse database objects and visually edit them with a few simple clicks. Create, Alter and Delete without having to write a line of code. screenshots Visual Editing

Scripting & Open APIs

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. screenshots Project Environment | Debug AquaScripts

Database Administration Tools

Administration tools for Oracle, DB2 LUW, MS SQL Server, Sybase ASE and MySQL allow you to manage core aspects of your servers. For these databases there are Instance, Storage, Security, and Session Managers. For Oracle, there's also a Rollback, Log, and SGA Manager. For MS SQL Server, there's an additional Agent Manager. screenshots DB2 Storage Manager | Sybase Security Manager | SQL Server Agent | Oracle Rollback Manager

Compare Tools

Compare the DDL of schema objects from different databases in a easy to navigate graphical interface showing you database and object level differences. Use the same compare tool to compare query results, folders and files on your local machine. screenshots Schema Compare | Query Results Compare | File Compare |
Directory Compare

ER Modeler

The Aqua Data Studio ER Diagram modeler and generator is used to design, edit and reverse engineer database schemas. Tables, views, relationships and constraints are converted to shapes, lines, nodes and vectors so that complex abstract database objects and processes can be viewed in a coherent ER diagram. screenshots ER Modeler - Script Generator | ER Diagram Generator

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 for a much smoother working environment. screenshots Perforce Version Control | Git Version Control |
Subversion (SVN) Version Control | CVS Version Control

Language Support

  • Chinese (Simplified | Traditional)
  • Czech
  • Danish
  • Dutch
  • English
  • Finnish
  • French
  • German
  • Greek
  • Hindi
  • Italian
  • Japanese
  • Korean
  • Norwegian
  • Polish
  • Portuguese (Portugal | Brazil)
  • Russian
  • Spanish
  • Swedish

Home Aqua Data Studio Aqua Data Server AquaClusters Support Buy Company Privacy

Copyright © 2001–2014 AquaFold, Inc. All Rights Reserved.