commander

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
The Information tab showing database load and performance data.
The SQL Execution tab showing the results of a query.

Using Database Commander

Get Database Commander

Database Commander is used by 389 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?

4.3
Rated 4.3 out of 5
4.3 out of 5 stars (based on 9 reviews)
Excellent56%
Very good33%
Average0%
Poor11%
Terrible0%

Really easy to use.

Rated 5.0 out of 5
July 13, 2020

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!

Namik Eker

Stable and reliable tool, a must-have!

Rated 5.0 out of 5
July 13, 2020

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.

Greg Wenner

Great tool

Rated 4.0 out of 5
April 26, 2023

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.

Bruce McLean

The game has changed

Rated 5.0 out of 5
January 12, 2023

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!

Mike Boteler

Really bare bones..but better than nothing.

Rated 2.0 out of 5
June 9, 2022

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.

Todd

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.