Testimonials

When we changed our DBMS to PostgreSQL a couple of years ago, I tried many DB-clients, before I found SQLManager. The ease of use of SQLManager is impressive! The clear and well structured GUI makes the daily work done easy. In addition EMS' customer support is just fabulous! Further on: Good speed!

Markus Reidt
Nordmann, Rassmann GmbH, Hamburg

More | Your testimonial

Our Partnership Status

News

03/31/2020
SQL Query version 3.4.1 released
Added support for Azure database, SQL Server 2017, MySQL Server 8, PostgreSQL 12 and Firebird 3.0, some fixes in query editor and more...

03/29/2012
SQL Query version 3.4 released
Added the possibility to save SSH connection settings, and other improvements and bug-fixes...

07/27/2011
SQL Query version 3.3 released
Added the automatic display of the JOIN statement for tables with foreign keys in Query Builder, the correct data sorting, and much more…

10/08/2008
SQL Query version 3.2 released
Unicode data support added, visual building of the FROM statement subqueries is now possible, and other improvements and fixes…

04/02/2008
SQL Query version 3.1 released
Faster connection to databases, the ability to save program settings to a REG file is added, and other improvements and bug-fixes...

06/06/2007
SQL Query 2007 released
Support for UNICODE-data in the grid, asynchronous query execution, improved SSH tunneling support and more….

News Subscribe | More News

XML content. Requires RSS support to view.

EMS SQL Query for MySQL

Print this Page

Overview

EMS SQL Query for MySQL is a useful tool that lets you quickly and simply build SQL queries to MySQL databases. Visual MySQL query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to MySQL databases, select tables and fields for a query to MySQL server, set the selection criteria and much more. Using this query utility you can work with several MySQL queries at once, edit query text in the powerful SQL editor, view the execution results in different modes, create MySQL queries with unions and subqueries visually, build diagrams based on queries, view MySQL query execution plans and perform any other operations you may need in your work with MySQL database queries.

Key Features

User-friendly graphical interface
Latest MySQL versions support
Support of UTF8 data
Asynchronous query execution
Connect through SSH tunnel: establish connection to an intermediate SSH server and forward all MySQL commands through the secure tunnel
Connect through HTTP tunnel in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to MySQL
Using drag-and-drop operations when selecting tables and fields for a query visually
Working simultaneously with several queries in separate windows
Registering selected databases to work with
Multiple database connections
Navigation within recently used queries and selecting the required queries
Syntax highlight, "quick code" and keyboard templates for faster editing query text
Tools for data grouping and filtering
The ability to create queries with unions and subqueries visually
The ability to create diagrams based on queries
Capabilities for viewing query plans
Powerful BLOB viewer/editor with several types of viewing BLOB data
Flexible personalization of graphical user interface
Multi-language GUI support