Visual Query - A Basic MySQL Query Builder App

The client I am working with is somewhat technical and he wanted the ability to create his own reporting out of database. He isn't all that expert in knowing SQL so in order to help him I built Visual Query app to help him build his SQL queries visually through a provided interface.

Visual Query is basic MySQL query builder and database browser app that has these basic features:

• Ability to choose different databases
• Ability to export result set to CSV and Excel
• Custom queries option
• Visual Query builder
• Query log, search facility, pagination, etc

Here is how it looks:

One can also write custom queries with syntax highlighting support as well as code prediction support:

And here is the query builder interface:

How to Use

First of all, download it from its repository. Once downloaded, edit the config.php file with database details and users login information:

// edit database settings
$config['database_host'] = 'localhost';
$config['database_user'] = 'root';
$config['database_password'] = '';
$config['database_dbname'] = 'mydb';

//////////////////////////////////////////////
// user details who can login - You can also specify more than one user
//////////////////////////////////////////////

// user 1
$config['username'][] = 'admin';
$config['password'][] = 'admin';

// user 2
$config['username'][] = 'admin2';
$config['password'][] = 'admin2';