The review below shows some of the most useful and popular development tools for Mac, Windows and Linux, for beginners and professionals. Among these tools is particularly highlight SQLyog, dbForge, PhpMyAdmin, MySQL Workbench, HeidiSQL and SequelPro.
MySQL Workbench (Win, Linux, Mac)
This application is a full-featured tool for working with data, it includes database design, modeling, creation and maintenance grouped into a single development environment data for MySQL. Free Download - Community Edition, which contains features that will satisfy virtually all your needs. If you will not miss any features, you can always go to the commercial version (Standard Edition).
dbForge Studio for MySQL
dbForge Studio - flexible professional database tool for developers and users of MySQL. It automates the routine task of developing and administering database MySQL, and also opens up new opportunities for a better result.
You can easily develop SQL scripts, stored procedures and functions, write and execute queries, edit data, perform the export and import, manage users, edit database objects, work with the project database, and much more.
Features:
- Database designer for visual building of the database structure
- Debugging SQL and stored code
- Improved project management database
- Master data comparison
- Master of comparison circuits
- Visual object editors
- Autocomplete code
- Browse code
- Template Library
- Checking SQL syntax
- Environment
- Visual creation and editing of queries
- Search database objects
- DB Explorer
- Session manager
- Administration Tools
- Regulation Transaction
- Information about the parameters
- Safety Manager
- Masters of export and import database
HeidiSQL - (Win, Linux)
Heidi SQL - easy and fast, flexible interface, it allows you to view and edit your databases, manage tables, view and edit records, manage user privileges, import data from text files, run SQL queries, synchronize tables between two databases and export the selected tables in other databases or SQL-scripts, all with an intuitive interface Windows.
Aqua Data Studio (Win, Linux, OS X, Solaris)
This IDE is composed of four main areas of functionality: working with queries and administrative tools, tools to compare databases, source control and filesystems; integrated version control tool Subversion (SVN) and CVS, and a powerful tool for modeling databases. Studio provides a single interface to all major relational databases, it allows the developer to simultaneously solve several problems in a single application.
phpMyAdmin
This very popular, with great potential and at the same time easy to use free tool written in PHP, it was created for the development and administration of MySQL. He can create and drop databases, create / delete / alter tables, delete / edit / add fields, execute any SQL-commands, manage users and permissions for them. Another interesting feature of this legendary tool is that you can download and change the theme, download themes here: phpMyAdmin Themes.
SQLyog MySQL GUI (Win)
SQLyog is another popular SQL-tool, which has several useful functions, such as visual pattern designer, visual query builder, avtovstavka commands and synchronization of data / structures. It supports HTTP / HTTPS / SSH Tunneling and SSL connections. You can also define the work of a manager, to set a scheduled backup of databases and use the service of notices that will remind you when any work will be completed. There is a free Community version and a commercial Enterprise Edition. You can also use MONyog, MySQL Monitor and Advisor.
MySQL-Front (Win)
This is a GUI for MySQL databases is a "real" application, it can offer a more refined user interface than is possible in systems built on PHP and HTML. Instant response, as there is no delay when you restart the HTML-pages. If your provider allows, MySQL-Front you can connect to the database. Otherwise, you need only install a small script on the site. Information on the login is stored on your hard drive so that you no longer need to log onto different web interfaces.
Sequel Pro (Mac OS X)
Эта MAC OSX приложение управления базы данных предоставляет вам прямой доступ к вашей MySQL базе данных на локальных и удаленных серверах с поддержкой импорта и экспорта данных из популярных файлов, включая SQL, CSV и XML. Sequel Pro провозгласил себя "Лучший средством управления базами данных MySQL для Mac OS X".
SQL Buddy (Web-App)
This is a powerful tool for database management is truly amazing. He is very, very easy to install, just unzip the folder on the server and all. As for updates, then uninstall the old version and replace it with a new version, everything is simple.
EMS SQL Manager (Win)
EMS SQL Manager is a very powerful tool for administration and database development. Features include: MySQL triggers, views, stored procedures and functions, foreign keys, InnoDB, it allows you to create and edit all database objects MySQL, visually designing databases, scripting SQL, import and export data, manage users and their privileges, and many other useful features. There is a commercial version, but you can download a free version, it is quite powerful and offers many opportunities.
Navicat Lite MySQL Admin Tool (Win, OS X, Linux)
Navicat is a fast, reliable and popular (millions of downloads), database administration tools, a specially built to simplify database management and reducing administrative costs. Designed to meet the needs of database administrators, developers, and small and medium-sized enterprises, Navicat is built with an intuitive graphical interface that allows you to create, organize, access and share information in a safe and easy way. Navicat Lite is available for free download for non-commercial customers.
DreamCoder for MySQL (Win)
DreamCoder works with all MySQL versions from 3.23 to 6.0 and supports all functions of MySQL, including tables, views, procedures, functions, triggers, tables, InnoDB, foreign keys, UDFS, BLOB Types, etc. It also includes advanced data management capabilities, allows you to visually build queries, execute queries, execute scripts, generate reports, monitor the database and to export and import data to / from most popular file formats. DreamCoder for MySQL is an easy to use for novice users of MySQL and is powerful enough for any experienced user.
Toad MySQL (Win)
Toad for MySQL - a tool for development and administration of databases, which provides high capacity for quickly building and executing queries and managing complex database systems. It provides utilities to compare, extract and search for objects, manage projects, import / export data and administer the database.
DB Tools Manager Professional (Win)
DBManager is quite a powerful application for data management. With built-in support for MySQL, PostgreSQL, InterBase / Firebird, SQLite, DBF tables, MSAccess, MSSQL Server, Sybase, Oracle and ODBC databases, making it one of the most advanced database applications. Free Edition (Standard Edition) has many features making it ideal for new users of the database to perform the basic functions of database management, you can use it for non-commercial purposes.
MyDB Studio (Win)
MyDB Studio is a complete set of powerful tools for server administration MySQL. MyDB Studio (Freeware) is designed for MySQL-developers and administrators, for operational management, creating and executing queries, and more effective development of SQL and PHP-code.
MySQL Sidu (Win)
MySQL Sidu is a free MySQL-client, which works through a web browser, it is a simple, intuitive tool. Sidu not as powerful as other similar tools, but he deserves his place in this list, its functions may be limited, but it does exactly what its name says (Sidu means Select Insert Delete Update).
You can also use a special browser plug-in Firefox, that allows you to insert data from text fields and textarea in a web page. Firefox addon for MySQL Sidu.
