Manufacturer: Sun Systems/Oracle Website: Price: FREE License: GPL License Supported platforms: Microsoft Windows, Mac OS X and Linux MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single development environment. It is the successor to DBDesigner 4 from fabFORCE.net and replaces the MySQL GUI Tools Bundle. The current version is 6.3, the earliest version being 5.0, which emphasized the fact that MySQL Workbench was developed as the successor to DBDesigner4.
Manufacturer: The Sequel Pro Project (open source) Website: Price: FREE (donations accepted via PayPal) License: GNU GPL 2.0 Supported platforms: Mac OS X 10.6 Snow Leopard or newer Sequel Pro is a FREE open-source application. It is the successor of the Mac database management application. CocoaMySQL was the brainchild of Lorenz Textor, who was the main developer of CocoaMySQL from its early beginnings in 2003. Sequel Pro is an application used to manage MySQL databases (locally or over the Internet).
Xojo is a development tool for creating powerful, native applications for desktop. Xojo is easy to use and lets you learn as you go - you came to the right place if. Note that none of the aforementioned compilers provides a graphical user interface (GUI) however, nor do they provide an integrated enviroment in which programs can be compiled, linked, and executed. Apple has come to the rescue by providing the xCode environment in OS X 10.3 (and the Project Builder environment in previous versions of OS X).
It lets you add and remove databases and tables, change fields and indexes, view and filter table content, add, edit and remove rows, perform custom queries, and dump tables or entire databases. It is compatible with MySQL 3.x, 4 or 5 and now comes in 5 additional languages, including Russian, German, Swedish, French and Japanese. Manufacturer: Ansgar Becker Website: Price: FREE (donations accepted via PayPal) License: Supported platforms: Windows XP, Vista, 7, 8, 10 (can be run on any Linux with ) HeidiSQL, previously known as MySQL-Front, is a FREE and open source client developed by German programmer Ansgar Becker and a few other contributors in Delphi.
To manage databases with HeidiSQL, users must login to a local or remote MySQL server with acceptable credentials, creating a session. Within this session users may manage MySQL Databases within the connected MySQL server, disconnecting from the server when done. Its feature set is sufficient for most common and advanced database, table and data record operations but remains in active development to move towards the full functionality expected in a MySQL Frontend.
A version written in Java, jHeidi, which is designed to work on Mac and Linux computers, also exists. Unfortunately, the project has been discontinued since March 2010. Manufacturer: Webyog Inc. Website: License: A full range of licensing options are available ranging from one to unlimited user commercial licenses with one year of free upgrades. Supported platforms: Windows 2000, XP, Vista, 7, 10 There have been many complaints that MySQL Workbench hangs or fails to respond when put under a heavy load. SQLyog is a more robust product with many additional tools.
It’s available in three major versions: Professional, Enterprise and Ultimate. The main difference between the three versions is the number of included features. These include data migration, profiling, visual designers, analysis, batch scripting, backup scheduler, user manager, and database copy tools. At this time, SQLyog is only available for the Windows platform, but, some of the community uses it on MacOS, Ubuntu, Debian, Fedora and Mageia using.
A single user license costs $99 for the Professional Ed, $199 for the Enterprise Ed, and $299 for the Ultimate Ed. Multi-user packages are also available. A 14-day trial version of SQLyog is available for from the Webyog's website. Updated: April 28, 2017. Manufacturer: devart Website: Price: FREE for express edition, $59.95 (non-commercial standard edition), $124.95 (non-commercial professional edition), $119.95 (commercial standard edition), $249.95(commercial professional edition) License: Commercial and non-commercial licenses available. Subscriptions are also offered as an efficient and quickest way to deliver product upgrades and technical support. Supported platforms: Windows XP/7/8/8.1/10 dbForge Studio for MySQL offers visual MySQL development and administration.
There are three editions: Express, Standard, and Professional: Express is a FREE application that provides basic functionality for working with schema objects, user accounts, SQL scripts, and queries. Standard includes additional tools for database administrators and developers, such as a debugger, Query Builder, code templates, object search, various export and maintenance wizards.
Professional is the most full-featured version and adds the following functionality: database projects, accurate comparison and synchronization of database structures (schema comparison) or database content (data comparison), debugging stored procedures and scripts, complex query creation. Other tools from dbForge include:. Schema Compare for MySQL. Data Compare for MySQL. Query Builder for MySQL. Fusion for MySQL.
Manufacturer: DBTools Software Website: Price: Standard Edition is FREE. Enterprise is $69.90 USD for a single license. Discounts are available for multiple licenses. License: Standard Edition is licensed under standard freeware conditions. The enterprise version is licensed per unit sold. Supported platforms: Windows 2000, XP, Vista, 7 Standard Edition Specially designed for personal use, it has a minimum set of features that makes it ideal for new database users to perform basic database management.
You can use this edition for FREE for non commercial use. For commercial use you can purchase a license which will provide additional features. Enterprise Edition Designed for Enterprise use, it is more suited for DBAs and developers looking for an integrated application for database management. You can try it before purchasing. The Enterprise Edition trial version comes with all features enabled, so that you can try them all for 20 days and make your purchasing decision based on the full experience. Both include Support for MySQL 3, 4 and 5.
Manufacturer: H2LSoft, Inc Website: Price: FREE License: freeware Supported platforms: Windows, XP, Vista, 7, 8, 10 Our final entry is another studio containing a complete collection of tools for MySQL Server administration. Developers will appreciate its ability to create/edit/drop database objects, DB synchronization, and data export/import. DBAs can also use MyDB Studio to perform database migration, as well as backups and restores. It supports SSH tunneling to secure your connections, which allows you to connect even if your host doesn't allow you remote access connection, user and privilege management, and PHP script creation. Conclusion Runner-Ups Of course not every beloved MySQL product could make it on the list. Here are a few more for your consideration:.
I am confident that you will find a product to suit your needs in this group. They are in no particular order, so feel free to try any that catches your eye. I should also point out that I received absolutely no financial compensation from any of these companies. My assessment of each product is based on my unbiased opinion. As such, my top ten list may diverge slightly from the general consensus. A few things have changed in the database landscape since our Top 10 MySQL GUI Tools list was compiled-in particular the emergence of cloud services.
Keep that in mind when searching for the right MySQL admin tool. Most relational databases, with the notable exception of MS Access, are comprised of two distinct components: the back-end, where the data is warehoused, and the front-end, a user interface for communicating with the data component. This type of design is quite clever, as it parallels the two tier programming model that separates the data layer from the user interface and allows the makers of the database software to focus on their product’s strongest suit: data storage and management. It also opens the door for third parties to create rich applications to interact with various databases. Such products include Embarkedaro Rapid SQL and Oracle SQL Developer. Here are ten outstanding graphical interfaces for MySQL.
Please enable Javascript in your browser, before you post the comment! Now Javascript is disabled.
This page contains a list with a couple of known toolkits for Graphical User Interfaces that you can use in your Mono software. If you need help to know which one is the best for your project, please have a look at., a GTK# app, a GTK# app Homepage: GTK# is a.NET binding for the Gtk+ toolkit. The toolkit is written in C for speed and compatibility, while the GTK# binding provides an easy to use, object oriented API for managed use. It is in active development by the Mono project, and there are various real-world applications available that use it (, ). In general, GTK# applications are written using, which provides a visual designer for creating GTK# GUIs.
Platforms: Unix, Windows, macOS Pros:. Good support for accessibility through its Gtk+ heritage. Layout engine ideal for handling internationalized environments, and adapts to font-size without breaking applications. Applications integrate with the Gnome Desktop.
API is familiar to Gtk+ developers. Large Gtk+ community.
A Win32 port is available, with native look on Windows XP. The API is fairly stable at this point, and syntactic sugar is being added to improve it. Unicode support is exceptional. Cons:. Gtk+ apps run like foreign applications on macOS. Incomplete documentation. Homepage: MonoMac is aimed at.Net/Mono developers that want to allow their users to have a native macOS application experience.
MonoMac allows developers to access the whole range of macOS APIs from C#, it is not limited to the AppKit GUI APIs. The MonoMac APIs replaced the old CocoaSharp binding, which is now deprecated. Platforms: macOS Pros:. Native look and feel on macOS. Substrate is well documented. Cons:.
Not portable outside of macOS., a Winforms app, a Winforms app Homepage: Windows.Forms is a binding developed by Microsoft to the Win32 toolkit. As a popular toolkit used by millions of Windows developers (especially for internal enterprise applications), the Mono project decided to produce a compatible implementation (Winforms) to allow these developers to easily port their applications to run on Linux and other Mono platforms. Whereas the.Net implementation is a binding to the Win32 toolkit, the Mono implementation is written in C# to allow it to work on multiple platforms. Most of the Windows.Forms API will work on Mono, however some applications (and especially third party controls) occasionally bypass the API and P/Invoke straight to the Win32 API. These calls will likely have to be changed to work on Mono.
In general, Winforms applications are written using Microsoft’s Visual Studio or, which both provide a visual designer for creating Winforms GUIs. Platforms: Windows, Unix, macOS Pros:. Extensive documentation exists for it (books, tutorials, online documents). Large community of active developers. Easiest route to port an existing Windows.Forms application. Cons:.
Internationalization can be tricky with fixed layouts. Looks alien on non-Windows platforms. Code that calls the Win32 API is not portable. Qml.Net is cross-platform integration of Qml/QtQuick for Mono/.NET/.NET Core.
It is a binding that brings.NET types into JavaScript with full interoperability. Pros:. Leverage the power of an existing GUI framework with an existing track record. Cross-platform (Windows/Linux/OSX) for various.NET runtimes. Support for language specific features, such as async and await, and Qt’s signals. Extensive unit tests. Extra care is taken to ensure memory safety and that there are no memory leaks.
Cons:. Documentation is lacking.
Work in Progress Listed below are some Toolkits that are in several stages of active development but don’t have a stable release yet. Xwt Homepage: Xwt is a cross-platform toolkit that works by exposing one unified API across all environments.
The API is mapped to native controls on each platform. It can be used as a standalone framework or it can be embedded into existing applications. MonoDevelop uses this toolkit for simple interfaces that need to feel native across all the platforms, without the need to write platform specific code. Pros:. Extremely simple API. Native look and feel on each platform. Can be embedded in existing applications.
Cons:. Poor documentation. QtSharp Homepage: QtSharp started as a sucessor of the Qyoto project. It aims to create libraries that wrap thus enabling its usage through C#. It relies on and generates the wrappers based on a pre-installed Qt setup. Still in early development.
Dead efforts There are a couple of that have been developed in the past.