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 419 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.
Great tool
A great plugin for something that should exist within the default application. One improvement would be a way to browse the tables in a tree view.
The game has changed
Being used to on-prem Labtech (Automate) when my company decided to switch over to CW hosted one of my biggest gripes was losing direct mySQL access. For over a year I’ve been able to ‘get by’ but when a coworker told me about this plugin I immediately installed it. Thanks to Jeremy’s help (run Automate as admin, of course!) I am now whole again and can finally fix some broken dataviews. Thank you for all you do Automation Theory!
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.