Aqua Data Studio の主な機能

Full-featured database IDE with AI assisted NLQ capabilities.
Database IDE with AI
Unlock data insights with powerful BI reports and analytics tools.
Visual Analytics
Create and manage schema with Entity Relationship (ER) Diagrams.
Data Modeling
Elevate your database administration with advanced DBA tools.
DBA Tools
Build queries with drag and drop ease - no coding required.
Visual Query Builder
Enterprise-grade version control for secure, auditable DB changes.
Version Control
Use Schema Compare for fast, accurate, and seamless DB sync.
Schema Compare Tool
Full-featured database IDE with AI assisted NLQ capabilities.

Full-featured database IDE with AI assisted NLQ capabilities.

Aqua Data Studio is your all-in-one solution for working with SQL and JSON code, empowering you to effortlessly switch between databases within a single, powerful IDE. Streamline your workflows with advanced features like SQL Debugger, , FluidShell, and reusable SQL histories to help ensure consistent and optimal database performance across your entire organization, Aqua Data Studio’s AI assisted Natural Language Query feature helps you write SQL and JSON code faster, easier, and with more accuracy, making even complex queries available to users of all skill levels.

Unlock data insights with powerful BI reports and analytics tools.

Unlock data insights with powerful BI reports and analytics tools.

Dive deep into your data with advanced statistical analysis, and create stunning visualizations that bring your insights to life. Intuitive pivot grids and sophisticated charting features put the power of data discovery at your fingertips. Effortlessly import, export, and generate reports to keep your data in sync with your business needs. Leverage the flexibility of R and integration to extend your analysis and build custom workflows. With Aqua Data Studio, you'll be equipped with the tools and insights needed to make informed, data-driven decisions that propel your business forward.

Create and manage schema with Entity Relationship (ER) Diagrams.

Create and manage schema with Entity Relationship (ER) Diagrams.

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

Elevate your database administration with advanced DBA tools.

Elevate your database administration with advanced DBA tools.

Aqua Data Studio's Database 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 Management, additional Agent Managers and Query History.

Build queries with drag and drop ease - no coding required.

Build queries with drag and drop ease - no coding required.

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.

Enterprise-grade version control for secure, auditable DB changes.

Enterprise-grade version control for secure, auditable DB changes.

A full and integrated version control client for Subversion, CVS, Git, and Perforce allows you to manage SQL scripts and other database files from within the tool. This ensures a smoother working environment and seamless integration into enterprise workflows. Aqua Data Studio provides a robust graphical interface for Git, supporting essential operations like check-in, add, edit, delete, rename, revert, push, pull, branch, tag, cherry-pick, compare, and history tracking. SVN support includes branching, tagging, merging, switching, and repository browsing, all within the same intuitive interface. These features eliminate the need for external version control tools, enhancing productivity, collaboration, and security. Built-in version control ensures teams can track, manage, and safeguard database changes with enterprise-level precision.

Use Schema Compare for fast, accurate, and seamless DB sync.

Use Schema Compare for fast, accurate, and seamless DB sync.

Aqua Data Studio's Schema SQL Compare tool simplifies database management by identifying DDL differences between schemas. It supports tables, views, stored procedures, indexes, and triggers, displaying results in a color-coded grid for easy analysis. Users can compare schemas across different DBMS platforms, sync changes, and generate HTML reports. Data comparison highlights row and column differences, with syntax highlighting for better readability - ensuring accurate and efficient database synchronization.