Data Query Tool for Mac

Data Query Tool, one flexible Query-Tool for all ODBC and Sqlite databases!
One for all
Each DBMS has its own highly specialized and complex management or query tool. While working at different DBMS, you need to change the tool regulary. Even if you just want to run some SQL commands quickly. With the Data Query Tool from Solution Research you don't need to change the system. It is easy to use.
What can you do with DQT?
The Data Query Tool from Solution Research provides access to any ODBC and SQLite databases. You can analyse, insert, delete and edit data and execute any kind of SQL statements that the database management system supports. Result sets from a SELECT statement will be shown as a data grid or optionally as flown text. Data can be edited directly in the cells of a data grid.If certain SQL commands are used again and again, you can create a script of it. In addition these scripts handle commands for flow control (IF, WHILE, ...), independently of the used DBMS to automate various processes.
At a glance
- On Mac OS X connect directly to Microsoft SQL Servers, MySQL Servers and SQLite without any other software needed
- Connect to most other ODBC Database as long as an driver is installed
- Connect to multiple databases at the same time
- Browse database tables and views in a data grid
- Modify data within the data grid (add new records, edit, delete)
- Export result sets to HTML or CSV files (delimiter separated)
- Create scripts to automate queries
- Execute any valid SQL Statement the database management support
Connect to a Database via ODBC
![]() If you want to use dqt to connect to other ODBC data sources than this, you can use the Connect command. |
CONNECT(name="apache_log", odbc="DRIVER={ResPath}/lib/libmyodbc5w.so;server=192.168.1.1;DATABASE=apachelogs;user=a_login;password=my_secret;option=3;");
Script Editor
![]() After entering some commands and SQL statements they can be executed and the result will be displayed as a data grid or in output area as floating text. Contect sensitive help and IntelliSense technic helps writing SQL statements. |
Data Grid
Result sets of a SELECT statement or selecting a table in the connection tree will be shown in a Data Grid.![]() Table content can be edited depending on the current query mode, the access rights and cell content. In fact the dqt generates internally SQL UPDATE, INSERT and DELETE statements to modify table data. It's important that dqt can scan the query and identify a unique key for every row in the table. Just thant it's possible to modify data. Is a single cell active the Del key delete the data (in fact set it to the special value NULL) and the clipboard key commands work as well (Ctrl+X, Ctrl+V, ...). |
HTML Export
![]() ![]() This files can be imported into most other software, like Excel, OpenOffice and least but not last into any TextEditor for further processing. |
Customizable Layout
![]() ![]() |
Ready for macOS Sierra and Windows 10
![]() |
You operate with Windows 7, 8, 8.1 or with Windows 10?
No problem! The DQT is also optimized for these operating systems.
Don’t hesitate to ask about a Linux version.
![]() |