Free Tools For MySQL Design and Administration

Whether you are developing desktop software or web based application, there is a pretty good chance you will consider MySQL for data storage. Due to its popularity and open source business model, numerous tools and utilities are available that will help you easily design and manage your MySQL databases.

W3Avenue has compiled a list of really useful free tools and utilities for MySQL that will enable you design and manage your databases of various scope and complexity.

Cross Platform

  • MySQL GUI Tools
    The MySQL GUI Tools is a set of cross platform tools that include: MySQL Administrator, MySQL Query Browser and MySQL Migration Toolkit.
  • MySQL Workbench
    MySQL Workbench is a cross platform GUI product for the MySQL Server that can be used to write and execute SQL queries and scripts, edit data, visually design database models and manage the MySQL Server.
  • MySQL Control Center
    MySQL Control Center is a GUI front end for MySQL database creation and administration. It allows multiple concurrent MySQL server connections, MDI, stored login credentials, point and click dump file imports and more.
  • SQuirreL SQL
    SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Mac OS X

  • Sequel Pro
    Sequel Pro is fast, easy to use Mac OS X database management application for working with MySQL databases. It gives you direct access to your MySQL databases on local and remote servers.
  • YourSQL
    YourSQL is intended to be easy to use for the beginner as well as the advanced user. It provides access to advanced features of MySQL, such as indices, InnoDB tables, multi-statement SQL scripts and multi-threaded handling of SQL dumps for backups or similar administration tasks.

Windows

  • HeidiSQL
    HeidiSQL is an easy to use MySQL management client for Windows. It allows you to synchronize tables between two databases; manage user-privileges; import / export; browse and edit table-data using a comfortable grid; create and edit stored procedures; and lot more. You can also run HeidiSQL on Linux with Wine.
  • Toad for MySQL
    Toad for MySQL is database development and administration tool that enables: query development, database design, database administration, data management, reporting, project management and automation.
  • MyDB Studio
    MyDB Studio is a collection of powerful tools for MySQL Server administration. It also supports SSH tunneling to secure your connections enabling you to connect even if your host doesn’t allow you remote access connection.

Web Based

  • phpMyAdmin
    phpMyAdmin is one of the most popular web based MySQL administration tool written in PHP. It 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.
  • MySQL Sidu
    Sidu (Select, Insert, Delete, Update) is a web based MySQL client with easy to use GUI. In addition to standard MySQL administration you can use Sidu to sorts data in two columns; secures your data with multiple firewalls; manage accesses easily; filter and sort tables to export.
  • VFront
    VFront is a dynamic front-end for MySQL or PostgreSQL databases written in PHP and Javascript. With VFront you can create forms for manage your data in AJAX style, different rules and privileges for groups, report in XML,HTML,PDF,statistics and much more.
  • SQL Buddy
    SQL Buddy is an open source web based MySQL administration tool developed using PHP. Just unzip the files to your server and its ready to use. Logins are handled directly by MySQL, and you can create as many or as few users as you want.
  • MySQL Ajax Table Editor
    This is a free open source application (PHP4 & PHP5 compatible) that allows you to quickly create database admin pages and manage MySQL tables. Its MySQL editor has the ability to join on multiple tables and maintain search functionality and is written with AJAX.
  • Adminer
    Adminer is a full-featured MySQL management tool written in PHP. It consist of only a single file ready to deploy to the target server. Supports both PHP 4.3+ and PHP 5 with sessions enabled.
  • MySql Lite Administrator
    MySql Lite Administrator is a PHP based web application that will help you insert and update data in your MySQL Database.
  • AeroSQL
    AeroSQL is an open source web based tool for managing MySql. The key feature of AeroSQL is intuitive management of the database content.
  • MySQLDumper
    MySQLDumper is a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and – if needed – restore it. It is especially suited for shared web hosting, where you don’t have shell access.
  • phpMyBackupPro
    phpMyBackup Pro is a very easy to use, PHP based MySQL backup application. It allows you to create schedule, manage, restore, download or email database backups.
  • WWW SQL Designer
    WWW SQL Designer is a web based visual SQL modeling tool that allows you to draw E-R designs, edit tables and rows, manage keys, create relations (FK constraints), save & load designs and import DB schemas.

Cheet Sheets

Please feel free to suggest any addition, correction or updates in your comments. You may also be interested in reading following posts published on W3Avenue:

Stay Updated

If you found this post useful, consider subscribing to our RSS Feed! You can also stay updated by following us on Twitter and Facebook or by subscribing to our FriendFeed.

Bookmark / Share

Bookmark and Share

Read More

SIMILAR/RELATED POSTS:

PREVIOUS POST:

NEXT POST:

Reader Comments

6 Responses to “Free Tools For MySQL Design and Administration”
  1. Nice List. Just realized there are so many options besides phpmyadmin.

  2. djn says:

    You left out my preferred tool for working with SQLite: SQLite Manager at http://code.google.com/p/sqlite-manager/, either as a Firefox extension or standalone with XulRunner. Definitely feature-rich and easy to get started with.

  3. Craig says:

    Nice list but wanted to note that Lita, which I use and love, is only for SQLite databases and not MySQL. It’s a great tool, especially for online/offline web apps (and, as is the point of this post, it’s free!) but make sure you know it’s not for MySQL.
    Cheers, Craig

  4. Gerard says:

    Here is another using mysql web tool. It help you formats dates using the format_date function http://www.mysqlformatdate.com

  5. Laurent H says:

    Another one: MyDB studio for MySQL
    http://www.mydb-studio.com

Leave Comment

 
 

Stay Updated, Subscribe to RSS Feed

 
 
 
 

Blogroll

 

Sponsored Links