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

In-purchase Benefits

  • FREE One Year of Maintenance already included!
  • FREE software updates and upgrades during Maintenance period!
  • FREE and unlimited Technical Support during Maintenance period!
  • Reasonable pricing for Maintenance renewal – from 35% per Year!
  • Volume discounts when buying two or more copies of one product
  • Cross-selling discounts on related products
  • 30-day money-back guarantee

Product screenshots

Visual Query Builder - setting query criteria
Visual Query Builder - setting query criteria
Visual Query Builder - sorting output fields
Visual Query Builder - sorting output fields
Filtering data
Filtering data
Grouping data
Grouping data
Browsing query history
Browsing query history
Working with favorite queries
Working with favorite queries

SQL Query for MySQL

Get started with SQL Query for MySQL

Download a fully-functional 30-day free trial, and start saving time with your database management today.

Download free trial

Got questions?

If you'd like any help, or have a question about our tools or purchasing options, just get in touch.

Related Products