⚙️ Automate PostgreSQL & MySQL database management on Linux servers
⚡ 434 views · ⚙️ DevOps & CI/CD
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!
🔗 Nodes Used
SSH
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File