SQL Maestro for MySQL
Complete and powerful database management, admin and development tool for MySQL and MariaDB.
|
Detailed info
SQL Maestro for MySQL is the premier tool for MySQL and MariaDB database management, control and development. It provides a rich set of GUI tools for anyone who uses MySQL and/or MariaDB including database developers, DBAs, and data analysts. Key features include:
- Support for all the MySQL server versions from 3.23
- Direct support for MariaDB-specific features
- Easy database object management
- Database Designer
- Comfortable access to MySQL security features
- Data management and data analysis tools
- Handy SQL Editor with code folding and multi-threading
- Visual Query Builder with support for subqueries and UNIONS
- Data export/import to/from the most popular formats
- Database schema refactoring tools
- Powerful BLOB Viewer/Editor
- Working with remote MySQL servers via SSH or HTTP tunnel
All these features and intuitive interface make SQL Maestro for MySQL an irreplaceable tool for MySQL and MariaDB on the web or at your local desktop.
Top 10 reasons to use SQL Maestro for MySQL
Latest MySQL/MariaDB versions support SQL Maestro for MySQL supports all the latest versions of MySQL and MariaDB |
Use our product to work with any MySQL or MariaDB version! SQL Maestro for MySQL supports events and table partitioning, views, stored procedures/functions and triggers, InnoDB foreign keys, Unicode data, and many more.
Powerful security management MySQL security system is easy and clear in SQL Maestro for MySQL |
Tune up your MySQL server security policy with several mouse clicks. SQL Maestro for MySQL provides you with a number of powerful editors, that make management of MySQL users and their privileges as easy as it can be, even if you are not a skilled MySQL administrator. The SSH tunnel gives you an opportunity to connect to a remote MySQL server in the most secure way that could ever been.
Easy database objects management SQL Maestro for MySQL is incredibly easy in database objects management |
Windows clipboard, drag-and-drop operations, local pop-up menus - all of them can be used with database objects now! For example, to copy an object, simply drag and drop the object from one database to another, or use the Ctrl+C and Ctrl+V shortcuts instead of performing a long succession of manual operations.
Clear in use Even a newbie can use SQL Maestro for MySQL |
SQL Maestro for MySQL as easy in use as Windows explorer! SQL Maestro for MySQL provides you
with an understandable "explorer-like" navigation style, well-described wizard system, quick launch panel, and a lot of other tools and features, which do not require a deep knowledge of MySQL.
Advanced SQL Editor SQL Maestro for MySQL allows you to create and execute queries in the most convenient way |
Handy SQL Editor provides you with an ability to execute several queries simultaneously. Each query is executed in a separate thread, so all SQL Maestro for MySQL opportunities remain available and there is no need to wait for your complex query to be completed. Such features as syntax highlighting and code completion make your work with the Editor extremely comfortable.
Powerful data export and import SQL Maestro for MySQL provides you with advanced data export and import abilities |
SQL Maestro for MySQL supports more than twelve formats for data export and six formats for data import. These are MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, CSV, DBF and more. Moreover,
SQL Maestro for MySQL does not require any additional software installed for all the supported formats.
Full support for BLOB fields SQL Maestro for MySQL has an ability to view BLOB data in various ways |
Using SQL Maestro for MySQL you can view or edit BLOB data in the following ways: hexadecimal dump, plain text, graphical image or HTML page. A graphical representation of BLOB data supports five image formats: BMP, Windows metafile, JPEG, GIF and PNG.
Viewing data as diagrams SQL Maestro for MySQL allows you to build diagrams based on MySQL data |
This exclusive feature represents numeric data from a table or a query result as a diagram
with a possibility of customizing its appearance in various ways. You
can also easily export the diagram to the following formats: BMP, Windows
metafile, PDF, JPEG, PNG and more.
The fastest way for building queries SQL Maestro for MySQL allows you to create the SELECT statements visually |
The Visual Query Builder
is a powerful tool of SQL Maestro for MySQL intended for designing queries
as visual diagrams. This tool does not require any knowledge of the
SELECT statement syntax, it will form a query automatically, you just need to mark what information do you want to retrieve.
Full customization according to your preferences and needs SQL Maestro for MySQL admits to flexible customization |
In SQL Maestro for MySQL you can customize the behavior of all its tools, select a user interface scheme and set a lot of other various preferences.