Audience
Companies and professionals in search of a query tool designed to help them manage their databases in
About Advanced Query Tool (AQT)
AQT is a multi-database query and admin tool designed for DBAs, developers and data analysts.
It can access a large range of database types and has been specifically customized for over 30 different databases.
AQT is optimized for dealing with large systems and is one of the best tools on the market for use with DB2 z/OS.
Has a powerful Database Explorer window which displays more information on your database than almost any other product.
A great query environment with SQL editor, SQL history, graphical query builder, table editor, data export, charting.
AQT includes numerous tools that will delight your DBA - generate DDL, object compare/resync, data compare/resync, data loader, create/alter/manage objects, visual explain, system monitor.
Other Popular Alternatives & Related Software
dbForge Studio for SQL Server
dbForge Studio for SQL Server is a comprehensive platform with an intuitive graphical user interface and robust functionality that enables users to handle a variety of database-related tasks both on-premises and in the cloud.
Key Features:
SQL Coding Assistance
AI Assistant Integration
Source Control
Index Manager
Unit Test
Table Designer
Database Designer
T-SQL Debugger
Query Profiler
Schema Compare
Data Compare
Data Generator
Documenter
Query Builder
Data Export and Data Import
Database Administration
Server Event Profiler
Data Editor
SQL Server Reporting
Master-Detail Browser
Pivot Table
Copy Database
Monitor
Find Invalid Objects
DevOps Automation
Optimized system resources consumption when preparing the Quick Info and Code Completion hints
Support for macOS & Linux via CrossOver You can always find the latest version of the product on the official Devart website.
Learn more
PopSQL
PopSQL is a collaborative SQL editor and workspace that connects everyone in the data analysis process so that teams can obtain better data insights and visualizations by asking the right questions, together.
* Get answers faster with real-time collaboration, version history, searchable shared queries and folders. We make it easy for your power SQL users and data analysts to work with business stakeholders
* Built-in data visualization & sharing lets you go from query to chart to Slack in seconds. Build, schedule and push real-time insights and dashboards, in just a few clicks.
* Our modern and elegant cloud-based workspace offers a rich SQL editing experience. Dive right in, connect to your databases and iterate on analyses from anywhere. We offer native macOS, Windows, and Linux clients.
* One workspace to get it done: PopSQL puts your database connections, shared credentials and an intuitive data catalog at your fingertips so you can access & mine your data, safely, securely
Learn more
RazorSQL
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC. Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures, functions, and more. Visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more. Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more. Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files. Includes a robust relational database (HSQLDB) that is up and running with no manual configuration out of the box.
Learn more
dbForge Studio for PostgreSQL
dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to customize your queries and property window so that users can view all the required information of PostgreSQL database objects they are interested in.
Key features:
* AI Assistant Integration.
* SQL Development. Save your time and improve code quality when creating and editing queries.
* Explorer. Navigate through the object tree and find any PostgreSQL object you want.
* Data Editor. Users can manage the settings of tables.
* Data Export and Data Import. Supports 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios.
* Query Profiler.
* Data and Schema Compare.
* Data Generator.
* Pivot Table.
Learn more
Pricing
Starting Price:
$210 one-time payment
Pricing Details:
$210 - Standard Edition
$420 - Extended Edition
$420 - Extended Edition
Free Trial:
Free Trial available.
Integrations
Company Information
Cardett Associates Ltd
Founded: 1999
New Zealand
www.querytool.com/index.html
Videos and Screen Captures
Database Explorer window
Other Useful Business Software
MongoDB Atlas runs apps anywhere
MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
Product Details
Platforms Supported
Windows
Training
Documentation
Support
Online
Advanced Query Tool (AQT) Frequently Asked Questions
Advanced Query Tool (AQT) Product Features
Database
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Monitoring
Performance Analysis
Queries
Relational Interface
Backup and Recovery
Mobile Access
NOSQL
Virtualization
