Ubiq – a MySQL Reporting and Analytics Tool for Business Users
If you use MySQL databases and you don’t want to deal with programming, just try Ubiq out.
This project can be very interesting for persons who work in business. It’s good for your intranet or cloud in your company. Of course, you should have MySQL installed on you system first.
To get it, please go to the website:
Create your account. Now, you will be able to download Ubiq for your platform. I use Linux (openSuse), so I chose the rpm package.
As soon as you download Ubiq, unpack and go into the directory. You should make the file manage.sh executable, so run the command:
poganin@linux-7tpy:~/Pobrane/ubiq_linux_rpm> sudo chmod +x manage.sh
Now, you can ready to start Ubiq. First, you have to configure it:
linux-7tpy:/home/poganin/Pobrane/ubiq_linux_rpm # ./manage.sh
Select action for ubiq agent:
1. Configure agent
2. Start agent
3. Stop agent
4. Check status of agent
5. Add/Remove database connections in agent
6. Remove agent
7. Update agent
8. Reset database connections
Enter EMAIL used for signup at Ubiq(q to quit):
PASSWORD used for signup(q to quit):
Enter database details
Name of database:
Host(127.0.0.1 or remote ip or url):
Port(leave blank for default):
Username of database user:
Ubiq started successfully!
Press 0 to see menu again,1 to exit
Let’s create your first project
Entr project name:
Enter Dashboard Title:
You should see:
Dashboard created successfully
Click Add View
You see the Dashboard, with which you can review your data in many ways. You can save the chart and export the current Dashboard as a image or share a link with other people. It’s a great solution.
So now you are ready to use Ubiq for your databases. Without knowing MySQL syntax, just dragging and dropping, you can see all your data in the ways you like. To get more info, please go to:
For me, it works well. I haven’t got any bugs or other problems. In other words, ready for business.