Building an effective TKL Base
There are many components to setting up an effective IT infrastructure. Different systems have different capabilities. This is one of the reasons I like the the Turnkeylinux set of applications. They are very consistent in their operating model and it is possible to install them in to a wide variety of server environments.
Each can be easily accessed via SSH, WebShell or Webmin interfaces. This gives a full range of capabilities as well as a reduntant and intuitive access approach. All those with Database backends come with, generally, the Adminer database access module with which most simple edits and explorations can be pursued.
But even with this installation capability and their excellent set of apps which surround there are things that you may want to accomplish.
For me, one of those things. are data-access via separate Database Clients. I happen to like both Navicat and FileMaker pro for database interactions and both systems can access TKL data if approached in a deliberate, security oriented method. The advantage to this of course is that you can very much streamlilne some of your interactions with your systems which are otherwise bogged down by assumed needs put forth by the app centric programming, and the somewhat limited Adminer Interface. (Do note that you can install PHPMyAdmin nd PSGAdmin (get the names right!) with a little extra work.