Gratis MySQL visual query builder

Question

I am looking for a gratis Windows program to connect to a database and allow non-techie users to easily, visually, build queries.

[Update] I think that I didn't make it clear - these tables & suggested searches are just examples. I want something totally generic. It should query the database, find the tables and their columns - for ANY database - and offer a GUI to help non-techie users to build queries.

Here are three Example tables:

mysql> describe visitors;
+---------+---------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| tag_id  | int(11) | NO   |     | NULL    |       |
| name    | text    | NO   |     | NULL    |       |
| email   | text    | NO   |     | NULL    |       |
| phone   | text    | NO   |     | NULL    |       |
| address | text    | NO   |     | NULL    |       |
+---------+---------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> describe devices;
+--------------+---------+------+-----+---------+----------------+
| Field        | Type    | Null | Key | Default | Extra          |
+--------------+---------+------+-----+---------+----------------+
| device_id    | int(11) | NO   | PRI | NULL    | auto_increment |
| station_name | text    | NO   |     | NULL    |                |
+--------------+---------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

mysql> describe taps;
+------------+-----------+------+-----+-------------------+-------+
| Field      | Type      | Null | Key | Default           | Extra |
+------------+-----------+------+-----+-------------------+-------+
| tag        | text      | NO   |     | NULL              |       |
| station    | int(11)   | NO   |     | NULL              |       |
| time_Stamp | timestamp | NO   |     | CURRENT_TIMESTAMP |       |
+------------+-----------+------+-----+-------------------+-------+
3 rows in set (0.00 sec)

So, we have visitors, who visit stations/devices by tapping as they visit.

The non-techie user wants to ask which visitor visited most stations, and what is their name, email, phone & address or how many unique visits did each station get, and such like, all GUI driven.

Important is to generate count() and join, etc, without the user knowing SQL.

Any recommendations?

---

[Update++] I am Googling & slowly checking the results, but would prefer a recommendation from someone who has used a tool.

Typical functionality will be:

• generating SELECT statements with JOIN, without the user having any knowledge of what a JOIN is, or even of SQL.
• GROUPing
• SORTing
• COUNTing

I like the look of this component, and would like a full blown app which works similarly. So long as tables and columns are named sensibly, it should be possible to present a natural language type interface to the non-tech user and have him generate complex queries.

---

Please, post some screenshots with your answer.

Answer 1

DISCLAIMER: I WORK AT QUERYTREE

Please head over to http://querytreeapp.com (I work here) and take a look - it's NOT free, but we have a low priced plan and a free trial - it's designed for exactly this type of thing.

Answer 2

I can highly recommend GroceryCrud, which is free.

This code:

function my_boss_is_in_a_hurry() {
    $crud = new grocery_CRUD();
    $crud->set_table('customers');
    $crud->columns('customerName','phone','addressLine1','creditLimit');

    $output = $crud->render();

    $this->_example_output($output);
}

generates this:

and that's just the start of it. It is simple to use & very powerful

It is not a query builder, such as I sought, but it is well worth knowing of, and it ought to be simple enough to code a generic query builder.

Answer 3

Not gratis, but affordable. FlySpeed Qury- free for non-commerical & academic use, a mere $39 for the desktop version ($49 for portable).

It has a query builder which could be used by non-techies: