Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Renaud Lepage: "I was searching for a powerful server management as well as data management application, that could also have the ability to use stored procedures (MySQL5). I was using many separate apps. And then I stumbled upon this application. It just got better. With ease-of-use, powerful management, a very good level of customization, great MySQL server management and the very lushed graphical interface, MySQL Maestro is a product to consider seriously. I chose MySQL and this, to SQL Server 2000 and the MMC-integrated server management, for use in a programming course. I'm telling you, MySQL Maestro is a very powerful tool. Try it, you won't regret it".
Charles Richardson: "In particular, the graphical schema design module is wonderfully smooth and responsive".

More

Add your opinion

SQL Maestro for MySQL online help

  Return to chapter overview Next

Welcome to SQL Maestro for MySQL!

SQL Maestro for MySQL is the premier Windows GUI admin tool for MySQL development and management. It allows you to make all the database operations easy and fast.

 

Basic SQL Maestro for MySQL features

 

Support of the latest MySQL features

Use SQL Maestro for MySQL to work with MySQL from 3.23. Among other features and objects implemented in the latest versions of the server, our software supports roles, stored procedures, functions, triggers, character sets, collations, check constraints, tables partitioning, and a lot of other useful things.

 

Easy database management

SQL Maestro for MySQL allows you to work with remote servers with restricted access via SSH or HTTP tunneling. SQL Maestro for MySQL allows you to create new databases and drop existing ones. Database profiles give you the opportunity to connect to databases in one touch and work with the selected databases only. See the Database Management for details.

 

Powerful database object management

SQL Maestro for MySQL provides you with an ability to manage database objects in various ways. For example, you can perform operations with a group of objects as well as with a single object in Object Manager, sort, group and filter the database objects within Object Browser, copy an object from one database to another by a drag-and-drop operation inside the explorer tree, use Windows clipboard to copy a set of objects and so on. For details turn to the Database Object Management section.

 

Working with tables and table subobjects

SQL Maestro for MySQL wizards and editors allow you to create, edit and drop tables as well as their fields, indexes, and foreign keys in a couple of simple operations. See the Tables section to learn more.

 

Building and executing queries

SQL Maestro for MySQL provides two powerful tools which allow you either to edit query text directly with syntax highlighting and code completion or to build a query diagram visually selecting tables and fields, setting links between tables and so on. You can find the detailed description in the Queries section.

 

Powerful data management tools

SQL Maestro for MySQL puts at your disposal a complete set of data management tools with viewing, editing, grouping, sorting and filtering abilities, lookup editors, master-detail data view, BLOB Viewer/Editor, data export, data import and SQL dump modules and more.  See the Data Management to learn the details.

 

Wide choice of additional tools

SQL Maestro for MySQL provides you with a number of tools for working with database metadata and SQL scripts, including Script Runner, SQL Script Editor with code folding and script explorer. Moreover, it gives such tools as Schema Designer, BLOB Viewer, Diagram Viewer, Data Analysis, SQL Generator, Report Designer, and a lot of others. To learn more, see the Database Tools section.

 

Security management

SQL Maestro for MySQL gives you a comfortable access to MySQL security features.

 

Full customization according to your preferences and needs

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 preferences. All the options and their meanings are listed within the Options dialog description.

 

 



  Return to chapter overview Next