With the help of various well-designed tools administering your MySQL databases becomes a task that’s much easier to do then if you were to execute them through conventional methods. Developers need to always be on the look-out for tools that will shorten and ease their time spent on development. This is why we’ve compiled 10 MySQL Tools that Streamline Your Development Process.
Check out our previous post on Working with MySQL Databases, and remember to subscribe to our feed for up-to-date articles and resources!
MySQL Workbench
MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench will be available as a native GUI tool on Window, Linux and OS X. MySQL Workbench is available in different editions. See the following link for more information about the editions available.
About MySQL Workbench – Editions
phpMyAdmin
phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
Features
- Intuitive web interface
- Support for most MySQL features:
- browse and drop databases, tables, views, fields and indexes
- create, copy, drop, rename and alter databases, tables, fields and indexes
- maintenance server, databases and tables, with proposals on server config
- execute, edit and bookmark any SQL-statement, even batch-queries
- manage MySQL users and privileges
- manage stored procedures and triggers
- Import data from CSV and SQL
- Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 -
- Administering multiple servers
- Creating PDF graphics of your database layout
- Creating complex queries using Query-by-example (QBE)
- Searching globally in a database or a subset of it
- Transforming stored data into any format using a set of predefined functions
- And much more…
Aqua Data Studio
Aqua Data Studio is a complete Integrated Development Environment (IDE) for database administrators, software developers and business analysts. It provides four major areas of functionality: 1) Database query and administration tools; 2) a suite of compare tools for databases, source control and file systems; 3) a complete and integrated source control client for Subversion (SVN) and CVS; and 4) a database modeler as powerful as the best standalone database diagramming tools.
SQLyog
SQLyog is an all-round Management Tool (/’GUI’/'Frontend’) for the MySQL database. The Community Edition is Free & Open Source under GPL license. Everything a developer typically requires when working with MySQL is available at a mouse-click, with a query result set, query profiler, server messages, table data, table information, and query history always available via the tabbed interface shown in Figure 5. In addition, it’s easy to create views and stored procedures, a feature I personally have returned to time and again in recent weeks.
MYSQL Front
This graphical GUI for the MySQL database, is a “real” application, it can offer a more refined user-interface than is possible with systems built on PHP and HTML. Response is immediate, as there is no delay of reloading HTML-pages. If your provider allows it, MySQL-Front can make direct contact with the database. Otherwise, only one small script needs to be installed on the publishing website. Login information are stored on your hard disk, so you no longer have to log on to different web interfaces.
mytop
mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server. It runs on most Unix systems (including Mac OS X) which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. If you install Time::HiRes, you’ll get good real-time queries/second stats. As of version 0.7, it even runs on Windows (somewhat).
mytop was inspired by the system monitoring tool top. I routinely use top on Linux, FreeBSD, and Solaris. You are likely to notice features from each of them here. mytop will connect to a MySQL server and periodically run the SHOW PROCESSLIST and SHOW STATUS commands and attempt to summarize the information from them in a useful format.
Sequel Pro
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
SQL Buddy
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.
MySQL Sidu
MySQL Sidu is a FREE MySQL client working via web browser. MySQL Sidu is simple and easy database tool to use! Sidu stands for Select Insert Delete Update. Sidu can do more jobs than these and looks like MySQL front-end software GUI rather than web page.
- SIDU stands for SQL Select Insert Delete Update.
- SIDU can do more jobs than above tasks.
- SIDU works via web browsers such as Firefox, IE, Opera, Safari, Chrome, etc.
- SIDU looks like database font-end software GUI rather than web pages.
- SIDU works for MySQL, Postgres and SQLite DBs.
Navicat Lite MySQL Admin Tool
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.
Digg
Del.icio.us
Mixx
Stumble
User Responses
7 Responses and Counting...
Leave a Reply
March 22, 2010
Where’s HeidiSQL? Free, and first class!www.heidisql.com
March 22, 2010
@Dave,
Thank you for the input! HeidiSQL is a great app and we’ll be sure to elaborate on that on the next SQL tools post. It’s going to be bigger, more in-depth, and will show beginner to advanced techniques.
March 22, 2010
A good web design plan is also a good way to get an accurate estimate for creating a new web or overhauling an existing web.
March 22, 2010
Still think SIDU is the best – but your screenshot is not v3.* – sidu.sf.net
March 22, 2010
heidiSql seems great tool it has the things ive been wating for a long time,
im downlading it now!!!
nice app!!!!
March 22, 2010
I shouldn’t be surprizing so hard at that.
March 22, 2010
A couple of new one’s there. keep up the good work. Thnx