Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing DBeaver vs AQT, the Slant community recommends DBeaver for most people. In the question“What are the best SQL Clients for Windows?” DBeaver is ranked 1st while AQT is ranked 24th. The most important reason people chose DBeaver is:
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Specs
Question Ranking
Pros
Pro Cross-platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Pro Free
It is licensed under GPL v2.
Pro Works for many types of databases
MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source.
Pro Follow foreign key to their primary key
If you have a table with a foreign key you can click on it to see the table row where this key references to.
Pro Formatted text view
It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A.
Pro Easy to use, clean neat inteface
Pro Intuitive visual data explorer
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.
Pro Easy scripting language for repeatable processes
Pro Point-and-click data loader
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.
Pro Visual query builder
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.
Cons
Con Never-ending function errors
Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1).
Con Cannot view function
Con Trigger edition
Until version 3.5.8 you can not edit triggers, only view (since 3.5.6).
