Automate PostgreSQL & MySQL Database Management on Linux Servers — n8n Workflow

Medium complexity⚡ Trigger14 nodes💎 Otherby Oneclick AI Squad

Overview

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 Cr

Nodes used

StartFormat OutputMySQL Create CheckDelete MySQL DBSticky Note

Workflow Preview

Core Elements
- Set Parameters - Defines server details, database typ
- Type Check - Confirms the selected database type
- PostgreSQL Action Check - Identifies
⚡
S
Start
S
Set Parameters
D
Database Type Check
P
PostgreSQL Action Check
M
MySQL Action Check
I
Install PostgreSQL
I
Install MySQL
P
PostgreSQL Create Check
M
MySQL Create Check
C
Create PostgreSQL DB
C
Create MySQL DB
D
Delete PostgreSQL DB
D
Delete MySQL DB
F
Format Output
14 nodes18 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a trigger trigger.

  2. 2

    Process

    Data flows through 14 nodes, connecting if, manualtrigger, set.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (14)

ST

Start

manualTrigger

#1
FO

Format Output

set

#2
MY

MySQL Create Check

if

#3
DE

Delete MySQL DB

ssh

#4
ST

Sticky Note

stickyNote

#5

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded automate-postgresql-mysql-database-management-on-linux-servers file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Automate PostgreSQL & MySQL Database Management on Linux Servers", "nodes": [...], ...}

Integrations

ifmanualtriggersetssh

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes14
Complexitymedium
Triggertrigger
CategoryOther

Created by

Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

Tags

ifmanualtriggersetssh
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →