EMS SQL Query for MySQL is an utility that lets you quickly and simply build SQL queries to MySQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and many more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.
Key Features:
- User-friendly graphical interface
- Latest MySQL versions support: compatibility with all MySQL versions from 3.23 to 6.x
- 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