Chive – Web-based MySQL administration

10 December 2011 • no comments • Open Source

Chive is a database management tool similar to PhpMyAdmin. It provides a web-based interface to manage all the administrative activities of database management. Chive is a PHP-based plug-n-play web application built on top of the famous Yii PHP framework. Since it is open-source, licensed under GPL, you can even extend its functionality to suit your needs.

Inline Editing

With Chive you can perform basic SQL activities like select, update, insert, alter and more with an aesthetically designed UI coupled with the interactivity of JQuery. All tabular data are inline editable including column attributes – makes your job quicker and easier. Further, inline editing is supported for all column types – TEXT, FILE, DATETIME, ENUM, BLOB etc.

Syntax Aware SQL

You can use Chive to create and test your SQL queries before using them in your application. It provides a syntax aware editing area to create your query. Even complex queries are handled well for good readability and understanding. You can even bookmark these queries to repeatedly use them later on. The bookmark feature is best used for custom maintenance/log queries.

SQL Profiling

Another important part of testing your queries are also analyzing them. If you have a large database and queries that join many tables together, you may want to profile your queries to check its performance. Large applications are known to be bogged down by badly written database queries.

Other Notable Features

Feature	Description
Create, Alter & Browse	Supports creating, altering and browsing of databases, tables, routines, triggers and views.
User Management	Direct management of MySQL users.
Import/Export	Supports importing/exporting of tables or even entire database of structure and data.
Foreign Keys/Indices	Fully supports table relationships and indexing.
Direct MySQL authentication	The user authentication happens directly with MySQL users. No need for remembering another password!

Download Chive

About the Author

Manoj is a software professional by day and a blogger, web-developer, and an internet addict by night. You can view his personal blog or follow him on facebook and twitter.