SQL Maestro Group's "Maestro" line of products provide GUIs for the management of popular databases, including MySQL, SQL Server, and Oracle, among others. Among their current offerings (which are available separately) are:
- SQL Maestro for MySQL is a Windows GUI for MySQL server administration and database development. According to the vendor, it supports all the latest versions of MySQL server and is a stand alone application as it does not require a client library to connect to SQL.
SQL Maestro for MySQL provides you with a security manager, which allows you to manage MySQL users and their privileges even if you are not a skilled MySQL administrator. SSH tunneling allows you to connect to a remote SQL server is a secure way.
Other features include:
- Windows clipboard, drag-and-drop operations, local pop-up menus
- An "Explorer-like" navigation style, wizard system, quick launch panel for performing the most common operations
- Support for the server feature implemented in MySQL 5.0
- Create, drop and edit stored procedures and functions, execute them with manually specified input parameters and view the results of the execution
- More than twelve formats for data export and six formats for data import are supported by MySQL Maestro. Among the supported formats are MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, CSV, DBF and more. SQL Maestro does not require any additional software installed for all the supported formats
- View or edit BLOB data in the following ways: hexadecimal and binary 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
- Diagrams Build represents numeric data from a table or a query result as a diagram with the possibility of customizing its appearance in various ways. You can also export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more
The SQL Maestro for MySQL Visual Query Builder is designed for designing queries as visual diagrams. This tool does not require any knowledge of the SELECT statement syntax, but allows you to retrieve any data from the SQL database.
- Oracle Maestro provides you with a number of tools to perform database operations such as creating, editing, and duplicating database objects; moreover, you can build queries visually, execute and optimize SQL queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), and more.
- MS SQL Maestro is a GUI admin tool for Microsoft SQL Server 7/2000/2005/2008 and MSDE management, control and database development. With it, you can create, edit, copy, extract and drop database objects; moreover, you can build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from file formats, manage Microsoft SQL Server users and their privileges, add jobs and alerts, etc.