Quick Automation for Database Setup and Management

This n8n workflow automates the setup, creation, and deletion of PostgreSQL and MySQL databases on a remote server. It begins with a manual trigger to initiate the process, followed by setting parameters such as server credentials, database type, and desired action (install, create, or delete). The workflow then checks the selected database type and performs specific actions accordingly. For PostgreSQL, it can install the database server, create a new database and user, or delete them. Similarly, for MySQL, it handles installation, creation, and deletion tasks. Each step involves executing shell commands over SSH, ensuring seamless remote management. The workflow concludes by formatting the output details into a structured result, making it easy to track performed actions. This setup is practical for automating database environments, ensuring quick deployment, or cleanup routines in development and production environments.