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
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
Database Tour Pro
Here are some areas where Database Tour has competitive advantages among database tools in the marketplace. Preparing database queries in SQL editors with syntax highlighting, code completion, and Ctrl+clickable objects. Multiple windows with separate transactions. There is a possibility to execute multi-statement SQL scripts. Collecting SQL execution statistics for each query window. Performing useful operations with databases, such as searching and replacing text, batch data processing etc. Database Tour data grids give you the ability to view CLOB/MEMO (large text) and graphic data, expand rows, use autoscrolling, sorting, selecting group of records, copying data etc. Data in tables can be highlighted depending on its content (so called conditional formatting). There is a tool for working with BLOB fields, such as large text and graphics.
Learn more
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
dbForge Studio for PostgreSQL
dbForge Studio for PostgreSQL is a GUI for PostgreSQL development, design, and management.
Key features:
AI Assistant: generate, fix, and optimize SQL with your choice of AI model, files, and instructions.
SQL Development: context-aware code completion, Parameter Info, Quick Info, and refactoring.
Query Builder: build complex queries visually without code.
Visual Object Editors: manage schemas, tables, functions, procedures, and event triggers.
Debugger: debug stored functions and procedures step by step.
Database Explorer: find any object, its data, or properties.
Data Editor: edit table data in a customizable grid.
Data Export and Import: 10+ formats and reusable templates.
Query Profiler: find slow queries and compare results after optimization.
Data and Schema Compare: sync data and schemas, and tables with Redshift.
Data Generator: realistic test data with real-time preview.
Pivot Table: group, summarize, and analyze data with charts.
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
Ship Agents Faster
Gemini Enterprise Agent Platform lets you rapidly build, scale, govern and optimize production-ready agents grounded in your organization's data. The platform enables developers to build custom or pre-built agents for virtually any use case. New customers get $300 in free credits.
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
Supported
Data Migration
Supported
Data Replication
Supported
Data Search
Supported
Data Security
Supported
Database Conversion
Supported
Monitoring
Supported
Performance Analysis
Supported
Queries
Supported
Relational Interface
Supported
Backup and Recovery
Not Supported
Mobile Access
Not Supported
NOSQL
Not Supported
Virtualization
Not Supported
