Database Commander is a free plugin for Automate for monitoring MySQL and running queries against the database.
This plugin allows Automate administrators to access the application database directly through the application regardless of hosting style or deployment configuration. This access enables administrators to take command of the database and leverage it for more advanced automation.
The plugin is completely self-contained; it does not create any tables and it does not perform any write operations by default. The first tab shows load and performance information, and the second tab is a query editor, complete with table name autocomplete and syntax highlighting.
Database Commander also lets partners perform write operations (insert, update, delete, etc.). By default, these statements are turned off, but after deactivating the double-safety all types of queries are allowed.
Features
- Live MySQL load and performance data
- Syntax highlighting query editor
- Autocomplete for all default application tables
- Text editor functions (find/replace, word wrap, zoom, etc.)
- CSV export of query results
- Double-safety filter to prevent accidental data changes
- Auditing of plugin access and use
Using Database Commander
Get Database Commander
Database Commander is used by 275 MSPs across the globe. Use the form below to get the plugin and our MySQL 101 for Automate guide delivered to your inbox.
What are others saying about Database Commander?
Really easy to use.
Databse Commander does exactly what it says. Very easy to use and safe.
I’ve learnt alot using it. The type ahead/popup of the tables is nifty. Perhaps right click paste would be a good option otherwise excellent product.
Thank you Jeremy!
Stable and reliable tool, a must-have!
This is a must-have for anyone that has a hosted instance of Automate. It unlocks a lot of capabilities that otherwise would be extremely challenging or impossible.
Really bare bones..but better than nothing.
It works but it’s pretty bare bones. It would get another star and a half if you could show the error output into the results console. A button for exports in addition to the hot key would be nice. Being able to resize the query window would also be cool. From what I can tell it doesn’t support sub queries? ..but since I can’t see the error output who knows. I do appreciate the work you have put into the tool though.
Response from Automation Theory
Hi Todd! The error limitation is on the ConnectWise side of things — the plugin is using their SDK to make the SQL queries, and “-9999” is the only error CW returns if the query doesn’t execute successfully. Subqueries are supported, but you might have permission limitations for certain tables since it is running with the permissions of your Automate user. We have a couple of other feature requests queued for this plugin, and we’ll add a button pannel for some of the hotkey functions, including exports.
Excellent!
This is an invaluable tool for those of us working on cloud instances. THANK YOU!
Extremely helpful
With our LT database growing to upwards of 2,000 tables, and not having direct access to the SQL databases themselves, this tool has proved to be a necessary addition to our Automate setup. It has – just this week – saved me countless hours while writing scripts. The ability to directly execute SQL and see the results immediately, with much fewer limitations is absolutely essential. My recommendation for improving this plugin would really just be the ability to edit results in-place, much like how phpMyAdmin allows you to. Other than that, thank you very much for releasing such a useful tool.