Aqua Data Studio is a complete Integrated Development Environment (IDE) for database query, administration and development. It supports all major database vendors, works on multiple operating systems and is localized for over 20 languages. With version 9.0 of Aqua Data Studio, we've introduced Aqua Open APIs, offering developers access for the first time to all of Aqua Data Studio's capabilities. The Aqua Open API library is accessible via AquaScripta JavaScript-based programming language with a full-fledged JavaScript editor and debugger.

It provides four major areas of functionality:
1) Database query and administration tools;
2) a suite of compare tools for databases, source control and file systems;
3) a complete and integrated source control client for Subversion (SVN) and CVS;
4) a database modeler as powerful as the best standalone database diagramming tools.

Database IDE: The database query and administration tools allow developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures. Aqua Data Studio provides an integrated database environment with a consistent interface for all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from a single application.

Version Control: Integrated version control provides a complete client for Subversion and CVS repositories, allowing you to manage all source control repositories within one easy-to-use IDE using the Repository Browser.

Compare Tools: The suite of compare tools in Aqua Data Studio allows you to view the differences of RDBMS servers, databases and schemas for database tasks with ease. You can further compare the differences of files, directory structures, source control files and full revisions.

Database Modeling: The Entity-Relationship Modeler vastly reduces development time and increases understanding of database schemas and relationships. You can create, explore, detail, and modify database schemes to create fully editable and scriptable diagrams of database relationships and objects.