20 MySQL Admin and Development Tools and cheat sheets

Sequel Pro (Mac OS X)

This MAC OSX database management app gives you direct access to your MySQL databases on local and remote servers with support for importing and exporting data from popular files including SQL, CSV and XML. Sequel Pro started as a fork of the open source CocoaMySQL project. Sequel Pro gives you direct access to your MySQL databases on local and remote servers.

• Easily set up a connection to the local MySQL server on your Mac
• Full table management including indexes
• Support for MySQL Views
• Use multiple windows to work with multiple databases/tables at once

Sequel Pro is a free open-source app

Navicat Lite MySQL Admin Tool (Win, OS X, Linux)

Navicat is a fast, reliable and popular Database Administration tool purpose-built for simplifying database management and reducing administrative costs. Designed to meet the needs of database administrators, developers, and small and medium businesses, Navicat is built with an intuitive GUI which lets you create, organize, access and share information in a secure and easy way. Navicat for MySQL is a powerful Database administration and development tool for MySQL. It works with any MySQL Database Server from version 3.21 or above, and supports most of the latest MySQL features including Trigger, Stored Procedure, Function, Event, View, and Manage User, etc. Navicat Lite is available as a free download only for non-commercial customers

Toad MySQL (win)

Toad for MySQL is a database development and administration tool that provides productivity features for rapidly creating 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. Changes to the interface recently has been the the introduction of the “Tabbed Document Interface”, this means you can view a fully maximized window without the need for you to constantly resize, arrange, or tile the windows. Toad is free.

SQLyog (win)

SQLyog is another popular SQL management tool that has some useful features such as intelligent code completion, visual schema designer, visual query builder and a data / structure synchronization. It support HTTP / HTTPs / SSH tunnelling and SSL connections.  There is a free Community version and a commercial Enterprise edition. You should also be aware of MONyog, a MySQL Monitor and Advisor. Commercial License

SQL Buddy (Web-App)

SQL Buddy is a great lightweight ajax powered database management tool It is as easy to install as it gets. All you need to do is unzipping the folder to your server – it doesn’t get simpler! You can do most of the operations that the majority of users will need. There is also a useful range of keyboard shortcuts, which you can view here: SQL Buddy Keyboard Shortcuts.

MyCon – MySQL GUI (win)

MyCon MySQL GUI is a very powerful windows based graphical user interface, for administering and working with MySQL server databases. This easy to use MySQL GUI front-end client includes all the functionality and tools you will need to be productive in MySQL as a DBA, developer, manager, report writer or a general end-user. Free and commercial versions available.

MySQL Sidu (web app)

MySQL Sidu is a FREE MySQL web based client, it is simple, intuitive and an easy database tool to use. Sidu is does not have as many features as most of the other tools but the fundamentals are inclueded and easy to use. It is ideal and mainly designed for performing Selects, Inserts, Deletes and Updates – exactly what the name represents (sido).
You can also use a Firefox Extension in conjunction with Sidu that enables you to insert data from text fields & textareas in a webpage. Firefox addon for MySQL Sidu.