Automate PostgreSQL & MySQL Database Management on Linux Servers

Description

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!