Automate PostgreSQL & MySQL Database Management on Linux Servers

This automated n8n workflow efficiently manages the setup, creation, and deletion of PostgreSQL and MySQL databases on a Linux server, executing tasks in approximately 10 seconds. It automates installation, configuration, and user management with support for remote access.

Core Elements Set Parameters** - Defines server details, database type, action, and credentials Type Check** - Confirms the selected database type PostgreSQL Action Check** - Identifies the action for PostgreSQL PostgreSQL Create Check** - Validates creation conditions for PostgreSQL Install PostgreSQL** - Sets up and configures PostgreSQL Create PostgreSQL DB** - Establishes a new PostgreSQL database with user access Delete PostgreSQL DB** - Removes a PostgreSQL database and user MySQL Action Check** - Identifies the action for MySQL MySQL Create Check** - Validates creation conditions for MySQL Install MySQL** - Sets up and configures MySQL Create MySQL DB** - Establishes a new MySQL database with user access Delete MySQL DB** - Removes a MySQL database and user Format Output** - Structures the final workflow output

Getting Started Guide Import the workflow into n8n Adjust parameters in the Set Parameters node Execute the workflow Confirm the database operation on the server

Necessary Requirements SSH-enabled Linux server Root-level access rights

Customization Options Switch db_type between PostgreSQL and MySQL Select action (install, create, delete) via the action parameter Tailor database_name, db_user, and db_password as needed

Features Install Database Server - Deploys PostgreSQL or MySQL with optimal configuration Create Database - Generates new databases with assigned users and permissions Delete Database - Eliminates databases and their associated users

Parameters to Configure server_host: Your Linux server IP address server_user: SSH username (typically 'root') server_password: SSH password db_type: Select 'postgresql' or 'mysql' action: Select 'install', 'create', or 'delete' database_name: Name of the database to create or delete db_user: Database username db_password: Database password

How to Use Copy the JSON code from the artifact Access your n8n workspace Choose "Import from JSON" or "+" → "From JSON" Insert the JSON code Set parameters in the "Set Parameters" node with your server information Run the workflow

Workflow Actions Install: Sets up the database server, enables remote access, and initializes the database Create: Establishes a new database with a specific user Delete: Erases the database and its associated user

The workflow automatically manages Ubuntu/Debian package setup Service initialization and configuration Remote access setup User and permission assignments Authentication configuration

Update the parameters in the "Set Parameters" node with your server specifics and execute the workflow!