Automate PostgreSQL & MySQL database management on Linux servers

by Oneclick AI Squad ✓ · 505 views · created 2025-07-18 · DevOps

What this workflow does

This workflow has 14 nodes and runs manually, when you click “Execute workflow”. It uses only n8n's built-in nodes.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Set Parameters (Edit Fields (Set)): sets or maps fields
2. Database Type Check (If): checks a condition and branches into true / false
3. PostgreSQL Action Check (If): checks a condition and branches into true / false
4. MySQL Action Check (If): checks a condition and branches into true / false
5. Install PostgreSQL (SSH): uses SSH
6. PostgreSQL Create Check (If): checks a condition and branches into true / false
7. Install MySQL (SSH): uses SSH
8. MySQL Create Check (If): checks a condition and branches into true / false
9. Format Output (Edit Fields (Set)): sets or maps fields
10. Create PostgreSQL DB (SSH): uses SSH

…plus 3 more steps. See the full node list below.

Before you upgrade to n8n 3.0

Nodes used (4)

• Manual Triggern8n-nodes-base.manualTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• SSHn8n-nodes-base.ssh

From the author

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…

View the original on n8n.io → Check your own copy