--- title: Advanced Query Tool Reviews meta\_title: 'Advanced Query Tool Reviews 2026: Details, Pricing, & Features | G2' meta\_description: Filter reviews by the users' company size, role or industry to find out how Advanced Query Tool works for a business like yours. aggregate\_rating: rating\_value: 4.8 review\_count: 9 scale: '5' date\_modified: '2026-07-12' parent\_category: name: Database Software url: https://www.g2.com/categories/database-software --- # Advanced Query Tool Reviews & Product Details Claimed ###### Profile Status This profile is currently managed by Advanced Query Tool but has limited features. Are you part of the Advanced Query Tool team? [Upgrade your plan](https://my.g2.com/advanced-query-tool/upgrade?utm_campaign=s3&utm_medium=claim-popup&utm_source=g2) to enhance your branding and engage with visitors to your profile! Advanced Query Tool is a multi-database query and admin tool. It can connect to any ODBC Database and has been configured individually for 30 different database types including Oracle, DB2/LUW, DB2 z/OS, DB2/iSeries, MySQL, SQLServer, PostgreSQL. AQT has a rich and fully-featured query environment with query editor, query builder, table editor and data export. The Extended Edition has additional features for DBAs and Developers. This include Database Admin (create / alter objects), DDL Generator, Data Loader, Data Compare / Resync, Object Compare / Resync, System Monitor * * * Seller [AQT New Zealand](https://www.g2.com/sellers/aqt-new-zealand) Discussions [Advanced Query Tool Community](https://www.g2.com/products/advanced-query-tool/discuss) Languages Supported English Overview by Nick Reed Show More ## Pricing Pricing provided by Advanced Query Tool. ### Standard Edition $249.00 Per Year ### Extended Edition $449.00 Per Year [ View More Pricing Information ](https://www.g2.com/products/advanced-query-tool/pricing) ## Top-Rated Alternatives [ ![Toad For Oracle](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Toad For Oracle") Toad For Oracle 4.4/5(286) ](https://www.g2.com/products/quest-software-toad-for-oracle/reviews) [ ![Microsoft SQL Server](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Microsoft SQL Server") Microsoft SQL Server 4.4/5(2,286) ](https://www.g2.com/products/microsoft-sql-server/reviews) [ ![DbVisualizer](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "DbVisualizer") DbVisualizer 4.7/5(269) ](https://www.g2.com/products/dbvisualizer/reviews) [ View All Alternatives ](https://www.g2.com/products/advanced-query-tool/competitors/alternatives) ## User Insights Average based on 9 real user reviews. Typical contract price $0k - $0k [Sign in to view](/login) Per Year [Log in to unlock pricing and user insights](/login) ![Ravi K.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Ravi K.") RK Ravi K. Technology Lead Enterprise (\> 1000 emp.) 6/7/2024 "Best tool for sql development with Interactive UI" 4.5/5 What do you like best about Advanced Query Tool? Advanced Query Tool can be used to connect to any ODBC Database which are commonely used now a days example oracle, mysql, postgrey. It provide very interactive UI to work with database DML, DDL operations, data and objects compare etc. Review collected by and hosted on G2.com. What do you dislike about Advanced Query Tool? Nothing I can think of now. I think it has complete package for my uses. Review collected by and hosted on G2.com. What problems is Advanced Query Tool solving and how is that benefiting you? It save my lot of efforts for sql development. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Georg R.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Georg R.") GR Georg R. Senior Data Scientist Utilities Enterprise (\> 1000 emp.) 3/31/2023 "AQT for the rescue when I need data" 5/5 What do you like best about Advanced Query Tool? The best thing about AQT is that it allows me to search for columns and contents of the database, which makes it much easier to find the right tables and views. Review collected by and hosted on G2.com. What do you dislike about Advanced Query Tool? There's not much not to like here. The tool works fine, sometimes it takes a while to load information but that's just because our data warehouse is that big and sometimes the connection is slow. Review collected by and hosted on G2.com. What problems is Advanced Query Tool solving and how is that benefiting you? AQT helps me to find the right data in a short amount of time, allows me to write perfect and errorfree and efficient SQL queries and therefore makes my job as a data scientist easier. Review collected by and hosted on G2.com. Show More 4/7/2023 Current UserValidated ReviewerIncentivizedSource: G2 invite ![Verified User in Computer Software](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Computer Software") UC Verified User in Computer Software Enterprise (\> 1000 emp.) 11/3/2019 "Advanced Query Tool- As the name suggests It is the best and simple tool to fetch data from the data" 4.5/5 What do you like best about Advanced Query Tool? It has lot of user-friendly options,where in easily one can edit the data with edit option and while writing the query it shows some smart options where in column name pops-up, which makes the work easier,and there is option to retrieve your old queries. Review collected by and hosted on G2.com. What do you dislike about Advanced Query Tool? When you fetch more than 5000 rows...if you press a cancel option while displaying, AQT hangs completely and you need to start from the beginning. Review collected by and hosted on G2.com. Recommendations to others considering Advanced Query Tool: It is very simple and best and query tool which has very good user interface Review collected by and hosted on G2.com. What problems is Advanced Query Tool solving and how is that benefiting you? Through AQT we are verifying whatever the Data entered through mainframe program as well as online screen is valid, and by taking the production queries where the problem is being occurred , we can check exactly what might have happened, is it because of data issue or programmer fault. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerSource: Organic ![Bill S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Bill S.") BS Bill S. BI Solution Architect Enterprise (\> 1000 emp.) 7/2/2019 "AQT, simple, feature rich, fast, and my tool of choice for the last 10 years!" 5/5 What do you like best about Advanced Query Tool? I've been using AQT for over 15 years and found it to be the best tool for my role as a data warehouse architect and data analyst in multiple database enviroments. There are many capabilities for point and click data analysis, queries creation, loading and exporting data. My favorites include 1) a point and click data loader that generates your create table statement when creating a new table and includes the ability to add column expressions to alter/clean your source data during the load, 2) a visual data explorer to view your sql result set and easily total, sort, format, and group it(grouping is done by dragging columns to the header and groups can easily be collapsed/expanded and show column subtotals);You can also freeze columns on the left to for easy viewing of wide result sets, copy any row or rows to excel or other tool including column headings and get totals by highlighting adjacent columns, 3) a robust visual query builder that has the ability to easily create sql including complex sub-queries, supports with clauses and can save your table relationships for re-use and 4) built in scripting to easily automate repetitive processes like regression testing. An advanced version also includes a base set of database administration tools. Review collected by and hosted on G2.com. What do you dislike about Advanced Query Tool? The only thing that I dislike is the limits on identification of sql errors because of ODBC limitations. Query tools that use native drivers instead of ODBC for example sql developer can identify more detail about sql syntax errors. Review collected by and hosted on G2.com. What problems is Advanced Query Tool solving and how is that benefiting you? I have used AQT extensively for analysis of data in preperation for architecting data warehouse solutions. The analysis capabilies especially interactive result set grouping has repeatedly helped me quickly analyze query results and idenfity patterns and inconsistencies. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ML Mark L. Application Systems Engineer Enterprise (\> 1000 emp.) 6/12/2019 "AQT is simply the best." 5/5 What do you like best about Advanced Query Tool? We have been using AQT at my company for many years, mainly with DB2 z/OS - but with many other databases as well. Hands down it beats all other SQL tools, and its abilities to manage tables, views, table spaces, indexes and other objects in DB2 REALLY put it a cut above. Search around for SQL/database Tools for DB2 z/OS ans see what you find from anyone other than IBM - you wont find much at all. And IBM itself has nothing to compare. Even if used as a pure SQL query tool, its abilities to manipulate the data AFTER you retrieve it from the database are amazing. It also has one fo thebest interfaces with Excel, to output the data, that I have seen. No, I am not being paid to write this! We have over 300 people using AQT and wouldn't trade it for anything. Review collected by and hosted on G2.com. What do you dislike about Advanced Query Tool? Sometimes the licensing, particularly the "registering" of the license with the vendor can be a little bit clunky. Review collected by and hosted on G2.com. Recommendations to others considering Advanced Query Tool: Get it and use it! Review collected by and hosted on G2.com. What problems is Advanced Query Tool solving and how is that benefiting you? Easy user access to data inside DB2 z/OS and Oracle databases, as well as database structural management for Admins. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic JS Jeff S. Sr Software Engineer Enterprise (\> 1000 emp.) 6/19/2019 "Best all around SQL tool " 5/5 What do you like best about Advanced Query Tool? The user interface makes it easy and quick to see all the most relevant information. I can filter the lists of tables/views/schemas, quickly see indexes, keys, constraints, columns, and data without wasting time. It performs all the tasks I need day to day without a lot of hassle and is very configurable. The author is quick to respond to and correct issues. Review collected by and hosted on G2.com. What do you dislike about Advanced Query Tool? I wish it could save all open query windows with a single mouse click and then reopen all of them upon reopening the program. The data import can be slow for large datasets, so I often resort to BCP to perform those imports. Review collected by and hosted on G2.com. Recommendations to others considering Advanced Query Tool: Its the most well thought out tool out there for day to day use. Review collected by and hosted on G2.com. What problems is Advanced Query Tool solving and how is that benefiting you? My day to day SQL development. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Verified User in Automotive](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Automotive") AA Verified User in Automotive Enterprise (\> 1000 emp.) 6/17/2019 "Small footprint, super fast, super flexible, super intuitive database administration and query tool" 5/5 What do you like best about Advanced Query Tool? I use the tool mainly for administration of DB2 z/OS and LUW installations of various release levels. Navigation is very intuitive and super fast. Best I ever experienced with DB2. The many text and SQL generation tools are a great help. The Compare feature is amazingly flexible. Apart from the task of setting Automatic Maintenance (like maintenance window, task scheduler) or extensive mainframe schema change, the tool brings all what I need for my day-to-day tasks, and that has been true for the last 15 years. And if you miss something, or if you spot a flaw in the display or catalog queries, you simply write a mail to the AQT team and they fix it within a few days, or you fix it yourself in the configuration file (which is open and easy to understand). I love the feature that opens a session with the database host to run DB2 commands. Review collected by and hosted on G2.com. What do you dislike about Advanced Query Tool? Sometimes - especially after DBMS release changes - the DDL generator is not able to resolve new default values. But as mentioned, you can address it and it gets fixed quickly. I would love to have the DB2 Visual Explain graphical representation integrated into the tool. The existing Explain feature works fine, but with more complex SQL the many lines of output are hard to read. A picture would help. What I would like to have is a generator that generates text based on the result of an SQL. Of course, you can write this SQL yourself, but it would be nice to have a screen for it, like the Generate Text Screen. This one only allows generating text based on listing in the middle grid, which you can easily filter. But, generating text based on self-written, more complex SQL is currently not available in the tool (to my knowledge). For heavy Stored Procedure development the tool is not sophisticated enough when it comes to bind parameters, environment settings etc. If you develop light-weight SPs for administration or simple applications, the tool provides all you need. Review collected by and hosted on G2.com. Recommendations to others considering Advanced Query Tool: For DB2 database administration I have not seen anything as intuitive, fast and easy to use as AQT. Review collected by and hosted on G2.com. What problems is Advanced Query Tool solving and how is that benefiting you? I use AQT 98% of the time for my DB2 LUW DBA tasks, and this covers the full end-to-end service from data analysis, physical database design, implementation, monitoring, performance analysis, server migration. For DB2 z/OS I use AQT for all analysis work and the low- to mid-level DDL generation tasks. Navigation is very fast, you can run tasks in batch. AQT does not require any maintenance, and it comes with a very fair pricing. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Verified User in Financial Services](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Financial Services") UF Verified User in Financial Services Enterprise (\> 1000 emp.) 6/10/2019 "My weapon of choice" 5/5 What do you like best about Advanced Query Tool? I have been using AQT for over 10 years now, and I prefer it over the other bloated tools on the market, including IBM's and Oracle's own products to connect to their own databases. AQT can connect to most of the RDBMS's and presents a familiar interface, so you don't have to worry about losing functionality between databases. Their customer service is also fast and reliable. Review collected by and hosted on G2.com. What do you dislike about Advanced Query Tool? Nothing that I can think of apart from some minor things which I think could use improvement in a future release. Review collected by and hosted on G2.com. What problems is Advanced Query Tool solving and how is that benefiting you? The ability to query databases. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ## Questions about Advanced Query Tool? Ask real users or explore answers from the community Get practical answers, real workflows, and honest pros and cons from the G2 community or share your insights. [ Ask about Advanced Query Tool ](https://www.g2.com/products/advanced-query-tool/discussions/new) GU Guest User What is Advanced Query Tool used for? 0 Upvotes 0 [ Join the conversation ](https://www.g2.com/discussions/what-is-advanced-query-tool-used-for) [ View all Discussions ](https://www.g2.com/products/advanced-query-tool/discuss) ## Pricing Options Pricing provided by Advanced Query Tool. ### Standard Edition $249.00 Per Year ### Extended Edition $449.00 Per Year [ View More Pricing Information ](https://www.g2.com/products/advanced-query-tool/pricing) Advanced Query Tool Comparisons ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_3f9ef6d100f902fb520e5ac72d5396c4/quest-software-toad-for-oracle.jpg "Product Avatar Image") Toad For Oracle 4.4/5(286) [ Compare Now ](https://www.g2.com/compare/advanced-query-tool-vs-quest-software-toad-for-oracle) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_0d3b67827912f22174857de9475977c9/microsoft-sql-server.jpg "Product Avatar Image") MS SQL 4.4/5(2,286) [ Compare Now ](https://www.g2.com/compare/advanced-query-tool-vs-microsoft-sql-server) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_87e3eb0824a9d17bdfe4e953f5c0d127/dbvisualizer.png "Product Avatar Image") DbVisualizer 4.7/5(269) [ Compare Now ](https://www.g2.com/compare/advanced-query-tool-vs-dbvisualizer) ##### Categories on G2 [Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms) ##### Explore More [Which financial aid software platforms have strong customer support for families having difficulty with online applications?](https://www.g2.com/discussions/which-financial-aid-software-platforms-have-strong-customer-support-for-families-having-difficulty-with-online-applications)[Top rated compliance app for office security](https://www.g2.com/discussions/what-s-the-top-rated-compliance-app-for-office-security)[Top platforms for generating detailed material cost breakdowns](https://www.g2.com/discussions/what-are-the-top-platforms-for-generating-detailed-material-cost-breakdowns-in-construction-estimating) [Top platforms for hiring software developers](https://www.g2.com/discussions/top-platforms-for-hiring-software-developers)[Which Oracle PeopleSoft resellers ensure payroll accuracy and regulatory compliance during system transitions for organisations in highly regulated environments?](https://www.g2.com/discussions/which-oracle-peoplesoft-resellers-ensure-payroll-accuracy-and-regulatory-compliance-during-system-transitions-for-organisations-in-highly-regulated-environments)[Which API management software offers the best analytics?](https://www.g2.com/discussions/which-api-management-software-offers-the-best-analytics) [Show MoreShow Less](javascript:void(0);)