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. 
 Its feature include: 
 <UL>
	<LI>Intuitive web interface</LI>
	<LI>Browse and drop databases, tables, views, fields and indexes</LI>
	<LI>Create, copy, drop, rename and alter databases, tables, fields and indexes</LI>
	<LI>Maintenance server, databases and tables, with proposals on server configuration</LI>
	<LI>Execute, edit and bookmark any SQL-statement, even batch-queries </LI>
	<LI>Manage MySQL users and privileges</LI>
	<LI>Manage stored procedures and triggers</LI>
	<LI>Import data from CSV and SQL</LI>
	<LI>Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LATEX and others</LI>
	<LI>Administering multiple servers</LI>
	<LI>Creating PDF graphics of your database layout</LI>
	<LI>Creating complex queries using Query-by-example (QBE)</LI>
	<LI>Searching globally in a database or a subset of it</LI>
 <LI>Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</LI>
 </UL>

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.

PHPMyAdmin

Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML. 
<ul>
<li>Exports consistent and referentially intact row-sets from your productive database
and imports the data into your development and test environment.</li>
<li>Improves database performance by removing and archiving obsolete data without violating integrity.</li>
<li>Generates topologically sorted SQL-DML, hierarchically structured XML and DbUnit datasets.</li>
<li>Data Browsing. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.</li>
<li>SQL Console with code completion, syntax highlighting and database metadata visualization.</li>
</ul>

Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML.

Jailer - Database Subsetting and Browsing Tool

HeidiSQL is a lightweight, fast and flexible interface to the popular MySQL-Database. It allows you to browse and edit your databases, tables, views, stored routines and triggers from an intuitive Windows interface. 

 It synchronizes tables between two databases. It helps to write queries with customizable syntax-highlighting and code-completion. It exports table-data as CSV, HTML, XML and SQL. It provides support to search specific text in all tables of all databases of one server. It connects to multiple servers in one window and also connects to server via command line. Source location: <A HREF="http://code.google.com/p/heidisql/" target"_blank">http://code.google.com/p/heidisql/</A>
 <img src="/AppImages/Article/heldisql-img1.png" alt="" class="float-center">

HeidiSQL is a lightweight, fast and flexible interface to the popular MySQL-Database. It allows you to browse and edit your databases, tables, views, stored routines and triggers from an intuitive Windows interface.

HeidiSQL - A lightweight interface to MySQL

iSQL-Viewer is JDBC compliant database front end. It implements across multiple platforms features of the JDBC API. It does everything through a single interface. iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix. 
 Its feature includes: 
 <UL>
	<LI>Database and schema viewing and browsing</LI>
	<LI>Compatible with major database vendors</LI>
	<LI>SQL Bookmarks to store SQL commands you commonly use</LI>
	<LI>SQL History to see and retrieve SQL commans previously executed</LI>
	<LI>Enhanced user interface support across platforms</LI>
 </UL>

iSQL-Viewer is JDBC compliant database front end. It implements across multiple platforms features of the JDBC API. It does everything through a single interface. iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix.

iSQL-Viewer - JDBC compliant database front end 

VFront is a open source front-end for MySQL or PostgreSQL databases. VFront is for non-expert users capable to work safely on data using an intuitive graphic interface. It exports data modules, statistics and report management based on xml, xsl and xsl-fo protocols. 

 VFront has highly customizable system of groups and privileges makes access possible for various employed to specific tables or views, shows/hides specific fields, sets rules for input validation and keeps under control all the database activities.
 <img src="/AppImages/Article/vfront-img1.gif" alt="" class="float-center">

VFront is a open source front-end for MySQL or PostgreSQL databases. VFront is for non-expert users capable to work safely on data using an intuitive graphic interface. It exports data modules, statistics and report management based on xml, xsl and xsl-fo protocols.

VFront - User front-end for MySQL and PostgreSQL

SQL Buddy is a phpMyAdmin alternative with a focus on usability. It supports to create and drop databases and tables, View, edit, insert and delete table rows, Execute custom SQL and view the output, Import and export databases and tables to SQL and CSV formats, Add, edit and delete MySQL users.

SQL Buddy - Web based MySQL administration

Chive is a free, open source, web-based database management tool, designed to bring joy to web developers - with easy administration and super fast UI. It supports Repeated administration of your SQL queries by saving and re-execute them,  Analyze and Optimize your queries with Profiling and lot more.

Chive - MySQL Data Management tool

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. It gives you direct access to your MySQL databases on local and remote server. It supports Full table management including indexes and MySQL Views. It supports quick Export or Backup with SQL/CSV files. It does fast Import or Restore of SQL/CSV files. It has powerful and customisable query editor. Query editor supports syntax coloring, auto-completion of keywords, table names and field names. 
 <img src="/AppImages/Article/sequelpro-img1.jpg" alt="" class="float-center">

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. It gives you direct access to your MySQL databases on local and remote server. It supports Full table management including indexes and MySQL Views.

Sequel Pro - MySQL Database management for Mac

MySQL-Front is a Windows front end program for the MySQL database server. The database structure and data can be handled via dialogs or SQL commands. Import and Export in standard file formats is supported. The database server can be connected directly or via HTTP tunneling.

MySQL-Front - A GUI front end for the MySQL and MariaDB database servers

Discover open source projects across all platforms

Projects