ConnectWise Automate runs off of MySQL, which is an open-source relational database management system or RDBMS. Everything done in Automate is stored within this database. When problems arise or corrupt data is entered, it can be fixed by directly accessing the database. The official tool to access the database is SQLyog. This is an open source tool and can be downloaded for free, although a paid version is available. Fortunately, to work with the Automate database, only the free version is needed. Any user can connect directly to the Automate database using this tool as long as they have the SuperAdmin permission. Additionally, the address is localhost, the port is 3306, and the database is labtech. If the database is not specified, all databases will be shown upon login.
While looking through the hierarchy can be useful in learning where data is stored within the database for building monitors and scripts, it is not recommended to change anything within the database. Making changes could cause damage to the database and possibly cause it to crash. Therefore, only a professional database admin or ConnectWise Automate Support should ever make changes within the database.
ConnectWise Automate backs up the database nightly and keep ten backups at anytime. So if corruption or accidental changes do occur, a recent backup is usually available.